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

--! qt:dataset:srcpart
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
--HIVE-3926 PPD on virtual column of partitioned table is not working

explain extended
select * from srcpart where BLOCK__OFFSET__INSIDE__FILE<100;
select * from srcpart where BLOCK__OFFSET__INSIDE__FILE<100;

explain extended
select b.* from src a join
  (select *,BLOCK__OFFSET__INSIDE__FILE from srcpart where BLOCK__OFFSET__INSIDE__FILE<100) b
    on a.key=b.key AND b.BLOCK__OFFSET__INSIDE__FILE<50 order by ds,hr,BLOCK__OFFSET__INSIDE__FILE;

select b.* from src a join
  (select *,BLOCK__OFFSET__INSIDE__FILE from srcpart where BLOCK__OFFSET__INSIDE__FILE<100) b
    on a.key=b.key AND b.BLOCK__OFFSET__INSIDE__FILE<50 order by ds,hr,BLOCK__OFFSET__INSIDE__FILE;