Data Types Supported by the Vectorized Executor
Table 1 lists the data types supported by the vectorized executor.
Category |
Data Type |
Length |
Supported or Not |
---|---|---|---|
Numeric Types |
tinyint [unsigned] |
1 |
Supported |
smallint [unsigned] |
2 |
Supported |
|
mediumint [unsigned] |
3 |
Supported |
|
integer [unsigned] |
4 |
Supported |
|
bigint [unsigned] |
8 |
Supported |
|
decimal |
-1 |
Supported |
|
numeric |
-1 |
Supported |
|
real |
4 |
Supported |
|
double precision |
8 |
Supported |
|
smallserial |
2 |
Supported |
|
serial |
4 |
Supported |
|
bigserial |
8 |
Supported |
|
largeserial |
-1 |
Supported |
|
Monetary Types |
money |
8 |
Supported |
Boolean Types |
boolean |
1 |
Supported |
Character Types |
character varying(n), varchar(n) |
-1 |
Supported |
character(n), char(n),nchar(n) |
n |
Supported |
|
character, char |
1 |
Supported |
|
text |
-1 |
Supported |
|
varchar2(n) |
-1 |
Supported |
|
nvarchar2(n) |
-1 |
Supported |
|
clob |
-1 |
Supported |
|
Binary Types |
raw |
-1 |
Supported |
bytea |
-1 |
Supported |
|
Bit String Types |
bit(n) |
n |
Supported |
bit varying(n) |
-1 |
Supported |
|
Date/Time Types |
timestamp with time zone |
8 |
Supported |
timestamp without time zone |
8 |
Supported |
|
date |
4 |
Supported |
|
time without time zone |
8 |
Supported |
|
time with time zone |
12 |
Supported |
|
interval |
16 |
Supported |
|
Network Address Types |
cidr |
7 or 19 |
Supported |
inet |
7 or 19 |
Supported |
|
XML Types |
xml |
-1 |
Supported |
Other Types |
enum |
An enumerated type is a list of one or more quoted labels, each of which must be 1 to 63 bytes long. |
Supported |

CREATE TYPE name AS ENUM (['label' [, ...]]);
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot