/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/ppd_gby.q

# · text · 12 lines · 10 code · 2 blank · 0 comment · 0 complexity · b68e1d00adcf60b04cbbf6faec7110fc MD5 · raw file 

    

  1. set hive.optimize.ppd=true;
    2. 

  2. 

  3. EXPLAIN
    4. 

  4. SELECT src1.c1 
    5. 

  5. FROM
    6. 

  6. (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
    7. 

  7. WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400'); 
    8. 

  8. 

  9. SELECT src1.c1 
    10. 

  10. FROM
    11. 

  11. (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
    12. 

  12. WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400');
    13.