create table text_test (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp);
load data local inpath '../../data/files/kv1.txt' into table text_test;

set hive.default.fileformat=ORC;
create table orc_test (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp);
load data inpath '${hiveconf:hive.metastore.warehouse.dir}/text_test/kv1.txt' into table orc_test;