Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: edits to "Seeing whether vectorization is used for a query"

...

You can verify which parts of your query are being vectorized using the explain feature. When For example, when Fetch is used in the plan instead of Map, it do not vectorize, For example see belowdoes not vectorize and the explain output will not include the "Vectorized execution: true" notation:

Code Block
sql
sql
create table vectorizedtable(state string,id int) stored as orc ;

insert into vectorizedtable values('haryana',1);
set hive.vectorized.execution.enabled = true;
explain select count(*) from vectorizedtable;
 

the The explain output contains this:

...

Note: In case you want to use  vectorized vectorized execution for fetch then 

set hive.fetch.task.conversion=none

Limitations

  • Timestamps only work correctly with vectorized execution if the timestamp value is between 1677-09-20 and 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 HIVE-9862.

...