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

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

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.