| --! qt:dataset:src |
| -- due to testMTQueries1 |
| set hive.stats.column.autogather=false; |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| set hive.map.aggr=false; |
| set hive.groupby.skewindata=true; |
| |
| -- SORT_QUERY_RESULTS |
| |
| CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE; |
| |
| set fs.default.name=invalidscheme:///; |
| |
| EXPLAIN |
| FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key; |
| |
| set fs.default.name=file:///; |
| |
| FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key; |
| |
| SELECT dest_g1.* FROM dest_g1; |