Repository: hive Updated Branches: refs/heads/hive-14535 4e0439639 -> d9e4ae09e
HIVE-16819 : Add MM test for temporary table (Wei Zheng) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/d9e4ae09 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/d9e4ae09 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/d9e4ae09 Branch: refs/heads/hive-14535 Commit: d9e4ae09e66f97cee155b3c1b3ae7bc0cac02641 Parents: 4e04396 Author: Wei Zheng <w...@apache.org> Authored: Tue Jun 6 10:43:35 2017 -0700 Committer: Wei Zheng <w...@apache.org> Committed: Tue Jun 6 10:43:35 2017 -0700 ---------------------------------------------------------------------- ql/src/test/queries/clientpositive/mm_all.q | 8 ++++ ql/src/test/results/clientpositive/mm_all.q.out | 50 ++++++++++++++++++++ 2 files changed, 58 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/d9e4ae09/ql/src/test/queries/clientpositive/mm_all.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/mm_all.q b/ql/src/test/queries/clientpositive/mm_all.q index 326328d..6001e9f 100644 --- a/ql/src/test/queries/clientpositive/mm_all.q +++ b/ql/src/test/queries/clientpositive/mm_all.q @@ -356,6 +356,14 @@ drop table parquet2_mm; set hive.auto.convert.join=true; + +DROP TABLE IF EXISTS temp1; +CREATE TEMPORARY TABLE temp1 (a int) TBLPROPERTIES ("transactional"="true", "transactional_properties"="insert_only"); +INSERT INTO temp1 SELECT key FROM intermediate; +DESC EXTENDED temp1; +SELECT * FROM temp1; + + drop table intermediate; http://git-wip-us.apache.org/repos/asf/hive/blob/d9e4ae09/ql/src/test/results/clientpositive/mm_all.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mm_all.q.out b/ql/src/test/results/clientpositive/mm_all.q.out index 821c3fb..6bed878 100644 --- a/ql/src/test/results/clientpositive/mm_all.q.out +++ b/ql/src/test/results/clientpositive/mm_all.q.out @@ -2352,6 +2352,56 @@ POSTHOOK: query: drop table parquet2_mm POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@parquet2_mm POSTHOOK: Output: default@parquet2_mm +PREHOOK: query: DROP TABLE IF EXISTS temp1 +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE IF EXISTS temp1 +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TEMPORARY TABLE temp1 (a int) TBLPROPERTIES ("transactional"="true", "transactional_properties"="insert_only") +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@temp1 +POSTHOOK: query: CREATE TEMPORARY TABLE temp1 (a int) TBLPROPERTIES ("transactional"="true", "transactional_properties"="insert_only") +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@temp1 +PREHOOK: query: INSERT INTO temp1 SELECT key FROM intermediate +PREHOOK: type: QUERY +PREHOOK: Input: default@intermediate +PREHOOK: Input: default@intermediate@p=455 +PREHOOK: Input: default@intermediate@p=456 +PREHOOK: Input: default@intermediate@p=457 +PREHOOK: Output: default@temp1 +POSTHOOK: query: INSERT INTO temp1 SELECT key FROM intermediate +POSTHOOK: type: QUERY +POSTHOOK: Input: default@intermediate +POSTHOOK: Input: default@intermediate@p=455 +POSTHOOK: Input: default@intermediate@p=456 +POSTHOOK: Input: default@intermediate@p=457 +POSTHOOK: Output: default@temp1 +POSTHOOK: Lineage: temp1.a SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ] +PREHOOK: query: DESC EXTENDED temp1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@temp1 +POSTHOOK: query: DESC EXTENDED temp1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@temp1 +a int + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM temp1 +PREHOOK: type: QUERY +PREHOOK: Input: default@temp1 +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM temp1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@temp1 +#### A masked pattern was here #### +98 +97 +0 +10 +100 +103 PREHOOK: query: drop table intermediate PREHOOK: type: DROPTABLE PREHOOK: Input: default@intermediate