blob: 91565c7030af3b0dcb5d593938b75a783e2275c8 [file] [log] [blame]
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
EXPLAIN SELECT subq.key, tab.value FROM (select a.key, a.value from src a where a.key > 10 ) subq JOIN src tab ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) where tab.value < 200;