blob: 10a3e73afa7e737b7d7c388f2c84a3b2f34e5c5b [file] [log] [blame]
--! qt:dataset:alltypesorc
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.fetch.task.conversion=none;
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
DROP TABLE orc_llap_n1;
CREATE TABLE orc_llap_n1 (
cint INT,
cbigint BIGINT,
cfloat FLOAT,
cdouble DOUBLE)
partitioned by (csmallint smallint)
clustered by (cint) into 2 buckets stored as orc;
insert into table orc_llap_n1 partition (csmallint = 1)
select cint, cbigint, cfloat, cdouble from alltypesorc
where cdouble is not null order by cdouble asc limit 10;
insert into table orc_llap_n1 partition (csmallint = 2)
select cint, cbigint, cfloat, cdouble from alltypesorc
where cdouble is not null order by cdouble asc limit 10;
alter table orc_llap_n1 SET TBLPROPERTIES ('transactional'='true');
insert into table orc_llap_n1 partition (csmallint = 3)
select cint, cbigint, cfloat, cdouble from alltypesorc
where cdouble is not null order by cdouble desc limit 10;
SET hive.llap.io.enabled=true;
explain vectorization only detail
select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order
by csmallint, cint;
select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order
by csmallint, cint;
insert into table orc_llap_n1 partition (csmallint = 1) values (1, 1, 1, 1);
explain vectorization only detail
update orc_llap_n1 set cbigint = 2 where cint = 1;
update orc_llap_n1 set cbigint = 2 where cint = 1;
explain vectorization only detail
select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order
by csmallint, cint;
select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order
by csmallint, cint;
DROP TABLE orc_llap_n1;