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:58:59 UTC

[45/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/results/clientpositive/mm_loaddata.q.out
----------------------------------------------------------------------
diff --cc ql/src/test/results/clientpositive/mm_loaddata.q.out
index 0000000,0000000..b849a88
new file mode 100644
--- /dev/null
+++ b/ql/src/test/results/clientpositive/mm_loaddata.q.out
@@@ -1,0 -1,0 +1,296 @@@
++PREHOOK: query: drop table load0_mm
++PREHOOK: type: DROPTABLE
++POSTHOOK: query: drop table load0_mm
++POSTHOOK: type: DROPTABLE
++PREHOOK: query: create table load0_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only")
++PREHOOK: type: CREATETABLE
++PREHOOK: Output: database:default
++PREHOOK: Output: default@load0_mm
++POSTHOOK: query: create table load0_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only")
++POSTHOOK: type: CREATETABLE
++POSTHOOK: Output: database:default
++POSTHOOK: Output: default@load0_mm
++PREHOOK: query: load data local inpath '../../data/files/kv1.txt' into table load0_mm
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load0_mm
++POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' into table load0_mm
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load0_mm
++PREHOOK: query: select count(1) from load0_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load0_mm
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load0_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load0_mm
++#### A masked pattern was here ####
++500
++PREHOOK: query: load data local inpath '../../data/files/kv2.txt' into table load0_mm
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load0_mm
++POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' into table load0_mm
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load0_mm
++PREHOOK: query: select count(1) from load0_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load0_mm
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load0_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load0_mm
++#### A masked pattern was here ####
++1000
++PREHOOK: query: load data local inpath '../../data/files/kv2.txt' overwrite into table load0_mm
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load0_mm
++POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' overwrite into table load0_mm
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load0_mm
++PREHOOK: query: select count(1) from load0_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load0_mm
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load0_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load0_mm
++#### A masked pattern was here ####
++500
++PREHOOK: query: drop table load0_mm
++PREHOOK: type: DROPTABLE
++PREHOOK: Input: default@load0_mm
++PREHOOK: Output: default@load0_mm
++POSTHOOK: query: drop table load0_mm
++POSTHOOK: type: DROPTABLE
++POSTHOOK: Input: default@load0_mm
++POSTHOOK: Output: default@load0_mm
++PREHOOK: query: drop table intermediate2
++PREHOOK: type: DROPTABLE
++POSTHOOK: query: drop table intermediate2
++POSTHOOK: type: DROPTABLE
++PREHOOK: query: create table intermediate2 (key string, value string) stored as textfile
++#### A masked pattern was here ####
++PREHOOK: type: CREATETABLE
++#### A masked pattern was here ####
++PREHOOK: Output: database:default
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: create table intermediate2 (key string, value string) stored as textfile
++#### A masked pattern was here ####
++POSTHOOK: type: CREATETABLE
++#### A masked pattern was here ####
++POSTHOOK: Output: database:default
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv1.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv3.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv3.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: drop table load1_mm
++PREHOOK: type: DROPTABLE
++POSTHOOK: query: drop table load1_mm
++POSTHOOK: type: DROPTABLE
++PREHOOK: query: create table load1_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only")
++PREHOOK: type: CREATETABLE
++PREHOOK: Output: database:default
++PREHOOK: Output: default@load1_mm
++POSTHOOK: query: create table load1_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only")
++POSTHOOK: type: CREATETABLE
++POSTHOOK: Output: database:default
++POSTHOOK: Output: default@load1_mm
++#### A masked pattern was here ####
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load1_mm
++#### A masked pattern was here ####
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load1_mm
++PREHOOK: query: select count(1) from load1_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load1_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load1_mm
++#### A masked pattern was here ####
++1000
++PREHOOK: query: load data local inpath '../../data/files/kv1.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv3.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv3.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++#### A masked pattern was here ####
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load1_mm
++PREHOOK: query: select count(1) from load1_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load1_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load1_mm
++#### A masked pattern was here ####
++1050
++PREHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++#### A masked pattern was here ####
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load1_mm
++PREHOOK: query: select count(1) from load1_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load1_mm
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load1_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load1_mm
++#### A masked pattern was here ####
++500
++PREHOOK: query: drop table load1_mm
++PREHOOK: type: DROPTABLE
++PREHOOK: Input: default@load1_mm
++PREHOOK: Output: default@load1_mm
++POSTHOOK: query: drop table load1_mm
++POSTHOOK: type: DROPTABLE
++POSTHOOK: Input: default@load1_mm
++POSTHOOK: Output: default@load1_mm
++PREHOOK: query: drop table load2_mm
++PREHOOK: type: DROPTABLE
++POSTHOOK: query: drop table load2_mm
++POSTHOOK: type: DROPTABLE
++PREHOOK: query: create table load2_mm (key string, value string)
++  partitioned by (k int, l int) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only")
++PREHOOK: type: CREATETABLE
++PREHOOK: Output: database:default
++PREHOOK: Output: default@load2_mm
++POSTHOOK: query: create table load2_mm (key string, value string)
++  partitioned by (k int, l int) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only")
++POSTHOOK: type: CREATETABLE
++POSTHOOK: Output: database:default
++POSTHOOK: Output: default@load2_mm
++PREHOOK: query: load data local inpath '../../data/files/kv1.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++PREHOOK: query: load data local inpath '../../data/files/kv3.txt' into table intermediate2
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: load data local inpath '../../data/files/kv3.txt' into table intermediate2
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@intermediate2
++#### A masked pattern was here ####
++PREHOOK: type: LOAD
++#### A masked pattern was here ####
++PREHOOK: Output: default@load2_mm
++#### A masked pattern was here ####
++POSTHOOK: type: LOAD
++#### A masked pattern was here ####
++POSTHOOK: Output: default@load2_mm
++POSTHOOK: Output: default@load2_mm@k=5/l=5
++PREHOOK: query: select count(1) from load2_mm
++PREHOOK: type: QUERY
++PREHOOK: Input: default@load2_mm
++PREHOOK: Input: default@load2_mm@k=5/l=5
++#### A masked pattern was here ####
++POSTHOOK: query: select count(1) from load2_mm
++POSTHOOK: type: QUERY
++POSTHOOK: Input: default@load2_mm
++POSTHOOK: Input: default@load2_mm@k=5/l=5
++#### A masked pattern was here ####
++1025
++PREHOOK: query: drop table load2_mm
++PREHOOK: type: DROPTABLE
++PREHOOK: Input: default@load2_mm
++PREHOOK: Output: default@load2_mm
++POSTHOOK: query: drop table load2_mm
++POSTHOOK: type: DROPTABLE
++POSTHOOK: Input: default@load2_mm
++POSTHOOK: Output: default@load2_mm
++PREHOOK: query: drop table intermediate2
++PREHOOK: type: DROPTABLE
++PREHOOK: Input: default@intermediate2
++PREHOOK: Output: default@intermediate2
++POSTHOOK: query: drop table intermediate2
++POSTHOOK: type: DROPTABLE
++POSTHOOK: Input: default@intermediate2
++POSTHOOK: Output: default@intermediate2

http://git-wip-us.apache.org/repos/asf/hive/blob/42a38577/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
----------------------------------------------------------------------