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

# · text · 27 lines · 17 code · 10 blank · 0 comment · 0 complexity · fa44bbb8a4164ec6965c0e62ba9cec6b MD5 · raw file

  1. set hive.map.aggr=false;
  2. set hive.groupby.skewindata=true;
  3. CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string);
  4. CREATE TABLE dest2(key STRING, val1 INT, val2 INT) partitioned by (ds string);
  5. EXPLAIN
  6. FROM src
  7. INSERT OVERWRITE TABLE dest1 partition(ds='111')
  8. SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
  9. INSERT OVERWRITE TABLE dest2 partition(ds='111')
  10. SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5);
  11. FROM src
  12. INSERT OVERWRITE TABLE dest1 partition(ds='111')
  13. SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
  14. INSERT OVERWRITE TABLE dest2 partition(ds='111')
  15. SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5);
  16. SELECT * from dest1;
  17. SELECT * from dest2;