
set hive.enforce.bucketing=true;
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

create temporary table emp1_temp (id int, name string, dept int, country string) row format delimited fields terminated by '|' stored as textfile;
load data local inpath '../../data/files/employee_part.txt' overwrite into table emp1_temp;
select * from emp1_temp order by id;

set hive.blobstore.supported.schemes=pfile;
-- Setting pfile to be treated as blobstore to test mvFileToFinalPath() behavior for blobstore case
-- inserts into non-partitioned/non-bucketed table
create temporary table emp2_temp (id int, name string, dept int, country string) stored as textfile;
insert overwrite table emp2_temp select * from emp1_temp;
select * from emp2_temp order by id;

-- inserts into partitioned/bucketed table
create temporary table emp1_temp_part_bucket_temp (id int, name string) partitioned by (dept int, country string) clustered by (id) into 4 buckets;
insert overwrite table emp1_temp_part_bucket_temp partition (dept, country) select * from emp1_temp;
show partitions emp1_temp_part_bucket_temp;
select * from emp1_temp_part_bucket_temp order by id;