15.12 - Smart Load Data Types for Hadoop Tables - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K

The following data types are supported in the Smart Load Wizard for Hadoop tables.

Teradata Data Type Description
BIGINT 8-byte binary integer. There are no additional options.
DATE A date consisting of year/month/day. This does not apply to Cloudera systems.
DOUBLE Floating-point data type. There are no additional options.
FLOAT Floating point number
INT 32-bit binary integer. There are no additional options.
SMALLINT 16-bit binary integer. There are no additional options.
STRING Character string.
TIMESTAMP A timestamp consisting of year/month/day/hour/minute/second/fractional second.

Cloudera systems can also use year/month/day.

TINYINT 8-bit binary integer. There are no additional options.