Amazon Athena Connector

Amazon Athena Connector

Amazon Athena and transformation data types

Amazon Athena and transformation data types

The following table lists the Amazon Athena native data types that
Data Integration
supports and the corresponding transformation data types:
Amazon Athena Data Type
Transformation Data Type
Description
Bigint
Bigint
Signed eight-byte integer
Binary
Binary
1 to 104,857,600 bytes
Boolean
Integer
Logical Boolean (true/false)
Char
String
Fixed-length character string
Date
Date/Time
Calendar date (year, month, day)
Decimal
Decimal
Exact numeric of selectable precision
Double
Double
Precision 15
Float
Double
Precision 15
Int
Integer
Signed four-byte integer
Smallint
Integer
Signed two-byte integer
String
String
-1 to 104,857,600 characters
Timestamp
Date/Time
Date and time (without time zone)
Tinyint
Integer
Signed one-byte integer
Varchar
String
Variable-length character string with a user-defined limit
You can use the Binary data type only with Parquet files.