EXPLAIN SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100; SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100;