| --! qt:dataset:src |
| SET hive.vectorized.execution.enabled=false; |
| set hive.mapred.mode=nonstrict; |
| -- SORT_QUERY_RESULTS |
| |
| create table test_n9 (key int, value string) partitioned by (p int) stored as textfile; |
| |
| insert into table test_n9 partition (p=1) select * from src order by key limit 10; |
| |
| alter table test_n9 set fileformat orc; |
| |
| insert into table test_n9 partition (p=2) select * from src order by key limit 10; |
| |
| describe test_n9; |
| |
| select * from test_n9 where p=1 and key > 0 order by key; |
| select * from test_n9 where p=2 and key > 0 order by key; |
| select * from test_n9 where key > 0 order by key; |
| |
