| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.limit.pushdown.memory.usage=0.3f; |
| |
| -- negative, RS + join |
| explain select * from src a join src b on a.key=b.key limit 20; |
| |
| -- negative, RS + filter |
| explain select value, sum(key) as sum from src group by value having sum > 100 limit 20; |
| |
| -- negative, RS + lateral view |
| explain select key, L.* from (select * from src order by key) a lateral view explode(array(value, value)) L as v limit 10; |
| |
| -- negative, RS + forward + multi-groupby |
| CREATE TABLE dest_2(key STRING, c1 INT); |
| CREATE TABLE dest_3(key STRING, c1 INT); |
| |
| EXPLAIN FROM src |
| INSERT OVERWRITE TABLE dest_2 SELECT value, sum(key) GROUP BY value |
| INSERT OVERWRITE TABLE dest_3 SELECT value, sum(key) GROUP BY value limit 20; |