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 MaxComputeData type of HiveData type of OracleData type of MySQL
BOOLEANBOOLEANNone
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.
TINYINTTINYINTNUMBER(3,0)TINYINT
SMALLINTSMALLINTNUMBER(5,0)SMALLINT
INTINTNUMBER(7,0)MEDIUMINT
INTINTNUMBER(10,0)INT
BIGINTBIGINTNUMBER(20,0)BIGINT
FLOATFLOATBINARY_FLOAT
Note This data type is supported in Oracle Database 10g and later.
FLOAT
DOUBLEDOUBLEBINARY_DOUBLE
Note This data type is supported in Oracle Database 10g and later.
DOUBLE
DECIMALDECIMALNUMBER(P,S)
  • DECIMAL
  • NUMERIC
STRINGSTRING
  • VARCHAR
  • VARCHAR2
  • CHAR
  • NCHAR
  • NVARCHAR3
  • VARCHAR
  • CHAR
VARCHARVARCHAR
  • VARCHAR
  • VARCHAR2
  • CHAR
  • NCHAR
  • NVARCHAR3
VARCHAR
STRINGCHARCHARCHAR
BINARYBINARYRAW
  • BINARY
  • VARBINARY
TIMESTAMPTIMESTAMPTIMESTAMP(N)TIMESTAMP
DATEDATEDATEDATE
DATETIMEDATEDATEDATETIME
ARRAYARRAYNot supportedNot supported
MAPMAP<key,value>Not supportedNot supported
STRUCTSTRUCTNot supportedNot supported
Not supportedUNIONNot supportedNot supported