| |
| set hive.enforce.bucketing=true; |
| set hive.exec.dynamic.partition=true; |
| |
| create table emp1 (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; |
| select * from emp1 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 table emp2 (id int, name string, dept int, country string) stored as textfile; |
| insert overwrite table emp2 select * from emp1; |
| select * from emp2 order by id; |
| |
| -- inserts into partitioned/bucketed table |
| create table emp1_part_bucket (id int, name string) partitioned by (dept int, country string) clustered by (id) into 4 buckets; |
| insert overwrite table emp1_part_bucket partition (dept, country) select * from emp1; |
| show partitions emp1_part_bucket; |
| select * from emp1_part_bucket order by id; |