You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by we...@apache.org on 2017/09/07 05:59:01 UTC
[47/50] [abbrv] hive git commit: HIVE-14671 : merge master into
hive-14535 (Wei Zheng)
http://git-wip-us.apache.org/repos/asf/hive/blob/42a38577/ql/src/test/queries/clientpositive/mm_loaddata.q
----------------------------------------------------------------------
diff --cc ql/src/test/queries/clientpositive/mm_loaddata.q
index 0000000,0000000..7e5787f
new file mode 100644
--- /dev/null
+++ b/ql/src/test/queries/clientpositive/mm_loaddata.q
@@@ -1,0 -1,0 +1,53 @@@
++set hive.mapred.mode=nonstrict;
++set hive.explain.user=false;
++set hive.fetch.task.conversion=none;
++set tez.grouping.min-size=1;
++set tez.grouping.max-size=2;
++set hive.exec.dynamic.partition.mode=nonstrict;
++set hive.support.concurrency=true;
++set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
++
++
++drop table load0_mm;
++create table load0_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only");
++load data local inpath '../../data/files/kv1.txt' into table load0_mm;
++select count(1) from load0_mm;
++load data local inpath '../../data/files/kv2.txt' into table load0_mm;
++select count(1) from load0_mm;
++load data local inpath '../../data/files/kv2.txt' overwrite into table load0_mm;
++select count(1) from load0_mm;
++drop table load0_mm;
++
++
++drop table intermediate2;
++create table intermediate2 (key string, value string) stored as textfile
++location 'file:${system:test.tmp.dir}/intermediate2';
++load data local inpath '../../data/files/kv1.txt' into table intermediate2;
++load data local inpath '../../data/files/kv2.txt' into table intermediate2;
++load data local inpath '../../data/files/kv3.txt' into table intermediate2;
++
++drop table load1_mm;
++create table load1_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only");
++load data inpath 'file:${system:test.tmp.dir}/intermediate2/kv2.txt' into table load1_mm;
++load data inpath 'file:${system:test.tmp.dir}/intermediate2/kv1.txt' into table load1_mm;
++select count(1) from load1_mm;
++load data local inpath '../../data/files/kv1.txt' into table intermediate2;
++load data local inpath '../../data/files/kv2.txt' into table intermediate2;
++load data local inpath '../../data/files/kv3.txt' into table intermediate2;
++load data inpath 'file:${system:test.tmp.dir}/intermediate2/kv*.txt' overwrite into table load1_mm;
++select count(1) from load1_mm;
++load data local inpath '../../data/files/kv2.txt' into table intermediate2;
++load data inpath 'file:${system:test.tmp.dir}/intermediate2/kv2.txt' overwrite into table load1_mm;
++select count(1) from load1_mm;
++drop table load1_mm;
++
++drop table load2_mm;
++create table load2_mm (key string, value string)
++ partitioned by (k int, l int) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only");
++load data local inpath '../../data/files/kv1.txt' into table intermediate2;
++load data local inpath '../../data/files/kv2.txt' into table intermediate2;
++load data local inpath '../../data/files/kv3.txt' into table intermediate2;
++load data inpath 'file:${system:test.tmp.dir}/intermediate2/kv*.txt' into table load2_mm partition(k=5, l=5);
++select count(1) from load2_mm;
++drop table load2_mm;
++drop table intermediate2;