/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

  1. set hive.optimize.ppd=true;
  2. EXPLAIN
  3. SELECT max(src1.c1), src1.c2
  4. FROM
  5. (SELECT src.value AS c1, count(src.key) AS c2 FROM src WHERE src.value > 'val_10' GROUP BY src.value) src1
  6. WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
  7. GROUP BY src1.c2;
  8. SELECT max(src1.c1), src1.c2
  9. FROM
  10. (SELECT src.value AS c1, count(src.key) AS c2 FROM src WHERE src.value > 'val_10' GROUP BY src.value) src1
  11. WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
  12. GROUP BY src1.c2;