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 |