PageRenderTime 198ms CodeModel.GetById 30ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 14 lines | 12 code | 2 blank | 0 comment | 0 complexity | 918e435633f699bbbe7cad9dcb328997 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

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

  2. 

  3. EXPLAIN
    4. 

  4. SELECT max(src1.c1), src1.c2 
    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. GROUP BY src1.c2; 
    9. 

  9. 

  10. SELECT max(src1.c1), src1.c2 
    11. 

  11. FROM
    12. 

  12. (SELECT src.value AS c1, count(src.key) AS c2 FROM src WHERE src.value > 'val_10' GROUP BY src.value) src1
    13. 

  13. WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
    14. 

  14. GROUP BY src1.c2; 
    15. 

  15.