/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
- set hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;
- set mapred.min.split.size=256;
- set mapred.min.split.size.per.node=256;
- set mapred.min.split.size.per.rack=256;
- set mapred.max.split.size=256;
- set hive.exec.dynamic.partition=true;
- set hive.exec.dynamic.partition.mode=nonstrict;
- set mapred.cache.shared.enabled=false;
- set hive.merge.smallfiles.avgsize=0;
- create table combine2(key string) partitioned by (value string);
- insert overwrite table combine2 partition(value)
- select * from (
- select key, value from src where key < 10
- union all
- select key, '|' as value from src where key = 11
- union all
- select key, '2010-04-21 09:45:00' value from src where key = 19) s;
- show partitions combine2;
- explain
- select key, value from combine2 where value is not null order by key;
- select key, value from combine2 where value is not null order by key;
- explain extended
- select count(1) from combine2 where value is not null;
- select count(1) from combine2 where value is not null;
- explain
- select ds, count(1) from srcpart where ds is not null group by ds;
- select ds, count(1) from srcpart where ds is not null group by ds;