set hive.vectorized.execution.enabled=false;
set hive.mapred.mode=nonstrict;
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.optimize.index.filter=true;
set hive.cbo.enable=false;

create table test_acid( i int, ts timestamp)
                      clustered by (i) into 2 buckets
                      stored as orc
                      tblproperties ('transactional'='true');
insert into table test_acid values (1, '2014-09-14 12:34:30');
delete from test_acid where ts = '2014-15-16 17:18:19.20';
select i,ts from test_acid where ts = '2014-15-16 17:18:19.20';
select i,ts from test_acid where ts <= '2014-09-14 12:34:30';

drop table test_acid;
set hive.exec.orc.delta.streaming.optimizations.enabled=true;

create table test_acid( i int, ts timestamp)
                      clustered by (i) into 2 buckets
                      stored as orc
                      tblproperties ('transactional'='true');
insert into table test_acid values (1, '2014-09-14 12:34:30');
delete from test_acid where ts = '2014-15-16 17:18:19.20';
select i,ts from test_acid where ts = '2014-15-16 17:18:19.20';
select i,ts from test_acid where ts <= '2014-09-14 12:34:30';