http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out index d926daf..009eec6 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out @@ -13,9 +13,13 @@ POSTHOOK: Output: default@list_bucketing PREHOOK: query: explain extended insert overwrite table list_bucketing select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@list_bucketing POSTHOOK: query: explain extended insert overwrite table list_bucketing select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@list_bucketing OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: @@ -286,9 +290,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain extended select key, value from list_bucketing where key = "484" PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing +#### A masked pattern was here #### POSTHOOK: query: explain extended select key, value from list_bucketing where key = "484" POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, `value` FROM `default`.`list_bucketing` WHERE `key` = '484'
http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out index 66051c5..2308c2e 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out @@ -18,10 +18,18 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n4 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_static_part_n4@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n4 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@list_bucketing_static_part_n4@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -357,9 +365,15 @@ POSTHOOK: Input: default@list_bucketing_static_part_n4 PREHOOK: query: explain extended select * from list_bucketing_static_part_n4 where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_static_part_n4 +PREHOOK: Input: default@list_bucketing_static_part_n4@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from list_bucketing_static_part_n4 where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_static_part_n4 +POSTHOOK: Input: default@list_bucketing_static_part_n4@ds=2008-04-08/hr=11 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, CAST('2008-04-08' AS STRING) AS `ds`, CAST('11' AS STRING) AS `hr` FROM `default`.`list_bucketing_static_part_n4` WHERE `ds` = '2008-04-08' AND `hr` = '11' AND `key` = '484' AND `value` = 'val_484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out index d935b9b..8ed4bce 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out @@ -9,9 +9,17 @@ POSTHOOK: Output: default@list_bucketing_static_part_n1 PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n1 partition (ds='2008-04-08', hr='11') select key, value from srcpart where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_static_part_n1@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n1 partition (ds='2008-04-08', hr='11') select key, value from srcpart where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@list_bucketing_static_part_n1@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -349,9 +357,15 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: query: explain extended select key, value from list_bucketing_static_part_n1 where ds='2008-04-08' and hr='11' and key = "484" PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_static_part_n1 +PREHOOK: Input: default@list_bucketing_static_part_n1@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain extended select key, value from list_bucketing_static_part_n1 where ds='2008-04-08' and hr='11' and key = "484" POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_static_part_n1 +POSTHOOK: Input: default@list_bucketing_static_part_n1@ds=2008-04-08/hr=11 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, `value` FROM `default`.`list_bucketing_static_part_n1` WHERE `ds` = '2008-04-08' AND `hr` = '11' AND `key` = '484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out index 2a9f48c..dc4c6e6 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out @@ -18,10 +18,18 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n2 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_static_part_n2@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n2 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@list_bucketing_static_part_n2@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -340,10 +348,18 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n2 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_static_part_n2@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n2 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@list_bucketing_static_part_n2@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -799,9 +815,15 @@ POSTHOOK: Input: default@list_bucketing_static_part_n2 PREHOOK: query: explain extended select * from list_bucketing_static_part_n2 where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_static_part_n2 +PREHOOK: Input: default@list_bucketing_static_part_n2@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from list_bucketing_static_part_n2 where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_static_part_n2 +POSTHOOK: Input: default@list_bucketing_static_part_n2@ds=2008-04-08/hr=11 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, CAST('2008-04-08' AS STRING) AS `ds`, CAST('11' AS STRING) AS `hr` FROM `default`.`list_bucketing_static_part_n2` WHERE `ds` = '2008-04-08' AND `hr` = '11' AND `key` = '484' AND `value` = 'val_484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out index cad9183..03c09ab 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out @@ -15,9 +15,16 @@ POSTHOOK: Output: default@list_bucketing_dynamic_part_n1 PREHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n1 partition (ds='2008-04-08', hr) select key, value, hr from srcpart where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_dynamic_part_n1@ds=2008-04-08 POSTHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n1 partition (ds='2008-04-08', hr) select key, value, hr from srcpart where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 OPTIMIZED SQL: SELECT `key`, `value`, `hr` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -406,9 +413,17 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 PREHOOK: query: explain extended select key, value, ds, hr from list_bucketing_dynamic_part_n1 where ds='2008-04-08' and key = "103" and value ="val_103" PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_dynamic_part_n1 +PREHOOK: Input: default@list_bucketing_dynamic_part_n1@ds=2008-04-08/hr=11 +PREHOOK: Input: default@list_bucketing_dynamic_part_n1@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain extended select key, value, ds, hr from list_bucketing_dynamic_part_n1 where ds='2008-04-08' and key = "103" and value ="val_103" POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_dynamic_part_n1 +POSTHOOK: Input: default@list_bucketing_dynamic_part_n1@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@list_bucketing_dynamic_part_n1@ds=2008-04-08/hr=12 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('103' AS STRING) AS `key`, CAST('val_103' AS STRING) AS `value`, CAST('2008-04-08' AS STRING) AS `ds`, `hr` FROM `default`.`list_bucketing_dynamic_part_n1` WHERE `ds` = '2008-04-08' AND `key` = '103' AND `value` = 'val_103' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out index e497c6a..ff5a4e3 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out @@ -18,10 +18,17 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n3 partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_dynamic_part_n3@ds=2008-04-08 POSTHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n3 partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 OPTIMIZED SQL: SELECT `key`, `value`, IF(MOD(CAST(`key` AS DOUBLE), CAST(100 AS DOUBLE)) = 0, 'a1', 'b1') AS `_o__c2` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -385,10 +392,17 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n3 partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_dynamic_part_n3@ds=2008-04-08 POSTHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n3 partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 OPTIMIZED SQL: SELECT `key`, `value`, IF(MOD(CAST(`key` AS DOUBLE), CAST(100 AS DOUBLE)) = 0, 'a1', 'b1') AS `_o__c2` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -895,9 +909,17 @@ POSTHOOK: Input: default@list_bucketing_dynamic_part_n3 PREHOOK: query: explain extended select * from list_bucketing_dynamic_part_n3 where key = '484' and value = 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_dynamic_part_n3 +PREHOOK: Input: default@list_bucketing_dynamic_part_n3@ds=2008-04-08/hr=a1 +PREHOOK: Input: default@list_bucketing_dynamic_part_n3@ds=2008-04-08/hr=b1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from list_bucketing_dynamic_part_n3 where key = '484' and value = 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_dynamic_part_n3 +POSTHOOK: Input: default@list_bucketing_dynamic_part_n3@ds=2008-04-08/hr=a1 +POSTHOOK: Input: default@list_bucketing_dynamic_part_n3@ds=2008-04-08/hr=b1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, `ds`, `hr` FROM `default`.`list_bucketing_dynamic_part_n3` WHERE `key` = '484' AND `value` = 'val_484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out index 5ab1d0d..bf7a2bc 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out @@ -18,10 +18,17 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08 POSTHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 OPTIMIZED SQL: SELECT `key`, `value`, IF(MOD(CAST(`key` AS DOUBLE), CAST(100 AS DOUBLE)) = 0, 'a1', 'b1') AS `_o__c2` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -385,10 +392,17 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08 POSTHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 OPTIMIZED SQL: SELECT `key`, `value`, IF(MOD(CAST(`key` AS DOUBLE), CAST(100 AS DOUBLE)) = 0, 'a1', 'b1') AS `_o__c2` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -895,9 +909,17 @@ POSTHOOK: Input: default@list_bucketing_dynamic_part PREHOOK: query: explain extended select * from list_bucketing_dynamic_part where key = '484' and value = 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_dynamic_part +PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1 +PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=b1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from list_bucketing_dynamic_part where key = '484' and value = 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_dynamic_part +POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1 +POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=b1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, `ds`, `hr` FROM `default`.`list_bucketing_dynamic_part` WHERE `key` = '484' AND `value` = 'val_484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out index 6927684..42f8874 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out @@ -18,10 +18,17 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n2 partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_dynamic_part_n2@ds=2008-04-08 POSTHOOK: query: explain extended insert overwrite table list_bucketing_dynamic_part_n2 partition (ds = '2008-04-08', hr) select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 OPTIMIZED SQL: SELECT `key`, `value`, IF(MOD(CAST(`key` AS DOUBLE), CAST(100 AS DOUBLE)) = 0, 'a1', 'b1') AS `_o__c2` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -456,9 +463,17 @@ POSTHOOK: Input: default@list_bucketing_dynamic_part_n2@ds=2008-04-08/hr=b1 PREHOOK: query: explain extended select * from list_bucketing_dynamic_part_n2 where key = '484' and value = 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_dynamic_part_n2 +PREHOOK: Input: default@list_bucketing_dynamic_part_n2@ds=2008-04-08/hr=a1 +PREHOOK: Input: default@list_bucketing_dynamic_part_n2@ds=2008-04-08/hr=b1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from list_bucketing_dynamic_part_n2 where key = '484' and value = 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_dynamic_part_n2 +POSTHOOK: Input: default@list_bucketing_dynamic_part_n2@ds=2008-04-08/hr=a1 +POSTHOOK: Input: default@list_bucketing_dynamic_part_n2@ds=2008-04-08/hr=b1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, `ds`, `hr` FROM `default`.`list_bucketing_dynamic_part_n2` WHERE `key` = '484' AND `value` = 'val_484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out index 62721e3..7463f6f 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out @@ -18,10 +18,18 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n0 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_static_part_n0@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n0 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@list_bucketing_static_part_n0@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -340,10 +348,18 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n0 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@list_bucketing_static_part_n0@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part_n0 partition (ds = '2008-04-08', hr = '11') select key, value from srcpart where ds = '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@list_bucketing_static_part_n0@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`srcpart` WHERE `ds` = '2008-04-08' @@ -799,9 +815,15 @@ POSTHOOK: Input: default@list_bucketing_static_part_n0 PREHOOK: query: explain extended select * from list_bucketing_static_part_n0 where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@list_bucketing_static_part_n0 +PREHOOK: Input: default@list_bucketing_static_part_n0@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from list_bucketing_static_part_n0 where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@list_bucketing_static_part_n0 +POSTHOOK: Input: default@list_bucketing_static_part_n0@ds=2008-04-08/hr=11 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, CAST('2008-04-08' AS STRING) AS `ds`, CAST('11' AS STRING) AS `hr` FROM `default`.`list_bucketing_static_part_n0` WHERE `ds` = '2008-04-08' AND `hr` = '11' AND `key` = '484' AND `value` = 'val_484' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out index 63ec701..e67df22 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out @@ -78,8 +78,14 @@ POSTHOOK: Input: default@fact_daily 500 PREHOOK: query: explain extended SELECT key FROM fact_daily WHERE ( ds='1' and hr='4') and (key='484' and value= 'val_484') PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily +PREHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key FROM fact_daily WHERE ( ds='1' and hr='4') and (key='484' and value= 'val_484') POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily +POSTHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key` FROM `default`.`fact_daily` WHERE `ds` = '1' AND `hr` = '4' AND `key` = '484' AND `value` = 'val_484' @@ -166,8 +172,14 @@ POSTHOOK: Input: default@fact_daily@ds=1/hr=4 484 PREHOOK: query: explain extended SELECT key,value FROM fact_daily WHERE ( ds='1' and hr='4') and (key='238' and value= 'val_238') PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily +PREHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key,value FROM fact_daily WHERE ( ds='1' and hr='4') and (key='238' and value= 'val_238') POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily +POSTHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('238' AS STRING) AS `key`, CAST('val_238' AS STRING) AS `value` FROM `default`.`fact_daily` WHERE `ds` = '1' AND `hr` = '4' AND `key` = '238' AND `value` = 'val_238' @@ -255,8 +267,14 @@ POSTHOOK: Input: default@fact_daily@ds=1/hr=4 238 val_238 PREHOOK: query: explain extended SELECT key FROM fact_daily WHERE ( ds='1' and hr='4') and (value = "3") PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily +PREHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key FROM fact_daily WHERE ( ds='1' and hr='4') and (value = "3") POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily +POSTHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key` FROM `default`.`fact_daily` WHERE `ds` = '1' AND `hr` = '4' AND `value` = '3' @@ -342,8 +360,14 @@ POSTHOOK: Input: default@fact_daily@ds=1/hr=4 #### A masked pattern was here #### PREHOOK: query: explain extended SELECT key,value FROM fact_daily WHERE ( ds='1' and hr='4') and key = '495' PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily +PREHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key,value FROM fact_daily WHERE ( ds='1' and hr='4') and key = '495' POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily +POSTHOOK: Input: default@fact_daily@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('495' AS STRING) AS `key`, `value` FROM `default`.`fact_daily` WHERE `ds` = '1' AND `hr` = '4' AND `key` = '495' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out index ba9ec5b..1ee7ea4 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out @@ -78,8 +78,14 @@ POSTHOOK: Input: default@fact_daily_n2 500 PREHOOK: query: explain extended SELECT key, value FROM fact_daily_n2 WHERE ds='1' and hr='4' and value= 'val_484' PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n2 +PREHOOK: Input: default@fact_daily_n2@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key, value FROM fact_daily_n2 WHERE ds='1' and hr='4' and value= 'val_484' POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n2 +POSTHOOK: Input: default@fact_daily_n2@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, CAST('val_484' AS STRING) AS `value` FROM `default`.`fact_daily_n2` WHERE `ds` = '1' AND `hr` = '4' AND `value` = 'val_484' @@ -166,8 +172,14 @@ POSTHOOK: Input: default@fact_daily_n2@ds=1/hr=4 484 val_484 PREHOOK: query: explain extended SELECT key FROM fact_daily_n2 WHERE ds='1' and hr='4' and key= '406' PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n2 +PREHOOK: Input: default@fact_daily_n2@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key FROM fact_daily_n2 WHERE ds='1' and hr='4' and key= '406' POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n2 +POSTHOOK: Input: default@fact_daily_n2@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('406' AS STRING) AS `key` FROM `default`.`fact_daily_n2` WHERE `ds` = '1' AND `hr` = '4' AND `key` = '406' @@ -257,8 +269,14 @@ POSTHOOK: Input: default@fact_daily_n2@ds=1/hr=4 406 val_406 PREHOOK: query: explain extended SELECT key, value FROM fact_daily_n2 WHERE ds='1' and hr='4' and ( (key='484' and value ='val_484') or (key='238' and value= 'val_238')) PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n2 +PREHOOK: Input: default@fact_daily_n2@ds=1/hr=4 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT key, value FROM fact_daily_n2 WHERE ds='1' and hr='4' and ( (key='484' and value ='val_484') or (key='238' and value= 'val_238')) POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n2 +POSTHOOK: Input: default@fact_daily_n2@ds=1/hr=4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`fact_daily_n2` WHERE `ds` = '1' AND `hr` = '4' AND (`key` = '484' AND `value` = 'val_484' OR `key` = '238' AND `value` = 'val_238') http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out index 0a1d4a6..3788519 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out @@ -187,9 +187,15 @@ Storage Desc Params: PREHOOK: query: explain extended select * from fact_daily_n3 where ds = '1' and hr='1' and key='145' PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n3 +PREHOOK: Input: default@fact_daily_n3@ds=1/hr=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from fact_daily_n3 where ds = '1' and hr='1' and key='145' POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n3 +POSTHOOK: Input: default@fact_daily_n3@ds=1/hr=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('145' AS STRING) AS `key`, `value`, CAST('1' AS STRING) AS `ds`, CAST('1' AS STRING) AS `hr` FROM `default`.`fact_daily_n3` WHERE `ds` = '1' AND `hr` = '1' AND `key` = '145' @@ -277,9 +283,13 @@ POSTHOOK: Input: default@fact_daily_n3@ds=1/hr=1 PREHOOK: query: explain extended select count(*) from fact_daily_n3 where ds = '1' and hr='1' PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from fact_daily_n3 where ds = '1' and hr='1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM `default`.`fact_daily_n3` WHERE `ds` = '1' AND `hr` = '1' @@ -305,9 +315,15 @@ POSTHOOK: Input: default@fact_daily_n3 PREHOOK: query: explain extended SELECT * FROM fact_daily_n3 WHERE ds='1' and hr='2' and (key='484' and value='val_484') PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n3 +PREHOOK: Input: default@fact_daily_n3@ds=1/hr=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT * FROM fact_daily_n3 WHERE ds='1' and hr='2' and (key='484' and value='val_484') POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n3 +POSTHOOK: Input: default@fact_daily_n3@ds=1/hr=2 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('484' AS STRING) AS `key`, CAST('val_484' AS STRING) AS `value`, CAST('1' AS STRING) AS `ds`, CAST('2' AS STRING) AS `hr` FROM `default`.`fact_daily_n3` WHERE `ds` = '1' AND `hr` = '2' AND `key` = '484' AND `value` = 'val_484' @@ -395,9 +411,15 @@ POSTHOOK: Input: default@fact_daily_n3@ds=1/hr=2 PREHOOK: query: explain extended SELECT * FROM fact_daily_n3 WHERE ds='1' and hr='3' and (key='327' and value='val_327') PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n3 +PREHOOK: Input: default@fact_daily_n3@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT * FROM fact_daily_n3 WHERE ds='1' and hr='3' and (key='327' and value='val_327') POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n3 +POSTHOOK: Input: default@fact_daily_n3@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST('327' AS STRING) AS `key`, CAST('val_327' AS STRING) AS `value`, CAST('1' AS STRING) AS `ds`, CAST('3' AS STRING) AS `hr` FROM `default`.`fact_daily_n3` WHERE `ds` = '1' AND `hr` = '3' AND `key` = '327' AND `value` = 'val_327' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out index f9a1c95..ddaaf2c 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out @@ -129,8 +129,14 @@ POSTHOOK: Input: default@fact_daily_n4@ds=1 495 1 PREHOOK: query: explain extended SELECT x FROM fact_daily_n4 WHERE ds='1' and x=484 PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n4 +PREHOOK: Input: default@fact_daily_n4@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT x FROM fact_daily_n4 WHERE ds='1' and x=484 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n4 +POSTHOOK: Input: default@fact_daily_n4@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(484 AS INTEGER) AS `x` FROM `default`.`fact_daily_n4` WHERE `ds` = '1' AND `x` = 484 @@ -214,8 +220,14 @@ POSTHOOK: Input: default@fact_daily_n4@ds=1 484 PREHOOK: query: explain extended SELECT x FROM fact_daily_n4 WHERE ds='1' and x=495 PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n4 +PREHOOK: Input: default@fact_daily_n4@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT x FROM fact_daily_n4 WHERE ds='1' and x=495 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n4 +POSTHOOK: Input: default@fact_daily_n4@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(495 AS INTEGER) AS `x` FROM `default`.`fact_daily_n4` WHERE `ds` = '1' AND `x` = 495 @@ -299,8 +311,14 @@ POSTHOOK: Input: default@fact_daily_n4@ds=1 495 PREHOOK: query: explain extended SELECT x FROM fact_daily_n4 WHERE ds='1' and x=1 PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n4 +PREHOOK: Input: default@fact_daily_n4@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT x FROM fact_daily_n4 WHERE ds='1' and x=1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n4 +POSTHOOK: Input: default@fact_daily_n4@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `x` FROM `default`.`fact_daily_n4` WHERE `ds` = '1' AND `x` = 1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out index 3b98e4f..9a5de43 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out @@ -132,8 +132,14 @@ POSTHOOK: Input: default@fact_daily_n5@ds=1 495 val_484 1 PREHOOK: query: explain extended select x from (select x from fact_daily_n5 where ds = '1') subq where x = 484 PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n5 +PREHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select x from (select x from fact_daily_n5 where ds = '1') subq where x = 484 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n5 +POSTHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(484 AS INTEGER) AS `x` FROM `default`.`fact_daily_n5` WHERE `ds` = '1' AND `x` = 484 @@ -217,8 +223,14 @@ POSTHOOK: Input: default@fact_daily_n5@ds=1 484 PREHOOK: query: explain extended select x1, y1 from(select x as x1, y as y1 from fact_daily_n5 where ds ='1') subq where x1 = 484 PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n5 +PREHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select x1, y1 from(select x as x1, y as y1 from fact_daily_n5 where ds ='1') subq where x1 = 484 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n5 +POSTHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(484 AS INTEGER) AS `x1`, `y` AS `y1` FROM `default`.`fact_daily_n5` WHERE `ds` = '1' AND `x` = 484 @@ -302,8 +314,14 @@ POSTHOOK: Input: default@fact_daily_n5@ds=1 484 val_484 PREHOOK: query: explain extended select y, count(1) from fact_daily_n5 where ds ='1' and x = 484 group by y PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n5 +PREHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select y, count(1) from fact_daily_n5 where ds ='1' and x = 484 group by y POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n5 +POSTHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `y`, COUNT(*) AS `$f1` FROM `default`.`fact_daily_n5` WHERE `ds` = '1' AND `x` = 484 @@ -445,8 +463,14 @@ POSTHOOK: Input: default@fact_daily_n5@ds=1 val_484 1 PREHOOK: query: explain extended select x, c from (select x, count(1) as c from fact_daily_n5 where ds = '1' group by x) subq where x = 484 PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n5 +PREHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select x, c from (select x, count(1) as c from fact_daily_n5 where ds = '1' group by x) subq where x = 484 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n5 +POSTHOOK: Input: default@fact_daily_n5@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(484 AS INTEGER) AS `x`, COUNT(*) AS `c` FROM `default`.`fact_daily_n5` WHERE `ds` = '1' AND `x` = 484 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out index dc7e501..b82f711 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out @@ -152,8 +152,14 @@ POSTHOOK: Input: default@fact_daily_n0@ds=1 86 val_86 val_86 1 PREHOOK: query: explain extended SELECT x FROM fact_daily_n0 WHERE ds='1' and not (x = 86) PREHOOK: type: QUERY +PREHOOK: Input: default@fact_daily_n0 +PREHOOK: Input: default@fact_daily_n0@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended SELECT x FROM fact_daily_n0 WHERE ds='1' and not (x = 86) POSTHOOK: type: QUERY +POSTHOOK: Input: default@fact_daily_n0 +POSTHOOK: Input: default@fact_daily_n0@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `x` FROM `default`.`fact_daily_n0` WHERE `ds` = '1' AND `x` <> 86 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/literal_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/literal_decimal.q.out b/ql/src/test/results/clientpositive/literal_decimal.q.out index 6012933..61f9f7f 100644 --- a/ql/src/test/results/clientpositive/literal_decimal.q.out +++ b/ql/src/test/results/clientpositive/literal_decimal.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT -1BD, 0BD, 1BD, 3.14BD, -3.14BD, 99999999999999999BD, 99999999999999999.9999999999999BD, 1E99BD FROM src LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT -1BD, 0BD, 1BD, 3.14BD, -3.14BD, 99999999999999999BD, 99999999999999999.9999999999999BD, 1E99BD FROM src LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/literal_double.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/literal_double.q.out b/ql/src/test/results/clientpositive/literal_double.q.out index 76236ca..81459c9 100644 --- a/ql/src/test/results/clientpositive/literal_double.q.out +++ b/ql/src/test/results/clientpositive/literal_double.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT 3.14, -3.14, 3.14e8, 3.14e-8, -3.14e8, -3.14e-8, 3.14e+8, 3.14E8, 3.14E-8 FROM src LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT 3.14, -3.14, 3.14e8, 3.14e-8, -3.14e8, -3.14e-8, 3.14e+8, 3.14E8, 3.14E-8 FROM src LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/literal_ints.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/literal_ints.q.out b/ql/src/test/results/clientpositive/literal_ints.q.out index a3230b9..9867e09 100644 --- a/ql/src/test/results/clientpositive/literal_ints.q.out +++ b/ql/src/test/results/clientpositive/literal_ints.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT 100, 100Y, 100S, 100L FROM src LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT 100, 100Y, 100S, 100L FROM src LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/literal_string.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/literal_string.q.out b/ql/src/test/results/clientpositive/literal_string.q.out index b2f5e12..c5bfd75 100644 --- a/ql/src/test/results/clientpositive/literal_string.q.out +++ b/ql/src/test/results/clientpositive/literal_string.q.out @@ -5,6 +5,8 @@ PREHOOK: query: EXPLAIN SELECT 'face''book', 'face' 'book', 'face' 'face' 'bo' 'ok', 'face'"book", "face"'book', 'facebook' FROM src LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT 'face''book', 'face' 'book', 'face' 'book', "face""book", "face" "book", "face" @@ -12,6 +14,8 @@ POSTHOOK: query: EXPLAIN SELECT 'face''book', 'face' 'book', 'face' 'face' 'bo' 'ok', 'face'"book", "face"'book', 'facebook' FROM src LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 3a7eb2b..1eb4614 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 @@ -27,9 +27,13 @@ POSTHOOK: Lineage: acidtbldefault.a SCRIPT [] PREHOOK: query: EXPLAIN EXTENDED SELECT * FROM acidTblDefault WHERE a = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@acidtbldefault +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN EXTENDED SELECT * FROM acidTblDefault WHERE a = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acidtbldefault +POSTHOOK: Output: hdfs://### HDFS PATH ### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `a` FROM `default`.`acidtbldefault` WHERE `a` = 1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out b/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out index 1379ba7..226c8a9 100644 --- a/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out +++ b/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out @@ -99,8 +99,18 @@ POSTHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain update srcpart_acid set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acid +PREHOOK: Input: default@srcpart_acid@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acid@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acid@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=11 POSTHOOK: query: explain update srcpart_acid set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acid +POSTHOOK: Input: default@srcpart_acid@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acid@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acid@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -282,8 +292,26 @@ POSTHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain delete from srcpart_acid where key in( '1001', '213', '43') PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acid +PREHOOK: Input: default@srcpart_acid@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acid@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart_acid@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart_acid@ds=2008-04-09/hr=12 +PREHOOK: Output: default@srcpart_acid@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acid@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=12 POSTHOOK: query: explain delete from srcpart_acid where key in( '1001', '213', '43') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acid +POSTHOOK: Input: default@srcpart_acid@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acid@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart_acid@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart_acid@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@srcpart_acid@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acid@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acid@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -600,8 +628,18 @@ POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain update srcpart_acidb set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidb +PREHOOK: Input: default@srcpart_acidb@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidb@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidb@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=11 POSTHOOK: query: explain update srcpart_acidb set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidb +POSTHOOK: Input: default@srcpart_acidb@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidb@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -783,8 +821,26 @@ POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain delete from srcpart_acidb where key in( '1001', '213', '43') PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidb +PREHOOK: Input: default@srcpart_acidb@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidb@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart_acidb@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart_acidb@ds=2008-04-09/hr=12 +PREHOOK: Output: default@srcpart_acidb@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidb@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=12 POSTHOOK: query: explain delete from srcpart_acidb where key in( '1001', '213', '43') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidb +POSTHOOK: Input: default@srcpart_acidb@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidb@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart_acidb@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart_acidb@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidb@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1102,9 +1158,19 @@ POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 PREHOOK: query: explain vectorization only detail update srcpart_acidv set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidv +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 POSTHOOK: query: explain vectorization only detail update srcpart_acidv set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidv +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1302,9 +1368,27 @@ POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 PREHOOK: query: explain vectorization only detail delete from srcpart_acidv where key in( '1001', '213', '43') PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidv +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=12 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 POSTHOOK: query: explain vectorization only detail delete from srcpart_acidv where key in( '1001', '213', '43') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidv +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1453,6 +1537,21 @@ when matched and s.ds='2008-04-08' and s.hr=='11' and s.key='44' then update set when matched and s.ds='2008-04-08' and s.hr=='12' then delete when not matched then insert values('this','should','not','be there') PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidv +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=12 +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@srcpart_acidv +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 +PREHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 POSTHOOK: query: explain vectorization only detail merge into srcpart_acidv t using (select distinct ds, hr, key, value from srcpart_acidv) s on s.ds=t.ds and s.hr=t.hr and s.key=t.key and s.value=t.value @@ -1460,6 +1559,20 @@ when matched and s.ds='2008-04-08' and s.hr=='11' and s.key='44' then update set when matched and s.ds='2008-04-08' and s.hr=='12' then delete when not matched then insert values('this','should','not','be there') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidv +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart_acidv@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@srcpart_acidv@ds=2008-04-09/hr=12 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1888,9 +2001,19 @@ POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 PREHOOK: query: explain vectorization only detail update srcpart_acidvb set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidvb +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 POSTHOOK: query: explain vectorization only detail update srcpart_acidvb set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidvb +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2088,9 +2211,27 @@ POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 PREHOOK: query: explain vectorization only detail delete from srcpart_acidvb where key in( '1001', '213', '43') PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidvb +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=12 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 POSTHOOK: query: explain vectorization only detail delete from srcpart_acidvb where key in( '1001', '213', '43') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidvb +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2239,6 +2380,21 @@ when matched and s.ds='2008-04-08' and s.hr=='11' and s.key='44' then update set when matched and s.ds='2008-04-08' and s.hr=='12' then delete when not matched then insert values('this','should','not','be there') PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_acidvb +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=12 +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@srcpart_acidvb +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=12 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 +PREHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 POSTHOOK: query: explain vectorization only detail merge into srcpart_acidvb t using (select distinct ds, hr, key, value from srcpart_acidvb) s on s.ds=t.ds and s.hr=t.hr and s.key=t.key and s.value=t.value @@ -2246,6 +2402,20 @@ when matched and s.ds='2008-04-08' and s.hr=='11' and s.key='44' then update set when matched and s.ds='2008-04-08' and s.hr=='12' then delete when not matched then insert values('this','should','not','be there') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_acidvb +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart_acidvb@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@srcpart_acidvb@ds=2008-04-09/hr=12 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out b/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out index 44b7a77..a23c4b1 100644 --- a/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out +++ b/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out @@ -410,8 +410,12 @@ POSTHOOK: Input: default@over10k_orc_bucketed POSTHOOK: Output: default@over10k_orc_bucketed PREHOOK: query: explain select t, si, i from over10k_orc_bucketed where b = 4294967363 and t < 100 order by t, si, i PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_orc_bucketed +#### A masked pattern was here #### POSTHOOK: query: explain select t, si, i from over10k_orc_bucketed where b = 4294967363 and t < 100 order by t, si, i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_orc_bucketed +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -480,8 +484,12 @@ POSTHOOK: Input: default@over10k_orc_bucketed 35 463 65646 PREHOOK: query: explain select ROW__ID, t, si, i from over10k_orc_bucketed where b = 4294967363 and t < 100 order by ROW__ID PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_orc_bucketed +#### A masked pattern was here #### POSTHOOK: query: explain select ROW__ID, t, si, i from over10k_orc_bucketed where b = 4294967363 and t < 100 order by ROW__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_orc_bucketed +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -551,8 +559,12 @@ POSTHOOK: Input: default@over10k_orc_bucketed {"writeid":0,"bucketid":537067520,"rowid":406} 35 463 65646 PREHOOK: query: explain update over10k_orc_bucketed set i = 0 where b = 4294967363 and t < 100 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_orc_bucketed +PREHOOK: Output: default@over10k_orc_bucketed POSTHOOK: query: explain update over10k_orc_bucketed set i = 0 where b = 4294967363 and t < 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_orc_bucketed +POSTHOOK: Output: default@over10k_orc_bucketed STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -647,8 +659,12 @@ POSTHOOK: Input: default@over10k_orc_bucketed {"writeid":### Masked writeid ###,"bucketid":537067520,"rowid":1} 35 463 0 PREHOOK: query: explain select ROW__ID, count(*) from over10k_orc_bucketed group by ROW__ID having count(*) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_orc_bucketed +#### A masked pattern was here #### POSTHOOK: query: explain select ROW__ID, count(*) from over10k_orc_bucketed group by ROW__ID having count(*) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_orc_bucketed +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out index ed3bb27..b5c2b88 100644 --- a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out +++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out @@ -22,8 +22,12 @@ POSTHOOK: Lineage: src_multi1_n1.key SIMPLE [(src)src.FieldSchema(name:key, type POSTHOOK: Lineage: src_multi1_n1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain extended select * from src_multi1_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_multi1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from src_multi1_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_multi1_n1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src_multi1_n1` STAGE DEPENDENCIES: @@ -478,8 +482,16 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select key from nzhang_part14_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part14_n1 +PREHOOK: Input: default@nzhang_part14_n1@value= +PREHOOK: Input: default@nzhang_part14_n1@value=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain select key from nzhang_part14_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part14_n1 +POSTHOOK: Input: default@nzhang_part14_n1@value= +POSTHOOK: Input: default@nzhang_part14_n1@value=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -532,8 +544,26 @@ POSTHOOK: Lineage: nzhang_part14_n1 PARTITION(value=val_311).key SIMPLE [(src5_n POSTHOOK: Lineage: nzhang_part14_n1 PARTITION(value=val_86).key SIMPLE [(src5_n0)src5_n0.FieldSchema(name:key, type:string, comment:null), ] PREHOOK: query: explain select key from nzhang_part14_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part14_n1 +PREHOOK: Input: default@nzhang_part14_n1@value= +PREHOOK: Input: default@nzhang_part14_n1@value=__HIVE_DEFAULT_PARTITION__ +PREHOOK: Input: default@nzhang_part14_n1@value=val_165 +PREHOOK: Input: default@nzhang_part14_n1@value=val_238 +PREHOOK: Input: default@nzhang_part14_n1@value=val_27 +PREHOOK: Input: default@nzhang_part14_n1@value=val_311 +PREHOOK: Input: default@nzhang_part14_n1@value=val_86 +#### A masked pattern was here #### POSTHOOK: query: explain select key from nzhang_part14_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part14_n1 +POSTHOOK: Input: default@nzhang_part14_n1@value= +POSTHOOK: Input: default@nzhang_part14_n1@value=__HIVE_DEFAULT_PARTITION__ +POSTHOOK: Input: default@nzhang_part14_n1@value=val_165 +POSTHOOK: Input: default@nzhang_part14_n1@value=val_238 +POSTHOOK: Input: default@nzhang_part14_n1@value=val_27 +POSTHOOK: Input: default@nzhang_part14_n1@value=val_311 +POSTHOOK: Input: default@nzhang_part14_n1@value=val_86 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -644,8 +674,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from alter5_n0 where dt='a' PREHOOK: type: QUERY +PREHOOK: Input: default@alter5_n0 +PREHOOK: Input: default@alter5_n0@dt=a +#### A masked pattern was here #### POSTHOOK: query: explain select * from alter5_n0 where dt='a' POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter5_n0 +POSTHOOK: Input: default@alter5_n0@dt=a +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1324,8 +1360,16 @@ POSTHOOK: Lineage: c_n2 PARTITION(ds=2010-05-11,hr=12).key SIMPLE [(srcpart)srcp POSTHOOK: Lineage: c_n2 PARTITION(ds=2010-05-11,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain select key from a_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n12 +PREHOOK: Input: default@a_n12@ds=2010-03-11/hr=11 +PREHOOK: Input: default@a_n12@ds=2010-03-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key from a_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n12 +POSTHOOK: Input: default@a_n12@ds=2010-03-11/hr=11 +POSTHOOK: Input: default@a_n12@ds=2010-03-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1343,8 +1387,14 @@ STAGE PLANS: PREHOOK: query: explain select value from b_n9 PREHOOK: type: QUERY +PREHOOK: Input: default@b_n9 +PREHOOK: Input: default@b_n9@ds=2010-04-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select value from b_n9 POSTHOOK: type: QUERY +POSTHOOK: Input: default@b_n9 +POSTHOOK: Input: default@b_n9@ds=2010-04-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1362,8 +1412,14 @@ STAGE PLANS: PREHOOK: query: explain select key from b_n9 PREHOOK: type: QUERY +PREHOOK: Input: default@b_n9 +PREHOOK: Input: default@b_n9@ds=2010-04-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key from b_n9 POSTHOOK: type: QUERY +POSTHOOK: Input: default@b_n9 +POSTHOOK: Input: default@b_n9@ds=2010-04-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1381,8 +1437,16 @@ STAGE PLANS: PREHOOK: query: explain select value from c_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@c_n2 +PREHOOK: Input: default@c_n2@ds=2010-05-11/hr=11 +PREHOOK: Input: default@c_n2@ds=2010-05-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select value from c_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@c_n2 +POSTHOOK: Input: default@c_n2@ds=2010-05-11/hr=11 +POSTHOOK: Input: default@c_n2@ds=2010-05-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1400,8 +1464,16 @@ STAGE PLANS: PREHOOK: query: explain select key from c_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@c_n2 +PREHOOK: Input: default@c_n2@ds=2010-05-11/hr=11 +PREHOOK: Input: default@c_n2@ds=2010-05-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key from c_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@c_n2 +POSTHOOK: Input: default@c_n2@ds=2010-05-11/hr=11 +POSTHOOK: Input: default@c_n2@ds=2010-05-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out index 5052341..af37edb 100644 --- a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out +++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out @@ -22,8 +22,12 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:st POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain extended select * from src_multi1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_multi1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from src_multi1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_multi1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src_multi1` STAGE DEPENDENCIES: @@ -475,8 +479,16 @@ POSTHOOK: Lineage: nzhang_part14 PARTITION(value= ).key EXPRESSION [] POSTHOOK: Lineage: nzhang_part14 PARTITION(value=__HIVE_DEFAULT_PARTITION__).key EXPRESSION [] PREHOOK: query: explain select key from nzhang_part14 PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part14 +PREHOOK: Input: default@nzhang_part14@value= +PREHOOK: Input: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain select key from nzhang_part14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part14 +POSTHOOK: Input: default@nzhang_part14@value= +POSTHOOK: Input: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -529,8 +541,26 @@ POSTHOOK: Lineage: nzhang_part14 PARTITION(value=val_311).key SIMPLE [(src5)src5 POSTHOOK: Lineage: nzhang_part14 PARTITION(value=val_86).key SIMPLE [(src5)src5.FieldSchema(name:key, type:string, comment:null), ] PREHOOK: query: explain select key from nzhang_part14 PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part14 +PREHOOK: Input: default@nzhang_part14@value= +PREHOOK: Input: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +PREHOOK: Input: default@nzhang_part14@value=val_165 +PREHOOK: Input: default@nzhang_part14@value=val_238 +PREHOOK: Input: default@nzhang_part14@value=val_27 +PREHOOK: Input: default@nzhang_part14@value=val_311 +PREHOOK: Input: default@nzhang_part14@value=val_86 +#### A masked pattern was here #### POSTHOOK: query: explain select key from nzhang_part14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part14 +POSTHOOK: Input: default@nzhang_part14@value= +POSTHOOK: Input: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +POSTHOOK: Input: default@nzhang_part14@value=val_165 +POSTHOOK: Input: default@nzhang_part14@value=val_238 +POSTHOOK: Input: default@nzhang_part14@value=val_27 +POSTHOOK: Input: default@nzhang_part14@value=val_311 +POSTHOOK: Input: default@nzhang_part14@value=val_86 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -648,8 +678,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from alter5 where dt='a' PREHOOK: type: QUERY +PREHOOK: Input: default@alter5 +PREHOOK: Input: default@alter5@dt=a +#### A masked pattern was here #### POSTHOOK: query: explain select * from alter5 where dt='a' POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter5 +POSTHOOK: Input: default@alter5@dt=a +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -765,8 +801,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from alter5 where dt='a' PREHOOK: type: QUERY +PREHOOK: Input: default@alter5 +PREHOOK: Input: default@alter5@dt=a +#### A masked pattern was here #### POSTHOOK: query: explain select * from alter5 where dt='a' POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter5 +POSTHOOK: Input: default@alter5@dt=a +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1445,8 +1487,16 @@ POSTHOOK: Lineage: c_n1 PARTITION(ds=2010-05-11,hr=12).key SIMPLE [(srcpart)srcp POSTHOOK: Lineage: c_n1 PARTITION(ds=2010-05-11,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain select key from a_n3 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n3 +PREHOOK: Input: default@a_n3@ds=2010-03-11/hr=11 +PREHOOK: Input: default@a_n3@ds=2010-03-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key from a_n3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n3 +POSTHOOK: Input: default@a_n3@ds=2010-03-11/hr=11 +POSTHOOK: Input: default@a_n3@ds=2010-03-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1464,8 +1514,14 @@ STAGE PLANS: PREHOOK: query: explain select value from b_n3 PREHOOK: type: QUERY +PREHOOK: Input: default@b_n3 +PREHOOK: Input: default@b_n3@ds=2010-04-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select value from b_n3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@b_n3 +POSTHOOK: Input: default@b_n3@ds=2010-04-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1483,8 +1539,14 @@ STAGE PLANS: PREHOOK: query: explain select key from b_n3 PREHOOK: type: QUERY +PREHOOK: Input: default@b_n3 +PREHOOK: Input: default@b_n3@ds=2010-04-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key from b_n3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@b_n3 +POSTHOOK: Input: default@b_n3@ds=2010-04-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1502,8 +1564,16 @@ STAGE PLANS: PREHOOK: query: explain select value from c_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@c_n1 +PREHOOK: Input: default@c_n1@ds=2010-05-11/hr=11 +PREHOOK: Input: default@c_n1@ds=2010-05-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select value from c_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@c_n1 +POSTHOOK: Input: default@c_n1@ds=2010-05-11/hr=11 +POSTHOOK: Input: default@c_n1@ds=2010-05-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1521,8 +1591,16 @@ STAGE PLANS: PREHOOK: query: explain select key from c_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@c_n1 +PREHOOK: Input: default@c_n1@ds=2010-05-11/hr=11 +PREHOOK: Input: default@c_n1@ds=2010-05-11/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key from c_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@c_n1 +POSTHOOK: Input: default@c_n1@ds=2010-05-11/hr=11 +POSTHOOK: Input: default@c_n1@ds=2010-05-11/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/auto_join0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join0.q.out b/ql/src/test/results/clientpositive/llap/auto_join0.q.out index a42001e..679ad24 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join0.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join0.q.out @@ -10,6 +10,8 @@ SELECT src1.key as k1, src1.value as v1, SORT BY k1, v1, k2, v2 ) a PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(a.k1,a.v1,a.k2, a.v2)) from ( @@ -21,6 +23,8 @@ SELECT src1.key as k1, src1.value as v1, SORT BY k1, v1, k2, v2 ) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/auto_join1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join1.q.out b/ql/src/test/results/clientpositive/llap/auto_join1.q.out index 17987a7..fada1a5 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join1.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join1.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest_j1_n3 SELECT src1.key, src2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest_j1_n3 POSTHOOK: query: explain FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest_j1_n3 SELECT src1.key, src2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest_j1_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/auto_join21.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join21.q.out b/ql/src/test/results/clientpositive/llap/auto_join21.q.out index 5889720..8022edd 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join21.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join21.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1