Table of Contents

Search

Avro Amazon S3 File Data Types and Transformation Data Types

Avro Amazon S3 File Data Types and Transformation Data Types

Avro Amazon S3 file data types map to transformation data types that the Data Integration Service uses to move data across platforms.
The following table lists the Avro Amazon S3 file data types that the Data Integration Service supports and the corresponding transformation data types:
Amazon S3 File Data Type
Transformation Data Type
Range and Description
Boolean
Integer
TRUE (1) or FALSE (0)
Bytes
Binary
Precision 4000
Double
Double
Precision 15
Float
Double
Precision 15
Int
Integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Long
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Null
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
String
String
-1 to 104,857,600 characters


Updated July 30, 2020