PageRenderTime 45ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  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;