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("Ðбвгде Garçu 谢谢", "Kôkaku ãããã¨ã"), ("ãããã¾ã", "kidôtaiíêµì´") PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@insert_values_nonascii POSTHOOK: query: insert into insert_values_nonascii values("Ðбвгде Garçu 谢谢", "Kôkaku ãããã¨ã"), ("ãããã¾ã", "kidôtaiíêµì´") 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:), ]
