| --! qt:dataset: | |
| -- SORT_QUERY_RESULTS | |
| set hive.enforce.bucketing=true; | |
| set hive.enforce.sorting=true; | |
| set hive.optimize.bucketingsorting=true; | |
| create table bucket1 (id int, val string) clustered by (id) sorted by (id ASC) INTO 4 BUCKETS; | |
| insert into bucket1 values (1, 'abc'), (3, 'abc'); | |
| select * from bucket1; | |
| create table bucket2 like bucket1; | |
| insert overwrite table bucket2 select * from bucket1; | |
| select * from bucket2; |