| 字段類型（不區分大小寫） | 對應的Java類型 | 范圍 | 大小 | | --- | --- | --- | --- | |INTEGER| java.lang.Integer | -2147483648 to 2147483647| 4 byte| | UNSIGNED_INT | java.lang.Integer | 0 to 2147483647 | 4 byte | | BIGINT | java.lang.Long | -9223372036854775807 to 9223372036854775807 | 8 byte | | UNSIGNED_LONG | java.lang.Long | 0 to 9223372036854775807 | | TINYINT | java.lang.Byte | -128 to 127 | 1 byte | | UNSIGNED_TINYINT | java.lang.Byte | 0 to 127 | 1 byte | | SMALLINT | java.lang.Short | -32768 to 32767 | 2 byte | | UNSIGNED_SMALLINT | java.lang.Short | 0 to 32767 | 2 byte | | FLOAT | java. lang.Float | -3.402823466E+38 to 3.402823466E+38 | 4 byte | | UNSIGNED_FLOAT | java.lang.Float| -3.402823466E+38 to 3.402823466E+38 | 4 byte | | DOUBLE | java.lang.Double | -1.7976931348623158E+308 to 1.7976931348623158E+308 | 8 byte | | UNSIGNED_DOUBLE | java.lang.Double | 0 to 1.7976931348623158E+308 | 8 byte | | DECIMAL | java.math.BigDecimal | 38 digits | | | | BOOLEAN | java.lang.Boolean | | | | TIME | java.sql.Time| | | | DATE | java.sql.Date| | | | TIMESTAMP | java.sql.Timestamp| | | | UNSIGNED_TIME | java.sql.Time | | | | UNSIGNED_DATE | java.sql.Date | | | | UNSIGNED_TIMESTAMP | java.sql.Timestamp | | | | VARCHAR( precisionInt ) | java.lang.String | | | | CHAR ( precisionInt ) | java.lang.String | | | | BINARY ( precisionInt ) | byte[] | | | | VARBINARY | byte[] | | | <br/> Phoenix支持的數據類型與語法大致如下： ```sql Standard SQL Data Types --標準SQL 數據類型 CREATE、SELECT, UPSERT, DELETE --UPSERT與標準SQL不同 JOINs: Inner and Outer Subqueries Secondary Indexes GROUP BY, ORDER BY, HAVING AVG, COUNT, MIN, MAX, SUM Primary Keys, Constraints CASE, COALESCE VIEWs PERCENT_RANK, LAST|FIRST VALUE UNION ALL Cross Joins Windowing Functions --窗口函數 Transactions --事務 Authorization Replication Management ```