/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/groupby6.q
text | 15 lines | 9 code | 6 blank | 0 comment | 0 complexity | e5601351d40a19d6ad3c58269d915788 MD5 | raw file
1set hive.map.aggr=false; 2set hive.groupby.skewindata=true; 3 4CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE; 5 6EXPLAIN 7FROM src 8INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1); 9 10FROM src 11INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1); 12 13SELECT dest1.* FROM dest1; 14 15