| --! qt:dataset:src | |
| -- SORT_QUERY_RESULTS | |
| set hive.mapred.mode=nonstrict; | |
| EXPLAIN | |
| SELECT a.k, a.c | |
| FROM (SELECT b.key as k, count(1) as c FROM src b GROUP BY b.key) a | |
| WHERE a.k >= 90; | |
| SELECT a.k, a.c | |
| FROM (SELECT b.key as k, count(1) as c FROM src b GROUP BY b.key) a | |
| WHERE a.k >= 90; |