| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| SET hive.vectorized.execution.enabled = true; |
| set hive.fetch.task.conversion=none; |
| SET hive.auto.convert.join=true; |
| SET hive.auto.convert.join.noconditionaltask=true; |
| SET hive.auto.convert.join.noconditionaltask.size=1000000000; |
| |
| -- HIVE-12738 -- We are checking if a MapJoin after a GroupBy will work properly. |
| explain vectorization expression |
| select * |
| from src |
| where not key in |
| (select key from src) |
| order by key; |
| |
| select * |
| from src |
| where not key in |
| (select key from src) |
| order by key; |
| |
| CREATE TABLE orcsrc STORED AS ORC AS SELECT * FROM src; |
| |
| select * |
| from orcsrc |
| where not key in |
| (select key from orcsrc) |
| order by key; |
| |
| select * |
| from orcsrc |
| where not key in |
| (select key from orcsrc) |
| order by key; |