向量化引擎支持的数据类型
向量化引擎支持的数据类型如表1所示。
| 类别 | 数据类型 | 长度 |
|---|---|---|
| Numeric Types | tinyint [unsigned] | 1 |
| smallint [unsigned] | 2 | |
| mediumint [unsigned] | 3 | |
| integer [unsigned] | 4 | |
| bigint [unsigned] | 8 | |
| int16 [signed] | 16 | |
| decimal | -1 | |
| numeric | -1 | |
| real | 4 | |
| double precision | 8 | |
| smallserial | 2 | |
| serial | 4 | |
| bigserial | 8 | |
| largeserial | -1 | |
| Monetary Types | money | 8 |
| Boolean Types | boolean | 1 |
| Character Types | character varying(n), varchar(n) | -1 |
| character(n), char(n),nchar(n) | n | |
| character、char | 1 | |
| text | -1 | |
| varchar2(n) | -1 | |
| nvarchar2(n) | -1 | |
| clob | -1 | |
| Binary Types | blob | -1 |
| raw | -1 | |
| bytea | -1 | |
| byteawithoutorderwithequalcol | -1 | |
| byteawithoutordercol | -1 | |
| Bit String Types | bit(n) | n |
| bit varying(n) | -1 | |
| Date/Time Types | timestamp with time zone | 8 |
| timestamp without time zone | 8 | |
| date | 4 | |
| time without time zone | 8 | |
| time with time zone | 12 | |
| smalldatetime | 8 | |
| interval | 16 | |
| reltime | 4 | |
| abstime | 4 | |
| datea | 8 | |
| Network Address Types | cidr | 7 or 19 |
| inet | 7 or 19 | |
| Text Retrieval Types | tsvector | -1 |
| tsquery | -1 | |
| JSON Types | json | -1 |
| jsonb | -1 | |
| HyperLoglog Types | hll | -1 |
| Range Types | int4range | -1 |
| int8range | -1 | |
| numrange | -1 | |
| tsrange | -1 | |
| tstzrange | -1 | |
| daterange | -1 | |
| Object Identifier Types | OID | 4 |
| CID | 4 | |
| XID | 8 | |
| TID | 8 | |
| regconfig | 4 | |
| regdictionary | 4 | |
| regoper | 4 | |
| regoperator | 4 | |
| regproc | 4 | |
| regprocedure | 4 | |
| regclass | 4 | |
| regtype | 4 | |
| Pseudo Types | anyelement | 4 |
| anynonarray | 4 | |
| anyrange | -1 | |
| cstring | -2 | |
| record | -1 | |
| void | 4 | |
| XML Types | xml | -1 |
| XMLTYPE Types | xmltype | -1 |
| Hash Types | hash16 | 8 |
| Array Types | tinyint[] | -1 |
| smallint[] | -1 | |
| mediumint[] | -1 | |
| integer[] | -1 | |
| bigint[] | -1 | |
| int16[] | -1 | |
| decimal[] | -1 | |
| numeric[] | -1 | |
| real[] | -1 | |
| double precision[] | -1 | |
| money[] | -1 | |
| boolean[] | -1 | |
| varchar[] | -1 | |
| char(n)[] | -1 | |
| char[] | -1 | |
| text[] | -1 | |
| varchar2(n)[] | -1 | |
| nvarchar2(n)[] | -1 | |
| clob[] | -1 | |
| blob[] | -1 | |
| raw[] | -1 | |
| bytea[] | -1 | |
| byteawithoutorderwithequalcol[] | -1 | |
| byteawithoutordercol[] | -1 | |
| bit(n)[] | -1 | |
| bit varying(n)[] | -1 | |
| timestamp with time zone[] | -1 | |
| timestamp without time zone[] | -1 | |
| date[] | -1 | |
| time without time zone[] | -1 | |
| time with time zone[] | -1 | |
| smalldatetime[] | -1 | |
| interval[] | -1 | |
| reltime[] | -1 | |
| abstime[] | -1 | |
| datea[] | -1 | |
| cidr[] | -1 | |
| inet[] | -1 | |
| tsvector[] | -1 | |
| tsquery[] | -1 | |
| json[] | -1 | |
| jsonb[] | -1 | |
| hll[] | -1 | |
| int4range[] | -1 | |
| int8range[] | -1 | |
| numrange[] | -1 | |
| tsrange[] | -1 | |
| tstzrange[] | -1 | |
| daterange[] | -1 | |
| OID[] | -1 | |
| CID[] | -1 | |
| XID[] | -1 | |
| TID[] | -1 | |
| regconfig[] | -1 | |
| regdictionary[] | -1 | |
| regoper[] | -1 | |
| regoperator[] | -1 | |
| regproc[] | -1 | |
| regprocedure[] | -1 | |
| regclass[] | -1 | |
| regtype[] | -1 | |
| cstring[] | -1 | |
| record[] | -1 | |
| xml[] | -1 | |
| xmltype[] | -1 | |
| hash16[] | -1 | |
| hash32[] | -1 | |
| aclitem[] | -1 | |
| name[] | -1 | |
| macaddr[] | -1 | |
| UUID[] | -1 | |
| point[] | -1 | |
| lseg[] | -1 | |
| box[] | -1 | |
| path[] | -1 | |
| polygon[] | -1 | |
| circle[] | -1 | |
| Vector Types | floatvector | -1 |
| boolvector | -1 | |
| Other Types | enum | enum 类型由若干个标签构成的列表，每一个标签值都是一个非空字符串，且字符串长度必须不超过63个字节。 |
