| --! qt:dataset:alltypesorc |
| |
| set hive.vectorized.execution.enabled=false; |
| set hive.mapred.mode=nonstrict; |
| SET hive.vectorized.execution.enabled=true; |
| |
| SET hive.llap.io.enabled=false; |
| |
| SET hive.exec.orc.default.buffer.size=32768; |
| SET hive.exec.orc.default.row.index.stride=1000; |
| SET hive.optimize.index.filter=true; |
| set hive.auto.convert.join=false; |
| set hive.fetch.task.conversion=none; |
| |
| DROP TABLE orc_create_staging_n3; |
| DROP TABLE orc_create_complex; |
| DROP TABLE orc_llap_nonvector; |
| |
| |
| CREATE TABLE orc_create_staging_n3 ( |
| str STRING, |
| mp MAP<STRING,STRING>, |
| lst ARRAY<STRING>, |
| strct STRUCT<A:STRING,B:STRING> |
| ) ROW FORMAT DELIMITED |
| FIELDS TERMINATED BY '|' |
| COLLECTION ITEMS TERMINATED BY ',' |
| MAP KEYS TERMINATED BY ':'; |
| LOAD DATA LOCAL INPATH '../../data/files/orc_create.txt' OVERWRITE INTO TABLE orc_create_staging_n3; |
| |
| create table orc_llap_nonvector stored as orc as select *, rand(1234) rdm from alltypesorc order by rdm; |
| |
| SET hive.llap.io.enabled=true; |
| set hive.auto.convert.join=true; |
| SET hive.vectorized.execution.enabled=false; |
| |
| explain |
| select * from orc_llap_nonvector limit 100; |
| select * from orc_llap_nonvector limit 100; |
| explain |
| select cint, cstring1 from orc_llap_nonvector limit 1025; |
| select cint, cstring1 from orc_llap_nonvector limit 1025; |
| |
| set hive.support.concurrency=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| |
| create table orc_llap_nonvector_2 stored as orc tblproperties('transactional'='true') as |
| select *, rand(1234) rdm from alltypesorc order by rdm; |
| |
| explain |
| select ROW__ID from orc_llap_nonvector_2 limit 10; |
| select ROW__ID from orc_llap_nonvector_2 limit 10; |
| |
| DROP TABLE orc_create_staging_n3; |
| DROP TABLE orc_llap_nonvector; |
| DROP TABLE orc_llap_nonvector_2; |