--! 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;