PageRenderTime 36ms CodeModel.GetById 11ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 36 lines | 27 code | 9 blank | 0 comment | 0 complexity | 522e03cac18486963ee05fdc8e8f277e MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. set hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;
  2. set mapred.min.split.size=256;
  3. set mapred.min.split.size.per.node=256;
  4. set mapred.min.split.size.per.rack=256;
  5. set mapred.max.split.size=256;
  6. set hive.exec.dynamic.partition=true;
  7. set hive.exec.dynamic.partition.mode=nonstrict;
  8. set mapred.cache.shared.enabled=false;
  9. set hive.merge.smallfiles.avgsize=0;
  10. create table combine2(key string) partitioned by (value string);
  11. insert overwrite table combine2 partition(value)
  12. select * from (
  13. select key, value from src where key < 10
  14. union all
  15. select key, '|' as value from src where key = 11
  16. union all
  17. select key, '2010-04-21 09:45:00' value from src where key = 19) s;
  18. show partitions combine2;
  19. explain
  20. select key, value from combine2 where value is not null order by key;
  21. select key, value from combine2 where value is not null order by key;
  22. explain extended
  23. select count(1) from combine2 where value is not null;
  24. select count(1) from combine2 where value is not null;
  25. explain
  26. select ds, count(1) from srcpart where ds is not null group by ds;
  27. select ds, count(1) from srcpart where ds is not null group by ds;