--! qt:dataset:src | |
set hive.mapred.mode=nonstrict; | |
explain | |
select * from src tablesample (10 rows) where lower(key) in (select key from src); | |
select * from src tablesample (10 rows) where lower(key) in (select key from src); | |
explain | |
select * from src tablesample (10 rows) where concat(key,value) not in (select key from src); | |
select * from src tablesample (10 rows) where concat(key,value) not in (select key from src); |