--! qt:dataset:alltypesorc
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.fetch.task.conversion=none;
set hive.limit.optimize.enable=true;
set hive.mapred.mode=nonstrict;
-- Global Limit optimization does not work with ACID table. Make sure to skip it for ACID table.
CREATE TABLE acidtest1(c1 INT, c2 STRING)
CLUSTERED BY (c1) INTO 3 BUCKETS
STORED AS ORC
TBLPROPERTIES ("transactional"="true");

insert into table acidtest1 select cint, cstring1 from alltypesorc where cint is not null order by cint;

select cast (c1 as string) from acidtest1 order by c1 limit 10;

drop table acidtest1;