/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
- set hive.map.aggr=false;
- set hive.groupby.skewindata=true;
- CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string);
- CREATE TABLE dest2(key STRING, val1 INT, val2 INT) partitioned by (ds string);
- EXPLAIN
- FROM src
- INSERT OVERWRITE TABLE dest1 partition(ds='111')
- SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
- INSERT OVERWRITE TABLE dest2 partition(ds='111')
- SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5);
- FROM src
- INSERT OVERWRITE TABLE dest1 partition(ds='111')
- SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
- INSERT OVERWRITE TABLE dest2 partition(ds='111')
- SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5);
- SELECT * from dest1;
- SELECT * from dest2;