PageRenderTime 209ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 18 lines | 13 code | 5 blank | 0 comment | 0 complexity | a5c1ecde7aab0cdc7d02ea3a7996778d 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 INT, value STRING) STORED AS TEXTFILE;
  4. EXPLAIN
  5. INSERT OVERWRITE TABLE dest1
  6. SELECT src.key, sum(substr(src.value,5))
  7. FROM src
  8. GROUP BY src.key;
  9. INSERT OVERWRITE TABLE dest1
  10. SELECT src.key, sum(substr(src.value,5))
  11. FROM src
  12. GROUP BY src.key;
  13. SELECT dest1.* FROM dest1;