Smart Load Data Types for Hadoop Tables | Teradata Studio/Studio Express - Smart Load Data Types for Hadoop Tables - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
ovm1576517377363.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.