ql/src/test/queries/clientpositive/ppd_udtf.q

--! qt:dataset:src
explain
SELECT value from (
  select explode(array(key, value)) as (value) from (
    select * FROM src WHERE key > 400
  ) A
) B WHERE value < 450;

SELECT value from (
  select explode(array(key, value)) as (value) from (
    select * FROM src WHERE key > 400
  ) A
) B WHERE value < 450;