| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| drop table push_or; |
| |
| create table push_or (key int, value string) partitioned by (ds string); |
| |
| insert overwrite table push_or partition (ds='2000-04-08') select * from src where key < 20 order by key; |
| insert overwrite table push_or partition (ds='2000-04-09') select * from src where key < 20 order by key; |
| |
| explain extended select key, value, ds from push_or where ds='2000-04-09' or key=5 order by key, ds; |
| select key, value, ds from push_or where ds='2000-04-09' or key=5 order by key, ds; |
| |