Description of data sets :

lineitem_single : create table lineitem_auto partition by (l_moddate) as select l.*, l_shipdate - extract(day from l_shipdate) + 1 l_moddate from cp.tpch/lineitem.parquet l; item_single : (original item.parquet is generated by hive) 1.9 : create table item_auto partition by (i_rec_start_date) as select * from item where i_item_sk between 1 and 5000; 1.6 : create table item_auto partition by (i_rec_start_date) as select * from item where i_item_sk between 5000 and 12000; 1.2 : create table item_auto partition by (i_rec_start_date) as select * from item where i_item_sk between 12000 and 18000; item_multidatepartition : 1.9 : create table item_multidate partition by (i_rec_start_date, i_rec_end_date) as select * from item where i_item_sk between 1 and 5000; 1.6 : create table item_multidate partition by (i_rec_start_date, i_rec_end_date) as select * from item where i_item_sk between 5000 and 12000;

item_multipart : generated using drill 1.6 : create table item_multipart partition by (i_rec_start_date, i_size) as select * from item where i_size is not null;