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.
MaxCompute data type | Hive data type | Oracle data type | MySQL data type |
---|---|---|---|
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 |
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 |