Microsoft Azure Data Lake Storage Gen2 Connector > Microsoft Azure Data Lake Storage Gen2 data type reference > ORC data types and transformation data types
  

ORC data types and transformation data types

ORC file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the ORC file data types that the Secure Agent supports and the corresponding transformation data types:
ORC 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
Precision 4000
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