http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_udf1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf1.q.out b/ql/src/test/results/clientpositive/llap/vector_udf1.q.out index aef23fd..f7364b1 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf1.q.out @@ -37,6 +37,8 @@ select concat(c1, c2) = concat(c3, c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select concat(c1, c2), @@ -44,6 +46,8 @@ select concat(c1, c2) = concat(c3, c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -138,6 +142,8 @@ select upper(c2) = upper(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select upper(c2), @@ -145,6 +151,8 @@ select upper(c2) = upper(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -239,6 +247,8 @@ select lower(c2) = lower(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select lower(c2), @@ -246,6 +256,8 @@ select lower(c2) = lower(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -340,6 +352,8 @@ select ascii(c2) = ascii(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select ascii(c2), @@ -347,6 +361,8 @@ select ascii(c2) = ascii(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -441,6 +457,8 @@ select concat_ws('|', c1, c2) = concat_ws('|', c3, c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select concat_ws('|', c1, c2), @@ -448,6 +466,8 @@ select concat_ws('|', c1, c2) = concat_ws('|', c3, c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -542,6 +562,8 @@ select decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select decode(encode(c2, 'US-ASCII'), 'US-ASCII'), @@ -549,6 +571,8 @@ select decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -643,6 +667,8 @@ select instr(c2, '_') = instr(c4, '_') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select instr(c2, '_'), @@ -650,6 +676,8 @@ select instr(c2, '_') = instr(c4, '_') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -744,6 +772,8 @@ select replace(c1, '_', c2) = replace(c3, '_', c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select replace(c1, '_', c2), @@ -751,6 +781,8 @@ select replace(c1, '_', c2) = replace(c3, '_', c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -845,6 +877,8 @@ select reverse(c2) = reverse(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select reverse(c2), @@ -852,6 +886,8 @@ select reverse(c2) = reverse(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -946,6 +982,8 @@ select next_day(d1, 'TU') = next_day(d4, 'WE') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select next_day(d1, 'TU'), @@ -953,6 +991,8 @@ select next_day(d1, 'TU') = next_day(d4, 'WE') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1047,6 +1087,8 @@ select months_between(d1, d3) = months_between(d2, d4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select months_between(d1, d3), @@ -1054,6 +1096,8 @@ select months_between(d1, d3) = months_between(d2, d4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1148,6 +1192,8 @@ select length(c2) = length(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select length(c2), @@ -1155,6 +1201,8 @@ select length(c2) = length(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1249,6 +1297,8 @@ select locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select locate('a', 'abcdabcd', 3), @@ -1256,6 +1306,8 @@ select locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1350,6 +1402,8 @@ select lpad(c2, 15, ' ') = lpad(c4, 15, ' ') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select lpad(c2, 15, ' '), @@ -1357,6 +1411,8 @@ select lpad(c2, 15, ' ') = lpad(c4, 15, ' ') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1451,6 +1507,8 @@ select ltrim(c2) = ltrim(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select ltrim(c2), @@ -1458,6 +1516,8 @@ select ltrim(c2) = ltrim(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1552,6 +1612,8 @@ select (c2 regexp 'val') = (c4 regexp 'val') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select c2 regexp 'val', @@ -1559,6 +1621,8 @@ select (c2 regexp 'val') = (c4 regexp 'val') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1653,6 +1717,8 @@ select regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select regexp_extract(c2, 'val_([0-9]+)', 1), @@ -1660,6 +1726,8 @@ select regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1754,6 +1822,8 @@ select regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select regexp_replace(c2, 'val', 'replaced'), @@ -1761,6 +1831,8 @@ select regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1855,6 +1927,8 @@ select reverse(c2) = reverse(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select reverse(c2), @@ -1862,6 +1936,8 @@ select reverse(c2) = reverse(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1956,6 +2032,8 @@ select rpad(c2, 15, ' ') = rpad(c4, 15, ' ') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select rpad(c2, 15, ' '), @@ -1963,6 +2041,8 @@ select rpad(c2, 15, ' ') = rpad(c4, 15, ' ') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2057,6 +2137,8 @@ select rtrim(c2) = rtrim(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select rtrim(c2), @@ -2064,6 +2146,8 @@ select rtrim(c2) = rtrim(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2157,12 +2241,16 @@ select sentences(cast('See spot run. See jane run.' as varchar(50))) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select sentences('See spot run. See jane run.'), sentences(cast('See spot run. See jane run.' as varchar(50))) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2254,12 +2342,16 @@ select split(c4, '_') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select split(c2, '_'), split(c4, '_') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2351,12 +2443,16 @@ select str_to_map(cast('a:1,b:2,c:3' as varchar(20)),',',':') from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select str_to_map('a:1,b:2,c:3',',',':'), str_to_map(cast('a:1,b:2,c:3' as varchar(20)),',',':') from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2449,6 +2545,8 @@ select substr(c2, 1, 3) = substr(c4, 1, 3) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select substr(c2, 1, 3), @@ -2456,6 +2554,8 @@ select substr(c2, 1, 3) = substr(c4, 1, 3) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2550,6 +2650,8 @@ select trim(c2) = trim(c4) from varchar_udf_1_n2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select trim(c2), @@ -2557,6 +2659,8 @@ select trim(c2) = trim(c4) from varchar_udf_1_n2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2650,12 +2754,16 @@ select compute_stats(c4, 16) from varchar_udf_1_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select compute_stats(c2, 16), compute_stats(c4, 16) from varchar_udf_1_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2746,12 +2854,16 @@ select min(c4) from varchar_udf_1_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select min(c2), min(c4) from varchar_udf_1_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2889,12 +3001,16 @@ select max(c4) from varchar_udf_1_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select max(c2), max(c4) from varchar_udf_1_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1_n2 +#### A masked pattern was here #### 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/vector_udf2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf2.q.out b/ql/src/test/results/clientpositive/llap/vector_udf2.q.out index 58c60d1..f4722ff 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf2.q.out @@ -34,6 +34,8 @@ select c3 LIKE '%x38' from varchar_udf_2 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select c1 LIKE '%38%', @@ -44,6 +46,8 @@ select c3 LIKE '%x38' from varchar_udf_2 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -158,9 +162,13 @@ POSTHOOK: Lineage: hive_14349.a SCRIPT [] PREHOOK: query: explain vectorization expression select * from HIVE_14349 where a LIKE 'XYZ%a%' PREHOOK: type: QUERY +PREHOOK: Input: default@hive_14349 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from HIVE_14349 where a LIKE 'XYZ%a%' POSTHOOK: type: QUERY +POSTHOOK: Input: default@hive_14349 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -245,9 +253,13 @@ POSTHOOK: Lineage: hive_14349.a SCRIPT [] PREHOOK: query: explain vectorization expression select * from HIVE_14349 where a LIKE 'XYZ%a_' PREHOOK: type: QUERY +PREHOOK: Input: default@hive_14349 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from HIVE_14349 where a LIKE 'XYZ%a_' POSTHOOK: type: QUERY +POSTHOOK: Input: default@hive_14349 +#### A masked pattern was here #### 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/vector_udf_adaptor_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf_adaptor_1.q.out b/ql/src/test/results/clientpositive/llap/vector_udf_adaptor_1.q.out index e7a0ffb..bd8160b 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf_adaptor_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf_adaptor_1.q.out @@ -95,6 +95,8 @@ insert overwrite table insert_a_adaptor IF(LENGTH(name)> 10, 2 * gpa, NULL) from student_10_lines PREHOOK: type: QUERY +PREHOOK: Input: default@student_10_lines +PREHOOK: Output: default@insert_a_adaptor POSTHOOK: query: explain vectorization detail insert overwrite table insert_a_adaptor select @@ -109,6 +111,8 @@ insert overwrite table insert_a_adaptor IF(LENGTH(name)> 10, 2 * gpa, NULL) from student_10_lines POSTHOOK: type: QUERY +POSTHOOK: Input: default@student_10_lines +POSTHOOK: Output: default@insert_a_adaptor Explain PLAN VECTORIZATION: enabled: true @@ -251,6 +255,8 @@ insert overwrite table insert_a_good IF(LENGTH(name)> 10, 2 * gpa, NULL) from student_10_lines PREHOOK: type: QUERY +PREHOOK: Input: default@student_10_lines +PREHOOK: Output: default@insert_a_good POSTHOOK: query: explain vectorization detail insert overwrite table insert_a_good select @@ -265,6 +271,8 @@ insert overwrite table insert_a_good IF(LENGTH(name)> 10, 2 * gpa, NULL) from student_10_lines POSTHOOK: type: QUERY +POSTHOOK: Input: default@student_10_lines +POSTHOOK: Output: default@insert_a_good Explain PLAN VECTORIZATION: enabled: true @@ -427,6 +435,8 @@ insert overwrite table insert_a_better IF(LENGTH(name)> 10, 2 * gpa, NULL) from student_10_lines PREHOOK: type: QUERY +PREHOOK: Input: default@student_10_lines +PREHOOK: Output: default@insert_a_better POSTHOOK: query: explain vectorization detail insert overwrite table insert_a_better select @@ -441,6 +451,8 @@ insert overwrite table insert_a_better IF(LENGTH(name)> 10, 2 * gpa, NULL) from student_10_lines POSTHOOK: type: QUERY +POSTHOOK: Input: default@student_10_lines +POSTHOOK: Output: default@insert_a_better Explain PLAN VECTORIZATION: enabled: true @@ -603,6 +615,8 @@ insert overwrite table insert_b_adaptor IF(LENGTH(name)> 10, NULL, 2 * gpa) from student_10_lines PREHOOK: type: QUERY +PREHOOK: Input: default@student_10_lines +PREHOOK: Output: default@insert_b_adaptor POSTHOOK: query: explain vectorization detail insert overwrite table insert_b_adaptor select @@ -617,6 +631,8 @@ insert overwrite table insert_b_adaptor IF(LENGTH(name)> 10, NULL, 2 * gpa) from student_10_lines POSTHOOK: type: QUERY +POSTHOOK: Input: default@student_10_lines +POSTHOOK: Output: default@insert_b_adaptor Explain PLAN VECTORIZATION: enabled: true @@ -759,6 +775,8 @@ insert overwrite table insert_b_good IF(LENGTH(name)> 10, NULL, 2 * gpa) from student_10_lines PREHOOK: type: QUERY +PREHOOK: Input: default@student_10_lines +PREHOOK: Output: default@insert_b_good POSTHOOK: query: explain vectorization detail insert overwrite table insert_b_good select @@ -773,6 +791,8 @@ insert overwrite table insert_b_good IF(LENGTH(name)> 10, NULL, 2 * gpa) from student_10_lines POSTHOOK: type: QUERY +POSTHOOK: Input: default@student_10_lines +POSTHOOK: Output: default@insert_b_good Explain PLAN VECTORIZATION: enabled: true @@ -935,6 +955,8 @@ insert overwrite table insert_b_better IF(LENGTH(name)> 10, NULL, 2 * gpa) from student_10_lines PREHOOK: type: QUERY +PREHOOK: Input: default@student_10_lines +PREHOOK: Output: default@insert_b_better POSTHOOK: query: explain vectorization detail insert overwrite table insert_b_better select @@ -949,6 +971,8 @@ insert overwrite table insert_b_better IF(LENGTH(name)> 10, NULL, 2 * gpa) from student_10_lines POSTHOOK: type: QUERY +POSTHOOK: Input: default@student_10_lines +POSTHOOK: Output: default@insert_b_better Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_udf_character_length.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf_character_length.q.out b/ql/src/test/results/clientpositive/llap/vector_udf_character_length.q.out index c32861f..5e6cee9 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf_character_length.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf_character_length.q.out @@ -40,8 +40,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@dest1_n59 PREHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n59 SELECT character_length(src1.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest1_n59 POSTHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n59 SELECT character_length(src1.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest1_n59 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -178,8 +182,12 @@ POSTHOOK: Output: default@dest2_n13 POSTHOOK: Lineage: dest2_n13.name SIMPLE [(dest1_n59)dest1_n59.FieldSchema(name:name, type:string, comment:null), ] PREHOOK: query: EXPLAIN SELECT character_length(dest2_n13.name) FROM dest2_n13 PREHOOK: type: QUERY +PREHOOK: Input: default@dest2_n13 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT character_length(dest2_n13.name) FROM dest2_n13 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dest2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -226,8 +234,12 @@ POSTHOOK: Input: default@dest2_n13 NULL PREHOOK: query: EXPLAIN SELECT char_length(dest2_n13.name) FROM dest2_n13 PREHOOK: type: QUERY +PREHOOK: Input: default@dest2_n13 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT char_length(dest2_n13.name) FROM dest2_n13 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dest2_n13 +#### 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/vector_udf_inline.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf_inline.q.out b/ql/src/test/results/clientpositive/llap/vector_udf_inline.q.out index 67e8c91..8f702c1 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf_inline.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf_inline.q.out @@ -12,6 +12,8 @@ SELECT inline( ) ) as (id, text) FROM SRC limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression SELECT inline( ARRAY( @@ -21,6 +23,8 @@ SELECT inline( ) ) as (id, text) FROM SRC limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### 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/vector_udf_octet_length.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf_octet_length.q.out b/ql/src/test/results/clientpositive/llap/vector_udf_octet_length.q.out index fb998fa..b7fca05 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf_octet_length.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf_octet_length.q.out @@ -23,8 +23,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@dest1_n51 PREHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n51 SELECT octet_length(src1.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest1_n51 POSTHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n51 SELECT octet_length(src1.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest1_n51 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -161,8 +165,12 @@ POSTHOOK: Output: default@dest2_n10 POSTHOOK: Lineage: dest2_n10.name SIMPLE [(dest1_n51)dest1_n51.FieldSchema(name:name, type:string, comment:null), ] PREHOOK: query: EXPLAIN SELECT octet_length(dest2_n10.name) FROM dest2_n10 PREHOOK: type: QUERY +PREHOOK: Input: default@dest2_n10 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT octet_length(dest2_n10.name) FROM dest2_n10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dest2_n10 +#### 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/vector_udf_string_to_boolean.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_udf_string_to_boolean.q.out b/ql/src/test/results/clientpositive/llap/vector_udf_string_to_boolean.q.out index 7f57286..74bfc61 100644 --- a/ql/src/test/results/clientpositive/llap/vector_udf_string_to_boolean.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_udf_string_to_boolean.q.out @@ -116,8 +116,12 @@ POSTHOOK: Output: default@t_n17 POSTHOOK: Lineage: t_n17.s SCRIPT [] PREHOOK: query: explain select s,cast(s as boolean) from t_n17 order by s PREHOOK: type: QUERY +PREHOOK: Input: default@t_n17 +#### A masked pattern was here #### POSTHOOK: query: explain select s,cast(s as boolean) from t_n17 order by s POSTHOOK: type: QUERY +POSTHOOK: Input: default@t_n17 +#### 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/vector_varchar_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_varchar_4.q.out b/ql/src/test/results/clientpositive/llap/vector_varchar_4.q.out index 6d9057c..fc0846a 100644 --- a/ql/src/test/results/clientpositive/llap/vector_varchar_4.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_varchar_4.q.out @@ -124,9 +124,13 @@ POSTHOOK: Output: default@varchar_lazy_binary_columnar PREHOOK: query: explain vectorization expression insert overwrite table varchar_lazy_binary_columnar select t, si, i, b, f, d, s from vectortab2korc_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n1 +PREHOOK: Output: default@varchar_lazy_binary_columnar POSTHOOK: query: explain vectorization expression insert overwrite table varchar_lazy_binary_columnar select t, si, i, b, f, d, s from vectortab2korc_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_n1 +POSTHOOK: Output: default@varchar_lazy_binary_columnar 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/vector_varchar_mapjoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out b/ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out index 90a0869..b70e1e7 100644 --- a/ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out @@ -126,8 +126,12 @@ POSTHOOK: Lineage: varchar_join1_str_orc.c1 SIMPLE [(varchar_join1_str)varchar_j POSTHOOK: Lineage: varchar_join1_str_orc.c2 SIMPLE [(varchar_join1_str)varchar_join1_str.FieldSchema(name:c2, type:string, comment:null), ] PREHOOK: query: explain vectorization select * from varchar_join1_vc1_orc a join varchar_join1_vc1_orc b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_join1_vc1_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select * from varchar_join1_vc1_orc a join varchar_join1_vc1_orc b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_join1_vc1_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -252,8 +256,14 @@ POSTHOOK: Input: default@varchar_join1_vc1_orc 3 abc 3 abc PREHOOK: query: explain vectorization select * from varchar_join1_vc1_orc a join varchar_join1_vc2_orc b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_join1_vc1_orc +PREHOOK: Input: default@varchar_join1_vc2_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select * from varchar_join1_vc1_orc a join varchar_join1_vc2_orc b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_join1_vc1_orc +POSTHOOK: Input: default@varchar_join1_vc2_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -380,8 +390,14 @@ POSTHOOK: Input: default@varchar_join1_vc2_orc 3 abc 3 abc PREHOOK: query: explain vectorization select * from varchar_join1_vc1_orc a join varchar_join1_str_orc b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_join1_str_orc +PREHOOK: Input: default@varchar_join1_vc1_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select * from varchar_join1_vc1_orc a join varchar_join1_str_orc b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_join1_str_orc +POSTHOOK: Input: default@varchar_join1_vc1_orc +#### A masked pattern was here #### 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/vector_varchar_simple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_varchar_simple.q.out b/ql/src/test/results/clientpositive/llap/vector_varchar_simple.q.out index 149d20a..f23bfa9 100644 --- a/ql/src/test/results/clientpositive/llap/vector_varchar_simple.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_varchar_simple.q.out @@ -50,11 +50,15 @@ from varchar_2_n0 order by key asc limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select key, value from varchar_2_n0 order by key asc limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_2_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -170,11 +174,15 @@ from varchar_2_n0 order by key desc limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select key, value from varchar_2_n0 order by key desc limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_2_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -289,9 +297,13 @@ POSTHOOK: Output: default@varchar_3 PREHOOK: query: explain vectorization expression insert into table varchar_3 select cint from alltypesorc limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: default@varchar_3 POSTHOOK: query: explain vectorization expression insert into table varchar_3 select cint from alltypesorc limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: default@varchar_3 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/vector_when_case_null.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_when_case_null.q.out b/ql/src/test/results/clientpositive/llap/vector_when_case_null.q.out index 7a50163..6932744 100644 --- a/ql/src/test/results/clientpositive/llap/vector_when_case_null.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_when_case_null.q.out @@ -19,9 +19,13 @@ POSTHOOK: Lineage: count_case_groupby_n0.key SCRIPT [] PREHOOK: query: explain vectorization expression SELECT key, COUNT(CASE WHEN bool THEN 1 WHEN NOT bool THEN 0 ELSE NULL END) AS cnt_bool0_ok FROM count_case_groupby_n0 GROUP BY key PREHOOK: type: QUERY +PREHOOK: Input: default@count_case_groupby_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression SELECT key, COUNT(CASE WHEN bool THEN 1 WHEN NOT bool THEN 0 ELSE NULL END) AS cnt_bool0_ok FROM count_case_groupby_n0 GROUP BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@count_case_groupby_n0 +#### A masked pattern was here #### 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/vector_windowing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing.q.out index ebc437e..91ab000 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing.q.out @@ -5,6 +5,8 @@ dense_rank() over(distribute by p_mfgr sort by p_name) as dr, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -12,6 +14,8 @@ dense_rank() over(distribute by p_mfgr sort by p_name) as dr, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -183,6 +187,8 @@ p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) from part group by p_mfgr, p_name, p_size PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, min(p_retailprice), @@ -192,6 +198,8 @@ p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) from part group by p_mfgr, p_name, p_size POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -391,6 +399,8 @@ from part group by p_mfgr, p_name, p_size having p_size > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, min(p_retailprice), rank() over(distribute by p_mfgr sort by p_name) as r, @@ -400,6 +410,8 @@ from part group by p_mfgr, p_name, p_size having p_size > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -594,11 +606,15 @@ select p_mfgr, p_name, count(p_size) over(distribute by p_mfgr sort by p_name) as cd from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, count(p_size) over(distribute by p_mfgr sort by p_name) as cd from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -784,6 +800,8 @@ p_retailprice, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_nam p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -793,6 +811,8 @@ p_retailprice, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_nam p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -983,6 +1003,8 @@ p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) from part ) sub1 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz from (select p_mfgr, p_name, @@ -994,6 +1016,8 @@ p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) from part ) sub1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1188,6 +1212,8 @@ partition by p_mfgr order by p_name ) abc join part p1 on abc.p_partkey = p1.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select abc.p_mfgr, abc.p_name, rank() over(distribute by abc.p_mfgr sort by abc.p_name) as r, @@ -1199,6 +1225,8 @@ partition by p_mfgr order by p_name ) abc join part p1 on abc.p_partkey = p1.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1481,11 +1509,15 @@ select p_mfgr, p_name, p_size, rank() over(distribute by p_mfgr sort by p_name, p_size desc) as R from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, rank() over(distribute by p_mfgr sort by p_name, p_size desc) as R from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1637,6 +1669,8 @@ dense_rank() over(distribute by p_mfgr sort by p_name) as dr, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -1644,6 +1678,8 @@ dense_rank() over(distribute by p_mfgr sort by p_name) as dr, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1813,6 +1849,8 @@ dense_rank() over(distribute by p_mfgr sort by p_name) as dr, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -1820,6 +1858,8 @@ dense_rank() over(distribute by p_mfgr sort by p_name) as dr, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1990,6 +2030,8 @@ last_value(p_size, false) over w1 as l from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, @@ -1998,6 +2040,8 @@ last_value(p_size, false) over w1 as l from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2170,6 +2214,8 @@ from part where p_mfgr = 'Manufacturer#3' window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -2180,6 +2226,8 @@ from part where p_mfgr = 'Manufacturer#3' window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2347,6 +2395,8 @@ sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, sum(p_size) over w1 as s1, @@ -2354,6 +2404,8 @@ sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2514,12 +2566,16 @@ rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distrib from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2722,6 +2778,8 @@ first_value(p_size) over w1 as fvW1 from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -2738,6 +2796,8 @@ first_value(p_size) over w1 as fvW1 from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3017,6 +3077,8 @@ first_value(p_size) over w1 as fv1 from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -3028,6 +3090,8 @@ first_value(p_size) over w1 as fv1 from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3299,6 +3363,8 @@ first_value(p_size) over w1 as fvW1 from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, count(*) over(distribute by p_mfgr sort by p_name ) as c, @@ -3307,6 +3373,8 @@ first_value(p_size) over w1 as fvW1 from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3551,6 +3619,8 @@ round(avg(p_retailprice) over w1,2) as ag from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, round(sum(p_retailprice) over w1,2) as s, @@ -3560,6 +3630,8 @@ round(avg(p_retailprice) over w1,2) as ag from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3740,6 +3812,8 @@ from part group by p_mfgr,p_name, p_size, p_retailprice window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, p_retailprice, round(sum(p_retailprice) over w1,2) as s, @@ -3750,6 +3824,8 @@ from part group by p_mfgr,p_name, p_size, p_retailprice window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3986,6 +4062,8 @@ covar_pop(p_size, p_retailprice) over w1 as covarp from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, stddev(p_retailprice) over w1 as sdev, @@ -3997,6 +4075,8 @@ covar_pop(p_size, p_retailprice) over w1 as covarp from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4185,6 +4265,8 @@ row_number() over(distribute by p_mfgr sort by p_mfgr, p_name) as rn from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, histogram_numeric(p_retailprice, 5) over w1 as hist, @@ -4193,6 +4275,8 @@ row_number() over(distribute by p_mfgr sort by p_mfgr, p_name) as rn from part window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4362,6 +4446,9 @@ round(sum(p_retailprice),2) as s from part group by p_mfgr, p_brand PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@part +PREHOOK: Output: database:default +PREHOOK: Output: default@mfgr_price_view_n2 POSTHOOK: query: explain vectorization detail create view IF NOT EXISTS mfgr_price_view_n2 as select p_mfgr, p_brand, @@ -4369,6 +4456,9 @@ round(sum(p_retailprice),2) as s from part group by p_mfgr, p_brand POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@part +POSTHOOK: Output: database:default +POSTHOOK: Output: default@mfgr_price_view_n2 Explain PLAN VECTORIZATION: enabled: true @@ -4425,6 +4515,9 @@ window w1 as (distribute by p_mfgr sort by p_mfgr ) ) sq order by p_mfgr, p_brand PREHOOK: type: QUERY +PREHOOK: Input: default@mfgr_price_view_n2 +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select * from ( @@ -4435,6 +4528,9 @@ window w1 as (distribute by p_mfgr sort by p_mfgr ) ) sq order by p_mfgr, p_brand POSTHOOK: type: QUERY +POSTHOOK: Input: default@mfgr_price_view_n2 +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4680,6 +4776,9 @@ round(sum(p_retailprice) over w1,2) as s from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row) PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@part +PREHOOK: Output: database:default +PREHOOK: Output: default@mfgr_brand_price_view_n0 POSTHOOK: query: explain vectorization detail create view IF NOT EXISTS mfgr_brand_price_view_n0 as select p_mfgr, p_brand, @@ -4687,6 +4786,9 @@ round(sum(p_retailprice) over w1,2) as s from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row) POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@part +POSTHOOK: Output: database:default +POSTHOOK: Output: default@mfgr_brand_price_view_n0 Explain PLAN VECTORIZATION: enabled: true @@ -4736,9 +4838,15 @@ p_mfgr p_brand s PREHOOK: query: explain vectorization detail select * from mfgr_brand_price_view_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@mfgr_brand_price_view_n0 +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select * from mfgr_brand_price_view_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@mfgr_brand_price_view_n0 +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4890,6 +4998,8 @@ from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p lateral view explode(arr) part_lv as lv_col window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, lv_col, p_size, sum(p_size) over w1 as s @@ -4897,6 +5007,8 @@ from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p lateral view explode(arr) part_lv as lv_col window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -5193,6 +5305,10 @@ count(p_size) over(distribute by p_mfgr sort by p_name) as ca, first_value(p_size) over w1 as fv window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Output: default@part_1_n0 +PREHOOK: Output: default@part_2_n0 +PREHOOK: Output: default@part_3_n0 POSTHOOK: query: explain vectorization detail from part INSERT OVERWRITE TABLE part_1_n0 @@ -5215,6 +5331,10 @@ count(p_size) over(distribute by p_mfgr sort by p_name) as ca, first_value(p_size) over w1 as fv window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Output: default@part_1_n0 +POSTHOOK: Output: default@part_2_n0 +POSTHOOK: Output: default@part_3_n0 Explain PLAN VECTORIZATION: enabled: true @@ -5981,6 +6101,8 @@ from part group by p_mfgr, p_name, p_size having p_size > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, min(p_retailprice) as mi, rank() over(distribute by p_mfgr sort by p_name) as r, @@ -5990,6 +6112,8 @@ from part group by p_mfgr, p_name, p_size having p_size > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6186,6 +6310,8 @@ sum(p_size) over (distribute by p_mfgr sort by p_size range between current row from part window w1 as (rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_size, sum(p_size) over (distribute by p_mfgr sort by p_size range between 10 preceding and current row) as s2, @@ -6193,6 +6319,8 @@ sum(p_size) over (distribute by p_mfgr sort by p_size range between current row from part window w1 as (rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6352,11 +6480,15 @@ select p_mfgr, p_name, p_size, sum(p_size) over (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) as s from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) as s from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6507,12 +6639,16 @@ sum(p_size) over w1 as s from part window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over w1 as s from part window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6667,6 +6803,8 @@ from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following), w2 as (partition by p_mfgr order by p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over w1 as s, @@ -6675,6 +6813,8 @@ from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following), w2 as (partition by p_mfgr order by p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6839,6 +6979,8 @@ from part window w1 as (partition by p_mfgr order by p_name range between 2 preceding and 2 following), w2 as w1 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over w1 as s1, @@ -6847,6 +6989,8 @@ from part window w1 as (partition by p_mfgr order by p_name range between 2 preceding and 2 following), w2 as w1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -7005,6 +7149,8 @@ from part window w1 as (partition by p_mfgr order by p_name range between 2 preceding and 2 following), w2 as (w1 rows between unbounded preceding and current row) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over w1 as s1, @@ -7013,6 +7159,8 @@ from part window w1 as (partition by p_mfgr order by p_name range between 2 preceding and 2 following), w2 as (w1 rows between unbounded preceding and current row) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -7179,6 +7327,8 @@ window w1 as (distribute by p_mfgr sort by p_name range between 2 preceding and w2 as w3, w3 as (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over w1 as s1, @@ -7189,6 +7339,8 @@ window w1 as (distribute by p_mfgr sort by p_name range between 2 preceding and w2 as w3, w3 as (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -7359,6 +7511,8 @@ window w1 as (distribute by p_mfgr sort by p_name range between 2 preceding and w2 as w3, w3 as (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, sum(p_size) over w1 as s1, @@ -7369,6 +7523,8 @@ window w1 as (distribute by p_mfgr sort by p_name range between 2 preceding and w2 as w3, w3 as (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -7541,12 +7697,16 @@ sum(p_size) over w1 as s from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select DISTINCT p_mfgr, p_name, p_size, sum(p_size) over w1 as s from part window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -7740,11 +7900,15 @@ select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name ) as r from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name ) as r from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -7931,6 +8095,8 @@ round(avg(p_retailprice) over (distribute by p_mfgr),2) as s4, count(p_retailprice) over (cluster by p_mfgr ) as s5 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, round(sum(p_retailprice) over (partition by p_mfgr order by p_mfgr),2) as s1, @@ -7940,6 +8106,8 @@ round(avg(p_retailprice) over (distribute by p_mfgr),2) as s4, count(p_retailprice) over (cluster by p_mfgr ) as s5 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -8227,6 +8395,8 @@ min(p_retailprice) over (distribute by p_mfgr, p_name sort by p_mfgr, p_name row max(p_retailprice) over (partition by p_mfgr, p_name order by p_name) as s3 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (partition by p_mfgr, p_name order by p_mfgr, p_name rows between unbounded preceding and current row),2) as s1, @@ -8234,6 +8404,8 @@ min(p_retailprice) over (distribute by p_mfgr, p_name sort by p_mfgr, p_name row max(p_retailprice) over (partition by p_mfgr, p_name order by p_name) as s3 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -8469,11 +8641,15 @@ select p_mfgr, p_type, substr(p_type, 2) as short_ptype, rank() over (partition by p_mfgr order by substr(p_type, 2)) as r from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_type, substr(p_type, 2) as short_ptype, rank() over (partition by p_mfgr order by substr(p_type, 2)) as r from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -8658,11 +8834,15 @@ select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows unbounded preceding),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows unbounded preceding),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -8812,11 +8992,15 @@ select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_size range unbounded preceding),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_size range unbounded preceding),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -8999,11 +9183,15 @@ select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between current row and unbounded following),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between current row and unbounded following),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -9153,11 +9341,15 @@ select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_size range between current row and unbounded following),2) as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_size, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_size range between current row and unbounded following),2) as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -9308,12 +9500,16 @@ round(avg(p_retailprice) over(),2) from part order by p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_name, p_retailprice, round(avg(p_retailprice) over(),2) from part order by p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -9535,12 +9731,16 @@ select p_mfgr, from part where p_mfgr = 'Manufacturer#6' PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, sum(p_size) over (partition by p_mfgr order by p_size rows between unbounded preceding and current row) from part where p_mfgr = 'Manufacturer#6' POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -9674,12 +9874,16 @@ round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between from part where p_mfgr='Manufacturer#1' PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_retailprice, round(avg(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following),2), round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following),2) from part where p_mfgr='Manufacturer#1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -9824,10 +10028,14 @@ PREHOOK: query: explain vectorization detail select sum(p_size) over (partition by p_mfgr ) from part where p_mfgr = 'm1' PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select sum(p_size) over (partition by p_mfgr ) from part where p_mfgr = 'm1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out index 234b0a4..5ce66d4 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out @@ -51,6 +51,8 @@ max(p_retailprice) over w1 - min(p_retailprice) over w1 = last_value(p_retailpri from part window w1 as (distribute by p_mfgr sort by p_retailprice) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, p_size, round(sum(p_retailprice) over w1 , 2) = round(sum(lag(p_retailprice,1,0.0)) over w1 + last_value(p_retailprice) over w1 , 2), @@ -58,6 +60,8 @@ max(p_retailprice) over w1 - min(p_retailprice) over w1 = last_value(p_retailpri from part window w1 as (distribute by p_mfgr sort by p_retailprice) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -244,6 +248,8 @@ sum(p_retailprice) over (distribute by p_mfgr sort by p_retailprice rows between sum(p_retailprice) over (distribute by p_mfgr sort by p_retailprice rows between unbounded preceding and current row) -5 as s1 from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, p_size, rank() over (distribute by p_mfgr sort by p_retailprice) as r, @@ -251,6 +257,8 @@ sum(p_retailprice) over (distribute by p_mfgr sort by p_retailprice rows between sum(p_retailprice) over (distribute by p_mfgr sort by p_retailprice rows between unbounded preceding and current row) -5 as s1 from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -409,9 +417,13 @@ Manufacturer#5 1789.69 31 5 7672.66 7667.66 PREHOOK: query: explain vectorization detail select s, si, f, si - lead(f, 3) over (partition by t order by bo,s,si,f desc) from over10k_n3 limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, si, f, si - lead(f, 3) over (partition by t order by bo,s,si,f desc) from over10k_n3 limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -632,9 +644,13 @@ fred young 303 49.32 221.51001 PREHOOK: query: explain vectorization detail select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) from over10k_n3 limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) from over10k_n3 limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -855,9 +871,13 @@ yuri johnson 65734 -27 PREHOOK: query: explain vectorization detail select s, si, d, si - lag(d, 3) over (partition by b order by si,s,d) from over10k_n3 limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, si, d, si - lag(d, 3) over (partition by b order by si,s,d) from over10k_n3 limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1078,9 +1098,13 @@ gabriella zipper 279 30.41 229.2 PREHOOK: query: explain vectorization detail select s, lag(s, 3, 'fred') over (partition by f order by b) from over10k_n3 limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, lag(s, 3, 'fred') over (partition by f order by b) from over10k_n3 limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1302,9 +1326,13 @@ yuri white fred PREHOOK: query: explain vectorization detail select p_mfgr, avg(p_retailprice) over(partition by p_mfgr, p_type order by p_mfgr) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, avg(p_retailprice) over(partition by p_mfgr, p_type order by p_mfgr) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1479,9 +1507,13 @@ Manufacturer#5 1611.66 PREHOOK: query: explain vectorization detail select p_mfgr, avg(p_retailprice) over(partition by p_mfgr order by p_type,p_mfgr rows between unbounded preceding and current row) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, avg(p_retailprice) over(partition by p_mfgr order by p_type,p_mfgr rows between unbounded preceding and current row) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1641,9 +1673,15 @@ POSTHOOK: Output: default@t2_n15 PREHOOK: query: explain vectorization detail from (select sum(i) over (partition by ts order by i), s from over10k_n3) tt insert overwrite table t1_n23 select * insert overwrite table t2_n15 select * PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n3 +PREHOOK: Output: default@t1_n23 +PREHOOK: Output: default@t2_n15 POSTHOOK: query: explain vectorization detail from (select sum(i) over (partition by ts order by i), s from over10k_n3) tt insert overwrite table t1_n23 select * insert overwrite table t2_n15 select * POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n3 +POSTHOOK: Output: default@t1_n23 +POSTHOOK: Output: default@t2_n15 Explain PLAN VECTORIZATION: enabled: true @@ -1884,6 +1922,8 @@ from part window w1 as (distribute by p_mfgr sort by p_retailprice) limit 11 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, p_size, round(sum(p_retailprice) over w1 , 2) + 50.0 = round(sum(lag(p_retailprice,1,50.0)) over w1 + (last_value(p_retailprice) over w1),2) @@ -1891,6 +1931,8 @@ from part window w1 as (distribute by p_mfgr sort by p_retailprice) limit 11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_windowing_gby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_gby.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_gby.q.out index c978dae..7c83c4d 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_gby.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_gby.q.out @@ -4,12 +4,18 @@ PREHOOK: query: explain vectorization detail from cbo_t3 ws join alltypesorc wr on ws.value = wr.cstring1 group by ws.c_boolean ) in_web PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select rank() over (order by return_ratio) as return_rank from (select sum(wr.cint)/sum(ws.c_int) as return_ratio from cbo_t3 ws join alltypesorc wr on ws.value = wr.cstring1 group by ws.c_boolean ) in_web POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_windowing_gby2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_gby2.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_gby2.q.out index 8bc8b4a..cf95419 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_gby2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_gby2.q.out @@ -3,11 +3,15 @@ select rank() over (order by sum(ws.c_int)) as return_rank from cbo_t3 ws group by ws.key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select rank() over (order by sum(ws.c_int)) as return_rank from cbo_t3 ws group by ws.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -244,11 +248,15 @@ select avg(cast(ws.key as int)) over (partition by min(ws.value) order by sum(ws from cbo_t3 ws group by cast(ws.key as int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select avg(cast(ws.key as int)) over (partition by min(ws.value) order by sum(ws.c_int)) as return_rank from cbo_t3 ws group by cast(ws.key as int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -476,6 +484,8 @@ percent_rank () over(partition by max(c_int) order by sum((c_float/c_int) - c_in from cbo_t3 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select rank () over(partition by key order by sum(c_int - c_float) desc) , dense_rank () over(partition by lower(value) order by sum(c_float/c_int) asc), @@ -483,6 +493,8 @@ percent_rank () over(partition by max(c_int) order by sum((c_float/c_int) - c_in from cbo_t3 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -845,11 +857,17 @@ select rank() over (order by sum(wr.cint)/sum(ws.c_int)) as return_rank from cbo_t3 ws join alltypesorc wr on ws.value = wr.cstring1 group by ws.c_boolean PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select rank() over (order by sum(wr.cint)/sum(ws.c_int)) as return_rank from cbo_t3 ws join alltypesorc wr on ws.value = wr.cstring1 group by ws.c_boolean POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out index 5cebdf9..3f0dc77 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out @@ -47,9 +47,13 @@ POSTHOOK: Output: default@over10k_n6 PREHOOK: query: explain vectorization detail select s, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k_n6 PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k_n6 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -10209,6 +10213,8 @@ sum(b) over (partition by s order by ts desc) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, rank() over (partition by s order by `dec` desc), @@ -10216,6 +10222,8 @@ sum(b) over (partition by s order by ts desc) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -10490,9 +10498,13 @@ tom allen 14 81604381169 PREHOOK: query: explain vectorization detail select s, sum(i) over (partition by s), sum(f) over (partition by si) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, sum(i) over (partition by s), sum(f) over (partition by si) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -10755,10 +10767,14 @@ PREHOOK: query: explain vectorization detail select s, rank() over (partition by s order by bo), rank() over (partition by si order by bin desc) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, rank() over (partition by s order by bo), rank() over (partition by si order by bin desc) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -11028,9 +11044,13 @@ tom allen 7 2 PREHOOK: query: explain vectorization detail select s, sum(f) over (partition by i), row_number() over (order by f) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, sum(f) over (partition by i), row_number() over (order by f) from over10k_n6 where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -11301,6 +11321,8 @@ window w1 as (partition by s order by `dec`), w2 as (partition by si order by f) PREHOOK: type: QUERY +PREHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select s, rank() over w1, rank() over w2 @@ -11310,6 +11332,8 @@ window w1 as (partition by s order by `dec`), w2 as (partition by si order by f) POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k_n6 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true