This topic describes the data type mappings between MaxCompute and the following components: Hive, Oracle, and MySQL.
The following table lists the data type mappings.
| Data type of MaxCompute | Data type of Hive | Data type of Oracle | Data type of MySQL |
|---|---|---|---|
| BOOLEAN | BOOLEAN | None Note CHAR(1), INTEGER, or NUMBER(1) is used instead. The value 1 indicates true, and the value 0 indicates false. | None Note TINYINT(1) is used instead. |
| TINYINT | TINYINT | NUMBER(3,0) | TINYINT |
| SMALLINT | SMALLINT | NUMBER(5,0) | SMALLINT |
| INT | INT | NUMBER(7,0) | MEDIUMINT |
| INT | INT | NUMBER(10,0) | INT |
| BIGINT | BIGINT | NUMBER(20,0) | BIGINT |
| FLOAT | FLOAT | BINARY_FLOAT Note This data type is supported in Oracle Database 10g and later. | FLOAT |
| DOUBLE | DOUBLE | BINARY_DOUBLE Note This data type is supported in Oracle Database 10g and later. | DOUBLE |
| DECIMAL | DECIMAL | NUMBER(P,S) |
|
| STRING | STRING |
|
|
| VARCHAR | VARCHAR |
| VARCHAR |
| STRING | CHAR | CHAR | CHAR |
| BINARY | BINARY | RAW |
|
| TIMESTAMP | TIMESTAMP | TIMESTAMP(N) | TIMESTAMP |
| DATE | DATE | DATE | DATE |
| DATETIME | DATE | DATE | DATETIME |
| ARRAY | ARRAY | Not supported | Not supported |
| MAP | MAP<key,value> | Not supported | Not supported |
| STRUCT | STRUCT | Not supported | Not supported |
| Not supported | UNION | Not supported | Not supported |