--! qt:dataset:cbo_t1 | |
set hive.optimize.point.lookup.min=2; | |
EXPLAIN | |
SELECT f.key | |
FROM cbo_t1 f | |
WHERE (f.key = '1' OR f.key='2') | |
AND f.key IN ('1', '2'); | |
EXPLAIN | |
SELECT f.key | |
FROM cbo_t1 f | |
WHERE (f.key = '1' OR f.key = '2') | |
AND f.key IN ('1', '2', '3'); | |
EXPLAIN | |
SELECT f.key | |
FROM cbo_t1 f | |
WHERE (f.key = '1' OR f.key='2' OR f.key='3') | |
AND f.key IN ('1', '2'); |