Search

Amazon Athena Connector

Amazon Athena Connector

Back Next

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.

Data type reference

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.