You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ai...@apache.org on 2016/12/06 20:48:22 UTC
[46/47] hive git commit: HIVE-15346: "values temp table" should not
be an input (Aihua Xu, reviewed by Yongzhi Chen)
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/encrypted/encryption_drop_partition.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_drop_partition.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_drop_partition.q.out
index c2f6b03..e32feed 100644
--- a/ql/src/test/results/clientpositive/encrypted/encryption_drop_partition.q.out
+++ b/ql/src/test/results/clientpositive/encrypted/encryption_drop_partition.q.out
@@ -16,11 +16,9 @@ Encryption key created: 'key_128'
Encryption zone created: '/build/ql/test/data/warehouse/default/encrypted_table_dp' using key: 'key_128'
PREHOOK: query: INSERT INTO encrypted_table_dp PARTITION(p)(p,key,value) values('2014-09-23', 1, 'foo'),('2014-09-24', 2, 'bar')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@encrypted_table_dp
POSTHOOK: query: INSERT INTO encrypted_table_dp PARTITION(p)(p,key,value) values('2014-09-23', 1, 'foo'),('2014-09-24', 2, 'bar')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@encrypted_table_dp@p=2014-09-23
POSTHOOK: Output: default@encrypted_table_dp@p=2014-09-24
POSTHOOK: Lineage: encrypted_table_dp PARTITION(p=2014-09-23).key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
index 6aa3ab0..dbc7473 100644
--- a/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
+++ b/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
@@ -43,14 +43,12 @@ insert into table encryptedTable partition (key) values
('val_501', '501'),
('val_502', '502')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@encryptedtable
POSTHOOK: query: -- insert encrypted table from values
insert into table encryptedTable partition (key) values
('val_501', '501'),
('val_502', '502')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@encryptedtable@key=501
POSTHOOK: Output: default@encryptedtable@key=502
POSTHOOK: Lineage: encryptedtable PARTITION(key=501).value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out
index c2f0ddc..53ef34c 100644
--- a/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out
+++ b/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out
@@ -44,7 +44,6 @@ insert into table encryptedTable partition
('501', 'val_501'),
('502', 'val_502')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@encryptedtable@ds=today
POSTHOOK: query: -- insert encrypted table from values
insert into table encryptedTable partition
@@ -52,7 +51,6 @@ insert into table encryptedTable partition
('501', 'val_501'),
('502', 'val_502')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@encryptedtable@ds=today
POSTHOOK: Lineage: encryptedtable PARTITION(ds=today).key SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: encryptedtable PARTITION(ds=today).value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
index c1cbf30..80f37a7 100644
--- a/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
+++ b/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
@@ -20,11 +20,9 @@ Encryption key created: 'key_128'
Encryption zone created: '/build/ql/test/data/warehouse/default/encrypted_table' using key: 'key_128'
PREHOOK: query: INSERT INTO encrypted_table values(1,'foo'),(2,'bar')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@encrypted_table
POSTHOOK: query: INSERT INTO encrypted_table values(1,'foo'),(2,'bar')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@encrypted_table
POSTHOOK: Lineage: encrypted_table.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: encrypted_table.value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/except_all.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/except_all.q.out b/ql/src/test/results/clientpositive/except_all.q.out
index 17313c1..5ab3c64 100644
--- a/ql/src/test/results/clientpositive/except_all.q.out
+++ b/ql/src/test/results/clientpositive/except_all.q.out
@@ -8,11 +8,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@a
PREHOOK: query: insert into table a values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@a
POSTHOOK: query: insert into table a values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@a
POSTHOOK: Lineage: a.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: create table b(key bigint)
@@ -25,11 +23,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@b
PREHOOK: query: insert into table b values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@b
POSTHOOK: query: insert into table b values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@b
POSTHOOK: Lineage: b.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: select * from a except all select * from b
@@ -71,11 +67,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@a
PREHOOK: query: insert into table a values (1,2),(1,2),(1,3),(2,3),(2,2)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@a
POSTHOOK: query: insert into table a values (1,2),(1,2),(1,3),(2,3),(2,2)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@a
POSTHOOK: Lineage: a.key EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: a.value EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -89,11 +83,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@b
PREHOOK: query: insert into table b values (1,2),(2,3),(2,2),(2,2),(2,20)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__4
PREHOOK: Output: default@b
POSTHOOK: query: insert into table b values (1,2),(2,3),(2,2),(2,2),(2,20)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@b
POSTHOOK: Lineage: b.key EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: b.value EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out b/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out
index 1dce4df..542decf 100644
--- a/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out
+++ b/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out
@@ -8,29 +8,23 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@date_dim
PREHOOK: query: insert into date_dim partition(d_date_sk=2416945) values('1905-04-09')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@date_dim@d_date_sk=2416945
POSTHOOK: query: insert into date_dim partition(d_date_sk=2416945) values('1905-04-09')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@date_dim@d_date_sk=2416945
POSTHOOK: Lineage: date_dim PARTITION(d_date_sk=2416945).d_date EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: insert into date_dim partition(d_date_sk=2416946) values('1905-04-10')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@date_dim@d_date_sk=2416946
POSTHOOK: query: insert into date_dim partition(d_date_sk=2416946) values('1905-04-10')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@date_dim@d_date_sk=2416946
POSTHOOK: Lineage: date_dim PARTITION(d_date_sk=2416946).d_date EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: insert into date_dim partition(d_date_sk=2416947) values('1905-04-11')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@date_dim@d_date_sk=2416947
POSTHOOK: query: insert into date_dim partition(d_date_sk=2416947) values('1905-04-11')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@date_dim@d_date_sk=2416947
POSTHOOK: Lineage: date_dim PARTITION(d_date_sk=2416947).d_date EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: analyze table date_dim partition(d_date_sk) compute statistics for columns
@@ -98,11 +92,9 @@ STAGE PLANS:
PREHOOK: query: insert into date_dim partition(d_date_sk=2416948) values('1905-04-12')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__4
PREHOOK: Output: default@date_dim@d_date_sk=2416948
POSTHOOK: query: insert into date_dim partition(d_date_sk=2416948) values('1905-04-12')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@date_dim@d_date_sk=2416948
POSTHOOK: Lineage: date_dim PARTITION(d_date_sk=2416948).d_date EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: explain extended select d_date from date_dim
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/folder_predicate.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/folder_predicate.q.out b/ql/src/test/results/clientpositive/folder_predicate.q.out
index 7fcc172..0dd7347 100644
--- a/ql/src/test/results/clientpositive/folder_predicate.q.out
+++ b/ql/src/test/results/clientpositive/folder_predicate.q.out
@@ -12,11 +12,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@predicate_fold_tb
PREHOOK: query: insert into predicate_fold_tb values(NULL), (1), (2), (3), (4), (5)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@predicate_fold_tb
POSTHOOK: query: insert into predicate_fold_tb values(NULL), (1), (2), (3), (4), (5)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@predicate_fold_tb
POSTHOOK: Lineage: predicate_fold_tb.value EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: explain
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/groupby_nullvalues.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/groupby_nullvalues.q.out b/ql/src/test/results/clientpositive/groupby_nullvalues.q.out
index aae2a12..5ad5a98 100644
--- a/ql/src/test/results/clientpositive/groupby_nullvalues.q.out
+++ b/ql/src/test/results/clientpositive/groupby_nullvalues.q.out
@@ -32,11 +32,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@paqtest
PREHOOK: query: insert into paqtest values (58, '', 'ABC', 0)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@paqtest
POSTHOOK: query: insert into paqtest values (58, '', 'ABC', 0)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@paqtest
POSTHOOK: Lineage: paqtest.bn1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
POSTHOOK: Lineage: paqtest.c1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/implicit_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/implicit_decimal.q.out b/ql/src/test/results/clientpositive/implicit_decimal.q.out
index b93f250..1beb109 100644
--- a/ql/src/test/results/clientpositive/implicit_decimal.q.out
+++ b/ql/src/test/results/clientpositive/implicit_decimal.q.out
@@ -12,11 +12,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_test
PREHOOK: query: insert into table decimal_test values (4327269606205.029297)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@decimal_test
POSTHOOK: query: insert into table decimal_test values (4327269606205.029297)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@decimal_test
POSTHOOK: Lineage: decimal_test.dc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: explain
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_into1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_into1.q.out b/ql/src/test/results/clientpositive/insert_into1.q.out
index 6bbb86c..2fb7b71 100644
--- a/ql/src/test/results/clientpositive/insert_into1.q.out
+++ b/ql/src/test/results/clientpositive/insert_into1.q.out
@@ -628,11 +628,9 @@ STAGE PLANS:
PREHOOK: query: insert into table insert_into1 values(1, 'abc')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@insert_into1
POSTHOOK: query: insert into table insert_into1 values(1, 'abc')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@insert_into1
POSTHOOK: Lineage: insert_into1.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: insert_into1.value SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_into2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_into2.q.out b/ql/src/test/results/clientpositive/insert_into2.q.out
index 1910de6..46fab7b 100644
--- a/ql/src/test/results/clientpositive/insert_into2.q.out
+++ b/ql/src/test/results/clientpositive/insert_into2.q.out
@@ -399,11 +399,9 @@ POSTHOOK: Input: default@insert_into2
50
PREHOOK: query: insert into table insert_into2 partition (ds='2') values(1, 'abc')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@insert_into2@ds=2
POSTHOOK: query: insert into table insert_into2 partition (ds='2') values(1, 'abc')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@insert_into2@ds=2
POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_into_with_schema.q.out b/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
index 53e6c99..040d118 100644
--- a/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
+++ b/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
@@ -44,11 +44,9 @@ POSTHOOK: Output: database:x314
POSTHOOK: Output: x314@target2
PREHOOK: query: insert into source(s2,s1) values(2,1)
PREHOOK: type: QUERY
-PREHOOK: Input: x314@values__tmp__table__1
PREHOOK: Output: x314@source
POSTHOOK: query: insert into source(s2,s1) values(2,1)
POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@values__tmp__table__1
POSTHOOK: Output: x314@source
POSTHOOK: Lineage: source.s1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: source.s2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -217,11 +215,9 @@ POSTHOOK: Output: database:x314
POSTHOOK: Output: x314@pageviews
PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp = '2014-09-23', i = 1)(userid,link) VALUES ('jsmith', 'mail.com')
PREHOOK: type: QUERY
-PREHOOK: Input: x314@values__tmp__table__2
PREHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=1
POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp = '2014-09-23', i = 1)(userid,link) VALUES ('jsmith', 'mail.com')
POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@values__tmp__table__2
POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=1
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).link SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).source SIMPLE []
@@ -245,7 +241,6 @@ PREHOOK: query: -- dynamic partitioning
INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,link) VALUES ('jsmith', 7, '7mail.com')
PREHOOK: type: QUERY
-PREHOOK: Input: x314@values__tmp__table__3
PREHOOK: Output: x314@pageviews@datestamp=2014-09-23
POSTHOOK: query: -- dynamic partitioning
@@ -253,29 +248,24 @@ POSTHOOK: query: -- dynamic partitioning
INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,link) VALUES ('jsmith', 7, '7mail.com')
POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@values__tmp__table__3
POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=7
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).link SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).source SIMPLE []
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).userid EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 17, '17mail.com', '2014-09-23')
PREHOOK: type: QUERY
-PREHOOK: Input: x314@values__tmp__table__4
PREHOOK: Output: x314@pageviews
POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 17, '17mail.com', '2014-09-23')
POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@values__tmp__table__4
POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=17
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).link SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).source SIMPLE []
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).userid EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 19, '19mail.com', '2014-09-24')
PREHOOK: type: QUERY
-PREHOOK: Input: x314@values__tmp__table__5
PREHOOK: Output: x314@pageviews
POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 19, '19mail.com', '2014-09-24')
POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@values__tmp__table__5
POSTHOOK: Output: x314@pageviews@datestamp=2014-09-24/i=19
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).link SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).source SIMPLE []
@@ -283,12 +273,10 @@ POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).userid EXPRESS
PREHOOK: query: -- here the 'datestamp' partition column is not provided and will be NULL-filled
INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link) VALUES ('jsmith', 23, '23mail.com')
PREHOOK: type: QUERY
-PREHOOK: Input: x314@values__tmp__table__6
PREHOOK: Output: x314@pageviews
POSTHOOK: query: -- here the 'datestamp' partition column is not provided and will be NULL-filled
INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link) VALUES ('jsmith', 23, '23mail.com')
POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@values__tmp__table__6
POSTHOOK: Output: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23
POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).link SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).source SIMPLE []
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_into_with_schema2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_into_with_schema2.q.out b/ql/src/test/results/clientpositive/insert_into_with_schema2.q.out
index fa48963..b62eb6f 100644
--- a/ql/src/test/results/clientpositive/insert_into_with_schema2.q.out
+++ b/ql/src/test/results/clientpositive/insert_into_with_schema2.q.out
@@ -16,11 +16,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k
PREHOOK: query: insert into studenttab10k values(1)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@studenttab10k
POSTHOOK: query: insert into studenttab10k values(1)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@studenttab10k
POSTHOOK: Lineage: studenttab10k.age2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: create table student_acid (age int, grade int)
@@ -74,21 +72,17 @@ POSTHOOK: Input: default@student_acid
1 NULL
PREHOOK: query: insert into student_acid(grade, age) values(20, 2)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@student_acid
POSTHOOK: query: insert into student_acid(grade, age) values(20, 2)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@student_acid
POSTHOOK: Lineage: student_acid.age EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: student_acid.grade EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: insert into student_acid(age) values(22)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@student_acid
POSTHOOK: query: insert into student_acid(age) values(22)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@student_acid
POSTHOOK: Lineage: student_acid.age EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: student_acid.grade SIMPLE []
@@ -122,11 +116,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_partitioned
PREHOOK: query: insert into acid_partitioned partition (p) (a,p) values(1,2)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__4
PREHOOK: Output: default@acid_partitioned
POSTHOOK: query: insert into acid_partitioned partition (p) (a,p) values(1,2)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@acid_partitioned@p=2
POSTHOOK: Lineage: acid_partitioned PARTITION(p=2).a EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: acid_partitioned PARTITION(p=2).c SIMPLE []
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out b/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out
index c114654..af410c5 100644
--- a/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out
+++ b/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out
@@ -14,11 +14,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@sample_06
PREHOOK: query: insert into table sample_06 values ('aaa', 35, 3.00), ('bbb', 32, 3.00), ('ccc', 32, 3.00), ('ddd', 35, 3.00), ('eee', 32, 3.00)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@sample_06
POSTHOOK: query: insert into table sample_06 values ('aaa', 35, 3.00), ('bbb', 32, 3.00), ('ccc', 32, 3.00), ('ddd', 35, 3.00), ('eee', 32, 3.00)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@sample_06
POSTHOOK: Lineage: sample_06.age EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: sample_06.gpa EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out b/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out
index 4f8ddfa..7885ee4 100644
--- a/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out
@@ -8,11 +8,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_notbucketed
PREHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_notbucketed
POSTHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_notbucketed
POSTHOOK: Lineage: acid_notbucketed.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out b/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out
index 773feb4..7da6393 100644
--- a/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out
@@ -14,13 +14,11 @@ PREHOOK: query: insert into table ivdp partition (ds) values
(1, 109.23, 'and everywhere that mary went', 'today'),
(6553, 923.19, 'the lamb was sure to go', 'tomorrow')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@ivdp
POSTHOOK: query: insert into table ivdp partition (ds) values
(1, 109.23, 'and everywhere that mary went', 'today'),
(6553, 923.19, 'the lamb was sure to go', 'tomorrow')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@ivdp@ds=today
POSTHOOK: Output: default@ivdp@ds=tomorrow
POSTHOOK: Lineage: ivdp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out b/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out
index 5b1c3cc..189f50d 100644
--- a/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out
@@ -35,14 +35,12 @@ PREHOOK: query: insert into table acid_ivnp values
(null, null, null, null, null, null, null, null, null, null, null, null, null),
(3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivnp
POSTHOOK: query: insert into table acid_ivnp values
(1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
(null, null, null, null, null, null, null, null, null, null, null, null, null),
(3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivnp
POSTHOOK: Lineage: acid_ivnp.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_nonascii.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_nonascii.q.out b/ql/src/test/results/clientpositive/insert_values_nonascii.q.out
index ca07bef..62514da 100644
--- a/ql/src/test/results/clientpositive/insert_values_nonascii.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_nonascii.q.out
@@ -8,11 +8,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@insert_values_nonascii
PREHOOK: query: insert into insert_values_nonascii values("\u0410\u0431\u0432\u0433\u0434\u0435 Gar�u \u8c22\u8c22", "K�kaku \u3042\u308a\u304c\u3068\u3046"), ("\u3054\u3056\u3044\u307e\u3059", "kid�tai\ud55c\uad6d\uc5b4")
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@insert_values_nonascii
POSTHOOK: query: insert into insert_values_nonascii values("\u0410\u0431\u0432\u0433\u0434\u0435 Gar�u \u8c22\u8c22", "K�kaku \u3042\u308a\u304c\u3068\u3046"), ("\u3054\u3056\u3044\u307e\u3059", "kid�tai\ud55c\uad6d\uc5b4")
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@insert_values_nonascii
POSTHOOK: Lineage: insert_values_nonascii.t1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: insert_values_nonascii.t2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_orig_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_orig_table.q.out b/ql/src/test/results/clientpositive/insert_values_orig_table.q.out
index 684cd1b..9a47fe1 100644
--- a/ql/src/test/results/clientpositive/insert_values_orig_table.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_orig_table.q.out
@@ -51,13 +51,11 @@ PREHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivot
POSTHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivot
POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out b/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out
index 2a9eff0..24db44f 100644
--- a/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out
@@ -188,13 +188,11 @@ PREHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivot
POSTHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivot
POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
@@ -261,13 +259,11 @@ PREHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@acid_ivot
POSTHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@acid_ivot
POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
@@ -385,13 +381,11 @@ PREHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@acid_ivot
POSTHOOK: query: insert into table acid_ivot values
(1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
(111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@acid_ivot
POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
@@ -845,12 +839,10 @@ POSTHOOK: Input: default@sp@ds=2008-04-08/hr=11
PREHOOK: query: insert into table sp PARTITION (ds="2008-04-08", hr="11") values
('1', '2'), ('3', '4')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__4
PREHOOK: Output: default@sp@ds=2008-04-08/hr=11
POSTHOOK: query: insert into table sp PARTITION (ds="2008-04-08", hr="11") values
('1', '2'), ('3', '4')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@sp@ds=2008-04-08/hr=11
POSTHOOK: Lineage: sp PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: sp PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_partitioned.q.out b/ql/src/test/results/clientpositive/insert_values_partitioned.q.out
index 6681992..48dfadc 100644
--- a/ql/src/test/results/clientpositive/insert_values_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_partitioned.q.out
@@ -32,13 +32,11 @@ PREHOOK: query: insert into table acid_ivp partition (ds='today') values
(1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
(3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivp@ds=today
POSTHOOK: query: insert into table acid_ivp partition (ds='today') values
(1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
(3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivp@ds=today
POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out b/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
index 170b4a7..4e4eafd 100644
--- a/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
+++ b/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
@@ -11,14 +11,12 @@ PREHOOK: query: insert into table acid_ivtt values
(429496729, 0.14, 'its fleece was white as snow'),
(-29496729, -0.14, 'negative values test')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivtt
POSTHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
(429496729, 0.14, 'its fleece was white as snow'),
(-29496729, -0.14, 'negative values test')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivtt
POSTHOOK: Lineage: acid_ivtt.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivtt.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insertoverwrite_bucket.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insertoverwrite_bucket.q.out b/ql/src/test/results/clientpositive/insertoverwrite_bucket.q.out
index bfbe87b..c2732c8 100644
--- a/ql/src/test/results/clientpositive/insertoverwrite_bucket.q.out
+++ b/ql/src/test/results/clientpositive/insertoverwrite_bucket.q.out
@@ -46,29 +46,23 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucketoutput2
PREHOOK: query: insert into table bucketinput values ("firstinsert1")
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@bucketinput
POSTHOOK: query: insert into table bucketinput values ("firstinsert1")
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@bucketinput
POSTHOOK: Lineage: bucketinput.data SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: insert into table bucketinput values ("firstinsert2")
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@bucketinput
POSTHOOK: query: insert into table bucketinput values ("firstinsert2")
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@bucketinput
POSTHOOK: Lineage: bucketinput.data SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: insert into table bucketinput values ("firstinsert3")
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@bucketinput
POSTHOOK: query: insert into table bucketinput values ("firstinsert3")
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@bucketinput
POSTHOOK: Lineage: bucketinput.data SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: insert overwrite table bucketoutput1 select * from bucketinput where data like 'first%'
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/insertvalues_espchars.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insertvalues_espchars.q.out b/ql/src/test/results/clientpositive/insertvalues_espchars.q.out
index caa35d6..eac85e6 100644
--- a/ql/src/test/results/clientpositive/insertvalues_espchars.q.out
+++ b/ql/src/test/results/clientpositive/insertvalues_espchars.q.out
@@ -12,11 +12,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@escstr
PREHOOK: query: insert into escstr values('It\'s a simple test')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@escstr
POSTHOOK: query: insert into escstr values('It\'s a simple test')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@escstr
POSTHOOK: Lineage: escstr.val SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: select * from escstr
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/interval_alt.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/interval_alt.q.out b/ql/src/test/results/clientpositive/interval_alt.q.out
index eb4d10b..8970ede 100644
--- a/ql/src/test/results/clientpositive/interval_alt.q.out
+++ b/ql/src/test/results/clientpositive/interval_alt.q.out
@@ -59,11 +59,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@t
PREHOOK: query: insert into t values (1),(2)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@t
POSTHOOK: query: insert into t values (1),(2)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@t
POSTHOOK: Lineage: t.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: -- expressions/columnref
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/join42.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join42.q.out b/ql/src/test/results/clientpositive/join42.q.out
index d557385..2d03654 100644
--- a/ql/src/test/results/clientpositive/join42.q.out
+++ b/ql/src/test/results/clientpositive/join42.q.out
@@ -70,22 +70,18 @@ POSTHOOK: Lineage: acct.aid SIMPLE []
POSTHOOK: Lineage: acct.brn SIMPLE []
PREHOOK: query: insert into table acct values(4748, null, null)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acct
POSTHOOK: query: insert into table acct values(4748, null, null)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acct
POSTHOOK: Lineage: acct.acc_n EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: acct.aid EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: acct.brn EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
PREHOOK: query: insert into table acct values(4748, null, null)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@acct
POSTHOOK: query: insert into table acct values(4748, null, null)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@acct
POSTHOOK: Lineage: acct.acc_n EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: acct.aid EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/join43.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join43.q.out b/ql/src/test/results/clientpositive/join43.q.out
index 127d5d0..e8c7278 100644
--- a/ql/src/test/results/clientpositive/join43.q.out
+++ b/ql/src/test/results/clientpositive/join43.q.out
@@ -8,11 +8,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@purchase_history
PREHOOK: query: insert into purchase_history values ('1', 'Belt', 20.00, 21)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@purchase_history
POSTHOOK: query: insert into purchase_history values ('1', 'Belt', 20.00, 21)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@purchase_history
POSTHOOK: Lineage: purchase_history.price EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: purchase_history.product SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -20,11 +18,9 @@ POSTHOOK: Lineage: purchase_history.s SIMPLE [(values__tmp__table__1)values__tmp
POSTHOOK: Lineage: purchase_history.time EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into purchase_history values ('1', 'Socks', 3.50, 31)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@purchase_history
POSTHOOK: query: insert into purchase_history values ('1', 'Socks', 3.50, 31)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@purchase_history
POSTHOOK: Lineage: purchase_history.price EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: purchase_history.product SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -32,11 +28,9 @@ POSTHOOK: Lineage: purchase_history.s SIMPLE [(values__tmp__table__2)values__tmp
POSTHOOK: Lineage: purchase_history.time EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into purchase_history values ('3', 'Belt', 20.00, 51)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@purchase_history
POSTHOOK: query: insert into purchase_history values ('3', 'Belt', 20.00, 51)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@purchase_history
POSTHOOK: Lineage: purchase_history.price EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: purchase_history.product SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -44,11 +38,9 @@ POSTHOOK: Lineage: purchase_history.s SIMPLE [(values__tmp__table__3)values__tmp
POSTHOOK: Lineage: purchase_history.time EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into purchase_history values ('4', 'Shirt', 15.50, 59)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__4
PREHOOK: Output: default@purchase_history
POSTHOOK: query: insert into purchase_history values ('4', 'Shirt', 15.50, 59)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@purchase_history
POSTHOOK: Lineage: purchase_history.price EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: purchase_history.product SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -64,66 +56,54 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@cart_history
PREHOOK: query: insert into cart_history values ('1', 1, 10)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__5
PREHOOK: Output: default@cart_history
POSTHOOK: query: insert into cart_history values ('1', 1, 10)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__5
POSTHOOK: Output: default@cart_history
POSTHOOK: Lineage: cart_history.cart_id EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.s SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.time EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
PREHOOK: query: insert into cart_history values ('1', 2, 20)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__6
PREHOOK: Output: default@cart_history
POSTHOOK: query: insert into cart_history values ('1', 2, 20)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__6
POSTHOOK: Output: default@cart_history
POSTHOOK: Lineage: cart_history.cart_id EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.s SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.time EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
PREHOOK: query: insert into cart_history values ('1', 3, 30)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__7
PREHOOK: Output: default@cart_history
POSTHOOK: query: insert into cart_history values ('1', 3, 30)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__7
POSTHOOK: Output: default@cart_history
POSTHOOK: Lineage: cart_history.cart_id EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.s SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.time EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
PREHOOK: query: insert into cart_history values ('1', 4, 40)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__8
PREHOOK: Output: default@cart_history
POSTHOOK: query: insert into cart_history values ('1', 4, 40)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__8
POSTHOOK: Output: default@cart_history
POSTHOOK: Lineage: cart_history.cart_id EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.s SIMPLE [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.time EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
PREHOOK: query: insert into cart_history values ('3', 5, 50)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__9
PREHOOK: Output: default@cart_history
POSTHOOK: query: insert into cart_history values ('3', 5, 50)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__9
POSTHOOK: Output: default@cart_history
POSTHOOK: Lineage: cart_history.cart_id EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.s SIMPLE [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.time EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
PREHOOK: query: insert into cart_history values ('4', 6, 60)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__10
PREHOOK: Output: default@cart_history
POSTHOOK: query: insert into cart_history values ('4', 6, 60)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__10
POSTHOOK: Output: default@cart_history
POSTHOOK: Lineage: cart_history.cart_id EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: cart_history.s SIMPLE [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -138,11 +118,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@events
PREHOOK: query: insert into events values ('1', 'Bob', 1234, 20)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__11
PREHOOK: Output: default@events
POSTHOOK: query: insert into events values ('1', 'Bob', 1234, 20)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__11
POSTHOOK: Output: default@events
POSTHOOK: Lineage: events.n EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: events.s SIMPLE [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -150,11 +128,9 @@ POSTHOOK: Lineage: events.st2 SIMPLE [(values__tmp__table__11)values__tmp__table
POSTHOOK: Lineage: events.time EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into events values ('1', 'Bob', 1234, 30)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__12
PREHOOK: Output: default@events
POSTHOOK: query: insert into events values ('1', 'Bob', 1234, 30)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__12
POSTHOOK: Output: default@events
POSTHOOK: Lineage: events.n EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: events.s SIMPLE [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -162,11 +138,9 @@ POSTHOOK: Lineage: events.st2 SIMPLE [(values__tmp__table__12)values__tmp__table
POSTHOOK: Lineage: events.time EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into events values ('1', 'Bob', 1234, 25)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__13
PREHOOK: Output: default@events
POSTHOOK: query: insert into events values ('1', 'Bob', 1234, 25)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__13
POSTHOOK: Output: default@events
POSTHOOK: Lineage: events.n EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: events.s SIMPLE [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -174,11 +148,9 @@ POSTHOOK: Lineage: events.st2 SIMPLE [(values__tmp__table__13)values__tmp__table
POSTHOOK: Lineage: events.time EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into events values ('2', 'Sam', 1234, 30)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__14
PREHOOK: Output: default@events
POSTHOOK: query: insert into events values ('2', 'Sam', 1234, 30)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__14
POSTHOOK: Output: default@events
POSTHOOK: Lineage: events.n EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: events.s SIMPLE [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -186,11 +158,9 @@ POSTHOOK: Lineage: events.st2 SIMPLE [(values__tmp__table__14)values__tmp__table
POSTHOOK: Lineage: events.time EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into events values ('3', 'Jeff', 1234, 50)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__15
PREHOOK: Output: default@events
POSTHOOK: query: insert into events values ('3', 'Jeff', 1234, 50)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__15
POSTHOOK: Output: default@events
POSTHOOK: Lineage: events.n EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: events.s SIMPLE [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -198,11 +168,9 @@ POSTHOOK: Lineage: events.st2 SIMPLE [(values__tmp__table__15)values__tmp__table
POSTHOOK: Lineage: events.time EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into events values ('4', 'Ted', 1234, 60)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__16
PREHOOK: Output: default@events
POSTHOOK: query: insert into events values ('4', 'Ted', 1234, 60)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__16
POSTHOOK: Output: default@events
POSTHOOK: Lineage: events.n EXPRESSION [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: events.s SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/join46.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join46.q.out b/ql/src/test/results/clientpositive/join46.q.out
index 21ae29c..ca4a27b 100644
--- a/ql/src/test/results/clientpositive/join46.q.out
+++ b/ql/src/test/results/clientpositive/join46.q.out
@@ -9,12 +9,10 @@ POSTHOOK: Output: default@test1
PREHOOK: query: INSERT INTO test1 VALUES (NULL, NULL, 'None'), (98, NULL, 'None'),
(99, 0, 'Alice'), (99, 2, 'Mat'), (100, 1, 'Bob'), (101, 2, 'Car')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@test1
POSTHOOK: query: INSERT INTO test1 VALUES (NULL, NULL, 'None'), (98, NULL, 'None'),
(99, 0, 'Alice'), (99, 2, 'Mat'), (100, 1, 'Bob'), (101, 2, 'Car')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@test1
POSTHOOK: Lineage: test1.col_1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: test1.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -30,12 +28,10 @@ POSTHOOK: Output: default@test2
PREHOOK: query: INSERT INTO test2 VALUES (102, 2, 'Del'), (103, 2, 'Ema'),
(104, 3, 'Fli'), (105, NULL, 'None')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@test2
POSTHOOK: query: INSERT INTO test2 VALUES (102, 2, 'Del'), (103, 2, 'Ema'),
(104, 3, 'Fli'), (105, NULL, 'None')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@test2
POSTHOOK: Lineage: test2.col_2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: test2.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/join_acid_non_acid.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_acid_non_acid.q.out b/ql/src/test/results/clientpositive/join_acid_non_acid.q.out
index 4905351..f1c93cd 100644
--- a/ql/src/test/results/clientpositive/join_acid_non_acid.q.out
+++ b/ql/src/test/results/clientpositive/join_acid_non_acid.q.out
@@ -12,11 +12,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_update_table
PREHOOK: query: INSERT INTO TABLE orc_update_table VALUES (1, 'a', 'I')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@orc_update_table
POSTHOOK: query: INSERT INTO TABLE orc_update_table VALUES (1, 'a', 'I')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@orc_update_table
POSTHOOK: Lineage: orc_update_table.f1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: orc_update_table.k1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -35,11 +33,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_table
PREHOOK: query: INSERT OVERWRITE TABLE orc_table VALUES (1, 'x')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@orc_table
POSTHOOK: query: INSERT OVERWRITE TABLE orc_table VALUES (1, 'x')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@orc_table
POSTHOOK: Lineage: orc_table.f1 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: orc_table.k1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out
index aae0fcb..985c645 100644
--- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out
+++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out
@@ -18,11 +18,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@rtable
PREHOOK: query: insert into ltable values (1, null, 'CD5415192314304', '00071'), (2, null, 'CD5415192225530', '00071')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@ltable
POSTHOOK: query: insert into ltable values (1, null, 'CD5415192314304', '00071'), (2, null, 'CD5415192225530', '00071')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@ltable
POSTHOOK: Lineage: ltable.index EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: ltable.la EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -30,11 +28,9 @@ POSTHOOK: Lineage: ltable.lk1 SIMPLE [(values__tmp__table__1)values__tmp__table_
POSTHOOK: Lineage: ltable.lk2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
PREHOOK: query: insert into rtable values (1, 'CD5415192314304', '00071'), (45, 'CD5415192314304', '00072')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@rtable
POSTHOOK: query: insert into rtable values (1, 'CD5415192314304', '00071'), (45, 'CD5415192314304', '00072')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@rtable
POSTHOOK: Lineage: rtable.ra EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: rtable.rk1 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/join_emit_interval.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_emit_interval.q.out b/ql/src/test/results/clientpositive/join_emit_interval.q.out
index 263ba04..a65ff86 100644
--- a/ql/src/test/results/clientpositive/join_emit_interval.q.out
+++ b/ql/src/test/results/clientpositive/join_emit_interval.q.out
@@ -9,12 +9,10 @@ POSTHOOK: Output: default@test1
PREHOOK: query: INSERT INTO test1 VALUES (NULL, NULL, 'None'), (98, NULL, 'None'),
(99, 0, 'Alice'), (99, 2, 'Mat'), (100, 1, 'Bob'), (101, 2, 'Car')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@test1
POSTHOOK: query: INSERT INTO test1 VALUES (NULL, NULL, 'None'), (98, NULL, 'None'),
(99, 0, 'Alice'), (99, 2, 'Mat'), (100, 1, 'Bob'), (101, 2, 'Car')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@test1
POSTHOOK: Lineage: test1.col_1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: test1.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -30,12 +28,10 @@ POSTHOOK: Output: default@test2
PREHOOK: query: INSERT INTO test2 VALUES (102, 2, 'Del'), (103, 2, 'Ema'),
(104, 3, 'Fli'), (105, NULL, 'None')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@test2
POSTHOOK: query: INSERT INTO test2 VALUES (102, 2, 'Del'), (103, 2, 'Ema'),
(104, 3, 'Fli'), (105, NULL, 'None')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@test2
POSTHOOK: Lineage: test2.col_2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
POSTHOOK: Lineage: test2.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/lineage2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/lineage2.q.out b/ql/src/test/results/clientpositive/lineage2.q.out
index 85649a0..7224bce 100644
--- a/ql/src/test/results/clientpositive/lineage2.q.out
+++ b/ql/src/test/results/clientpositive/lineage2.q.out
@@ -602,7 +602,6 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@dest_l2
PREHOOK: query: insert into dest_l2 values(0, 1, 100, 10000)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@dest_l2
{"version":"1.0","engine":"mr","database":"default","hash":"e001334e3f8384806b0f25a7c303045f","queryText":"insert into dest_l2 values(0, 1, 100, 10000)","edges":[{"sources":[],"targets":[0],"expression":"UDFToInteger(values__tmp__table__1.tmp_values_col1)","edgeType":"PROJECTION"},{"sources":[],"targets":[1],"expression":"UDFToByte(values__tmp__table__1.tmp_values_col2)","edgeType":"PROJECTION"},{"sources":[],"targets":[2],"expression":"UDFToInteger(values__tmp__table__1.tmp_values_col3)","edgeType":"PROJECTION"},{"sources":[],"targets":[3],"expression":"UDFToLong(values__tmp__table__1.tmp_values_col4)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"default.dest_l2.id"},{"id":1,"vertexType":"COLUMN","vertexId":"default.dest_l2.c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest_l2.c2"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest_l2.c3"}]}
PREHOOK: query: select * from (
@@ -623,7 +622,6 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@dest_l3
PREHOOK: query: insert into dest_l3 values(0, "s1", "s2", 15)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@dest_l3
{"version":"1.0","engine":"mr","database":"default","hash":"09df51ba6ba2d07f2304523ee505f094","queryText":"insert into dest_l3 values(0, \"s1\", \"s2\", 15)","edges":[{"sources":[],"targets":[0],"expression":"UDFToInteger(values__tmp__table__2.tmp_values_col1)","edgeType":"PROJECTION"},{"sources":[],"targets":[1,2],"edgeType":"PROJECTION"},{"sources":[],"targets":[3],"expression":"UDFToInteger(values__tmp__table__2.tmp_values_col4)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"default.dest_l3.id"},{"id":1,"vertexType":"COLUMN","vertexId":"default.dest_l3.c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest_l3.c2"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest_l3.c3"}]}
PREHOOK: query: select sum(a.c1) over (partition by a.c1 order by a.id)
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out b/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
index 4fc4114..3649e56 100644
--- a/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
+++ b/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
@@ -25,11 +25,9 @@ POSTHOOK: Output: default@acidtbldefault
POSTHOOK: Lineage: acidtbldefault.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
PREHOOK: query: INSERT INTO TABLE acidTblDefault VALUES (1)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acidtbldefault
POSTHOOK: query: INSERT INTO TABLE acidTblDefault VALUES (1)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acidtbldefault
POSTHOOK: Lineage: acidtbldefault.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: -- Exactly one of the buckets should be selected out of the 16 buckets
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/acid_vectorization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_vectorization.q.out b/ql/src/test/results/clientpositive/llap/acid_vectorization.q.out
index 1792979..b9b4ce4 100644
--- a/ql/src/test/results/clientpositive/llap/acid_vectorization.q.out
+++ b/ql/src/test/results/clientpositive/llap/acid_vectorization.q.out
@@ -18,11 +18,9 @@ POSTHOOK: Lineage: acid_vectorized.a SIMPLE [(alltypesorc)alltypesorc.FieldSchem
POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
PREHOOK: query: insert into table acid_vectorized values (1, 'bar')
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_vectorized
POSTHOOK: query: insert into table acid_vectorized values (1, 'bar')
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_vectorized
POSTHOOK: Lineage: acid_vectorized.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/cbo_rp_lineage2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/cbo_rp_lineage2.q.out b/ql/src/test/results/clientpositive/llap/cbo_rp_lineage2.q.out
index eac1554..4bc28ce 100644
--- a/ql/src/test/results/clientpositive/llap/cbo_rp_lineage2.q.out
+++ b/ql/src/test/results/clientpositive/llap/cbo_rp_lineage2.q.out
@@ -602,7 +602,6 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@dest_l2
PREHOOK: query: insert into dest_l2 values(0, 1, 100, 10000)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@dest_l2
{"version":"1.0","engine":"tez","database":"default","hash":"e001334e3f8384806b0f25a7c303045f","queryText":"insert into dest_l2 values(0, 1, 100, 10000)","edges":[{"sources":[],"targets":[0],"expression":"UDFToInteger(tmp_values_col1)","edgeType":"PROJECTION"},{"sources":[],"targets":[1],"expression":"UDFToByte(tmp_values_col2)","edgeType":"PROJECTION"},{"sources":[],"targets":[2],"expression":"UDFToInteger(tmp_values_col3)","edgeType":"PROJECTION"},{"sources":[],"targets":[3],"expression":"UDFToLong(tmp_values_col4)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"default.dest_l2.id"},{"id":1,"vertexType":"COLUMN","vertexId":"default.dest_l2.c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest_l2.c2"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest_l2.c3"}]}
PREHOOK: query: select * from (
@@ -623,7 +622,6 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@dest_l3
PREHOOK: query: insert into dest_l3 values(0, "s1", "s2", 15)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@dest_l3
{"version":"1.0","engine":"tez","database":"default","hash":"09df51ba6ba2d07f2304523ee505f094","queryText":"insert into dest_l3 values(0, \"s1\", \"s2\", 15)","edges":[{"sources":[],"targets":[0],"expression":"UDFToInteger(tmp_values_col1)","edgeType":"PROJECTION"},{"sources":[],"targets":[1,2],"edgeType":"PROJECTION"},{"sources":[],"targets":[3],"expression":"UDFToInteger(tmp_values_col4)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"default.dest_l3.id"},{"id":1,"vertexType":"COLUMN","vertexId":"default.dest_l3.c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest_l3.c2"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest_l3.c3"}]}
PREHOOK: query: select sum(a.c1) over (partition by a.c1 order by a.id)
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
index 3facce7..3859496 100644
--- a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
@@ -12,11 +12,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@calendar
PREHOOK: query: insert into calendar values (2010, 10), (2011, 11), (2012, 12)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@calendar
POSTHOOK: query: insert into calendar values (2010, 10), (2011, 11), (2012, 12)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@calendar
POSTHOOK: Lineage: calendar.month EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: calendar.year EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -256,11 +254,9 @@ POSTHOOK: Input: default@calendar
2012
PREHOOK: query: insert into calendar values (2015, 15)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@calendar
POSTHOOK: query: insert into calendar values (2015, 15)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@calendar
POSTHOOK: Lineage: calendar.month EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: calendar.year EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
@@ -642,11 +638,9 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@calendarp
PREHOOK: query: insert into table calendarp partition (p=1) values (2010), (2011), (2012)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@calendarp@p=1
POSTHOOK: query: insert into table calendarp partition (p=1) values (2010), (2011), (2012)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__3
POSTHOOK: Output: default@calendarp@p=1
POSTHOOK: Lineage: calendarp PARTITION(p=1).year EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: desc formatted calendarp partition (p=1)
@@ -820,11 +814,9 @@ STAGE PLANS:
PREHOOK: query: insert into table calendarp partition (p=1) values (2015)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__4
PREHOOK: Output: default@calendarp@p=1
POSTHOOK: query: insert into table calendarp partition (p=1) values (2015)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@calendarp@p=1
POSTHOOK: Lineage: calendarp PARTITION(p=1).year EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: desc formatted calendarp partition (p=1)
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out b/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out
index 18314b5..61a4944 100644
--- a/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out
@@ -44,11 +44,9 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: insert into space values ("1", "2", "3")
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@space
POSTHOOK: query: insert into space values ("1", "2", "3")
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@space
POSTHOOK: Lineage: space. left SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
POSTHOOK: Lineage: space. middle SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
@@ -64,11 +62,9 @@ POSTHOOK: Input: default@space
1 2 3
PREHOOK: query: insert into space (` middle `) values("2")
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@space
POSTHOOK: query: insert into space (` middle `) values("2")
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@space
POSTHOOK: Lineage: space. left SIMPLE []
POSTHOOK: Lineage: space. middle SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]