...
The following data types are currently supported for vectorized execution:
tinyint
...
smallint
...
int
...
bigint
...
boolean
...
float
...
double
...
decimal
...
datetimestamp (See limitations below)string
, timestamp, and string. Using other data types will cause your query to execute using standard, row-at-a-time execution.
...
The notation Vectorized execution: true shows that the operator containing that notation is vectorized. Absence of this notation means the operator is not vectorized, and uses the standard row-at-a-time execution path.
Limitations
- Timestamps only work correctly with vectorized execution if the timestamp value is between 1677-09-20 to 2262-04-11. This limitation is due to the fact that a vectorized timestamp value is stored as a long value representing nanoseconds before/after the Unix Epoch time of 1970-01-01 00:00:00 UTC. Also see
.Jira server ASF JIRA key HIVE-9862
Version Information
Vectorized execution is available in Hive 0.13.0 and later (HIVE-5283).