Amazon S3 V2 Connector > Data type reference > ORC Amazon S3 file data types and transformation data types
  

ORC Amazon S3 file data types and transformation data types

ORC Amazon S3 file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the ORC Amazon S3 file data types that the Secure Agent supports and the corresponding transformation data types:
ORC Amazon S3 File Data Type
Transformation Data Type
Range and Description
BigInt
BigInt
-9223372036854775808 to 9,223,372,036,854,775,807
Boolean
Integer
TRUE (1) or FALSE (0)
Char
String
1 to 104,857,600 characters
Date
Date/Time
Jan 1, 1753 A.D. to Dec 31, 4712 A.D.
(precision to microsecond)
Double
Double
Precision of 15 digits
Float
Double
Precision of 15 digits
Integer
Integer
-2,147,483,648 to 2,147,483,647
SmallInt
Integer
-32,768 to 32,767
String
String
1 to 104,857,600 characters
Timestamp
Date/Time
1 to 19 characters
Precision 19 to 26, scale 0 to 6
TinyInt
Integer
-128 to 127
Varchar
String
1 to 104,857,600 characters