| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; |
| ; |
| set hive.exec.reducers.max = 1; |
| set hive.merge.mapredfiles=true; |
| |
| |
| CREATE TABLE bucket2_1_n0(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS; |
| |
| explain extended |
| insert overwrite table bucket2_1_n0 |
| select * from src; |
| |
| insert overwrite table bucket2_1_n0 |
| select * from src; |
| |
| explain |
| select * from bucket2_1_n0 tablesample (bucket 1 out of 2) s order by key; |
| |
| select * from bucket2_1_n0 tablesample (bucket 1 out of 2) s order by key; |
| |
| |