http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_6.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_6.q.out index 1a35803..ef2d74c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_6.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_6.q.out @@ -109,9 +109,13 @@ POSTHOOK: Lineage: decimal_6_2.value SIMPLE [(decimal_6_2_txt)decimal_6_2_txt.Fi PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_6_1 ORDER BY key, value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_6_1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_6_1 ORDER BY key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_6_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -249,9 +253,13 @@ NULL 1234567890 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_6_2 ORDER BY key, value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_6_2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_6_2 ORDER BY key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_6_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -393,6 +401,9 @@ SELECT T.key from ( SELECT key, value from DECIMAL_6_2 ) T order by T.key PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_6_1 +PREHOOK: Input: default@decimal_6_2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT T.key from ( SELECT key, value from DECIMAL_6_1 @@ -400,6 +411,9 @@ SELECT T.key from ( SELECT key, value from DECIMAL_6_2 ) T order by T.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_6_1 +POSTHOOK: Input: default@decimal_6_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -622,9 +636,15 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL CREATE TABLE DECIMAL_6_3 STORED AS ORC AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@decimal_6_1 +PREHOOK: Output: database:default +PREHOOK: Output: default@DECIMAL_6_3 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL CREATE TABLE DECIMAL_6_3 STORED AS ORC AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@decimal_6_1 +POSTHOOK: Output: database:default +POSTHOOK: Output: default@DECIMAL_6_3 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_aggregate.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_aggregate.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_aggregate.q.out index ef94587..6704cc3 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_aggregate.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_aggregate.q.out @@ -40,6 +40,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_vgby +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cint, COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), @@ -48,6 +50,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_vgby +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -219,6 +223,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_vgby +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cint, COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1), @@ -227,6 +233,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_vgby +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -434,6 +442,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_vgby_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cint, COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), @@ -442,6 +452,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_vgby_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -632,6 +644,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_vgby_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cint, COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1), @@ -640,6 +654,8 @@ SELECT cint, GROUP BY cint HAVING COUNT(*) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_vgby_small +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_cast.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_cast.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_cast.q.out index 98665b9..9c21718 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_cast.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_cast.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypesorc WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypesorc WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -123,9 +127,13 @@ POSTHOOK: Lineage: alltypes_small.ctinyint SIMPLE [(alltypesorc)alltypesorc.Fiel PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypes_small WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypes_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypes_small WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypes_small +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_expressions.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_expressions.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_expressions.q.out index 9ffde7d..499337e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_expressions.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_expressions.q.out @@ -33,11 +33,15 @@ SELECT cdecimal1 + cdecimal2 as c1, cdecimal1 - (2*cdecimal2) as c2, ((cdecimal1 ORDER BY c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14 LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_test_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cdecimal1 + cdecimal2 as c1, cdecimal1 - (2*cdecimal2) as c2, ((cdecimal1+2.34)/cdecimal2) as c3, (cdecimal1 * (cdecimal2/3.4)) as c4, cdecimal1 % 10 as c5, CAST(cdecimal1 AS INT) as c6, CAST(cdecimal2 AS SMALLINT) as c7, CAST(cdecimal2 AS TINYINT) as c8, CAST(cdecimal1 AS BIGINT) as c9, CAST (cdecimal1 AS BOOLEAN) as c10, CAST(cdecimal2 AS DOUBLE) as c11, CAST(cdecimal1 AS FLOAT) as c12, CAST(cdecimal2 AS STRING) as c13, CAST(cdecimal1 AS TIMESTAMP) as c14 FROM decimal_test_n1 WHERE cdecimal1 > 0 AND cdecimal1 < 12345.5678 AND cdecimal2 != 0 AND cdecimal2 > 1000 AND cdouble IS NOT NULL ORDER BY c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14 LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_test_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -206,11 +210,15 @@ SELECT cdecimal1 + cdecimal2 as c1, cdecimal1 - (2*cdecimal2) as c2, ((cdecimal1 ORDER BY c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14 LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_test_small_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT cdecimal1 + cdecimal2 as c1, cdecimal1 - (2*cdecimal2) as c2, ((cdecimal1+2.34)/cdecimal2) as c3, (cdecimal1 * (cdecimal2/3.4)) as c4, cdecimal1 % 10 as c5, CAST(cdecimal1 AS INT) as c6, CAST(cdecimal2 AS SMALLINT) as c7, CAST(cdecimal2 AS TINYINT) as c8, CAST(cdecimal1 AS BIGINT) as c9, CAST (cdecimal1 AS BOOLEAN) as c10, CAST(cdecimal2 AS DOUBLE) as c11, CAST(cdecimal1 AS FLOAT) as c12, CAST(cdecimal2 AS STRING) as c13, CAST(cdecimal1 AS TIMESTAMP) as c14 FROM decimal_test_small_n0 WHERE cdecimal1 > 0 AND cdecimal1 < 12345.5678 AND cdecimal2 != 0 AND cdecimal2 > 1000 AND cdouble IS NOT NULL ORDER BY c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14 LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_test_small_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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out index aaab592..4236887 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out @@ -77,9 +77,15 @@ POSTHOOK: Lineage: t2_n29.value_dec EXPRESSION [(over1k_n2)over1k_n2.FieldSchema PREHOOK: query: explain vectorization detail select t1_n48.`dec`, t2_n29.`dec` from t1_n48 join t2_n29 on (t1_n48.`dec`=t2_n29.`dec`) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n48 +PREHOOK: Input: default@t2_n29 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1_n48.`dec`, t2_n29.`dec` from t1_n48 join t2_n29 on (t1_n48.`dec`=t2_n29.`dec`) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n48 +POSTHOOK: Input: default@t2_n29 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -353,9 +359,15 @@ POSTHOOK: Input: default@t2_n29 PREHOOK: query: explain vectorization detail select t1_n48.`dec`, t1_n48.value_dec, t2_n29.`dec`, t2_n29.value_dec from t1_n48 join t2_n29 on (t1_n48.`dec`=t2_n29.`dec`) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n48 +PREHOOK: Input: default@t2_n29 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1_n48.`dec`, t1_n48.value_dec, t2_n29.`dec`, t2_n29.value_dec from t1_n48 join t2_n29 on (t1_n48.`dec`=t2_n29.`dec`) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n48 +POSTHOOK: Input: default@t2_n29 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -707,9 +719,15 @@ POSTHOOK: Lineage: t2_small.value_dec EXPRESSION [(over1k_small)over1k_small.Fie PREHOOK: query: explain vectorization detail select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_small +PREHOOK: Input: default@t2_small +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_small +POSTHOOK: Input: default@t2_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -983,9 +1001,15 @@ POSTHOOK: Input: default@t2_small PREHOOK: query: explain vectorization detail select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_small +PREHOOK: Input: default@t2_small +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_small +POSTHOOK: Input: default@t2_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1261,9 +1285,15 @@ POSTHOOK: Input: default@t2_small PREHOOK: query: explain vectorization detail select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_small +PREHOOK: Input: default@t2_small +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_small +POSTHOOK: Input: default@t2_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1539,9 +1569,15 @@ POSTHOOK: Input: default@t2_small PREHOOK: query: explain vectorization detail select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_small +PREHOOK: Input: default@t2_small +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_small +POSTHOOK: Input: default@t2_small +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out index 29a68f7..359f9e7 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out @@ -61,6 +61,8 @@ where cbigint % 500 = 0 and sin(cdecimal1) >= -1.0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_test_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cdecimal1 @@ -98,6 +100,8 @@ where cbigint % 500 = 0 and sin(cdecimal1) >= -1.0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_test_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -308,6 +312,8 @@ where cbigint % 500 = 0 and sin(cdecimal1) >= -1.0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_test_small +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cdecimal1 @@ -345,6 +351,8 @@ where cbigint % 500 = 0 and sin(cdecimal1) >= -1.0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_test_small +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_precision.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_precision.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_precision.q.out index 5827587..ca61dfc 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_precision.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_precision.q.out @@ -551,8 +551,12 @@ NULL NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT avg(`dec`), sum(`dec`) FROM DECIMAL_PRECISION PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_precision +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT avg(`dec`), sum(`dec`) FROM DECIMAL_PRECISION POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_precision +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1169,8 +1173,12 @@ NULL NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT avg(`dec`), sum(`dec`) FROM DECIMAL_PRECISION_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_precision_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT avg(`dec`), sum(`dec`) FROM DECIMAL_PRECISION_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_precision_txt_small +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_round.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_round.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_round.q.out index 4f6a2cc..a0413d6 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_round.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_round.q.out @@ -33,9 +33,13 @@ POSTHOOK: Input: default@decimal_tbl_txt PREHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_txt order by `dec` PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_txt +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_txt order by `dec` POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_txt +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -150,9 +154,13 @@ POSTHOOK: Input: default@decimal_tbl_txt PREHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_txt order by round(`dec`, -1) PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_txt +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_txt order by round(`dec`, -1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_txt +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -295,9 +303,13 @@ POSTHOOK: Input: default@decimal_tbl_rc PREHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_rc order by `dec` PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_rc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_rc order by `dec` POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_rc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -412,9 +424,13 @@ POSTHOOK: Input: default@decimal_tbl_rc PREHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_rc order by round(`dec`, -1) PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_rc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_rc order by round(`dec`, -1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_rc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -557,9 +573,13 @@ POSTHOOK: Input: default@decimal_tbl_orc PREHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_orc order by `dec` PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_orc order by `dec` POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -674,9 +694,13 @@ POSTHOOK: Input: default@decimal_tbl_orc PREHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_orc order by round(`dec`, -1) PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select `dec`, round(`dec`, -1) from decimal_tbl_orc order by round(`dec`, -1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_round_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_round_2.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_round_2.q.out index ac9afeb..cd19185 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_round_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_round_2.q.out @@ -33,6 +33,8 @@ SELECT round(`dec`, -5), round(`dec`, -6), round(`dec`, -7), round(`dec`, -8) FROM decimal_tbl_1_orc ORDER BY d PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_1_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT round(`dec`) as d, round(`dec`, 0), round(`dec`, 1), round(`dec`, 2), round(`dec`, 3), @@ -40,6 +42,8 @@ SELECT round(`dec`, -5), round(`dec`, -6), round(`dec`, -7), round(`dec`, -8) FROM decimal_tbl_1_orc ORDER BY d POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_1_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -198,6 +202,8 @@ SELECT round(neg, -1), round(neg, -2), round(neg, -3), round(neg, -4) FROM decimal_tbl_2_orc ORDER BY p PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_2_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT round(pos) as p, round(pos, 0), @@ -208,6 +214,8 @@ SELECT round(neg, -1), round(neg, -2), round(neg, -3), round(neg, -4) FROM decimal_tbl_2_orc ORDER BY p POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_2_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -382,6 +390,8 @@ SELECT round(`dec`, 15), round(`dec`, 16) FROM decimal_tbl_3_orc ORDER BY d PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_3_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT round(`dec`, -15) as d, round(`dec`, -16), @@ -403,6 +413,8 @@ SELECT round(`dec`, 15), round(`dec`, 16) FROM decimal_tbl_3_orc ORDER BY d POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_3_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -583,10 +595,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT round(pos, 9) as p, round(neg, 9), round(1809242.3151111344BD, 9), round(-1809242.3151111344BD, 9) FROM decimal_tbl_4_orc ORDER BY p PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_tbl_4_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT round(pos, 9) as p, round(neg, 9), round(1809242.3151111344BD, 9), round(-1809242.3151111344BD, 9) FROM decimal_tbl_4_orc ORDER BY p POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_tbl_4_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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_trailing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_trailing.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_trailing.q.out index 44b3ff7..280dc5c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_trailing.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_trailing.q.out @@ -68,9 +68,13 @@ POSTHOOK: Lineage: decimal_trailing.id SIMPLE [(decimal_trailing_txt)decimal_tra PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_TRAILING ORDER BY id PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_trailing +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_TRAILING ORDER BY id POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_trailing +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_udf.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_udf.q.out index 859aeba..7762e1e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_udf.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_udf.q.out @@ -61,9 +61,13 @@ POSTHOOK: Lineage: decimal_udf_n0.value EXPRESSION [] PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + key FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + key FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -178,9 +182,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + value FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + value FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -295,9 +303,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + (value/2) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + (value/2) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -412,9 +424,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + '1.0' FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + '1.0' FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -529,9 +545,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - key FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - key FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -646,9 +666,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - value FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - value FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -763,9 +787,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - (value/2) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - (value/2) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -880,9 +908,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - '1.0' FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - '1.0' FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -997,9 +1029,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * key FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * key FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1114,9 +1150,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value FROM DECIMAL_UDF_n0 where key * value > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value FROM DECIMAL_UDF_n0 where key * value > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1222,9 +1262,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * value FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * value FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1339,9 +1383,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * (value/2) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * (value/2) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1456,9 +1504,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * '2.0' FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * '2.0' FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1573,9 +1625,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / 0 FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / 0 FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1690,9 +1746,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / key FROM DECIMAL_UDF_n0 WHERE key is not null and key <> 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / key FROM DECIMAL_UDF_n0 WHERE key is not null and key <> 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1810,9 +1870,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / value FROM DECIMAL_UDF_n0 WHERE value is not null and value <> 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / value FROM DECIMAL_UDF_n0 WHERE value is not null and value <> 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1920,9 +1984,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / (value/2) FROM DECIMAL_UDF_n0 WHERE value is not null and value <> 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / (value/2) FROM DECIMAL_UDF_n0 WHERE value is not null and value <> 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2030,9 +2098,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT 1 + (key / '2.0') FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT 1 + (key / '2.0') FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2147,9 +2219,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT abs(key) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT abs(key) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2264,9 +2340,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DECIMAL_UDF_n0 GROUP BY value ORDER BY value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DECIMAL_UDF_n0 GROUP BY value ORDER BY value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2463,9 +2543,13 @@ NULL NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT -key FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT -key FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2580,9 +2664,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT +key FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT +key FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2651,8 +2739,12 @@ NULL NULL PREHOOK: query: EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2737,9 +2829,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT FLOOR(key) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT FLOOR(key) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2854,9 +2950,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ROUND(key, 2) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ROUND(key, 2) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2971,9 +3071,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT POWER(key, 2) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT POWER(key, 2) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3088,9 +3192,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3205,9 +3313,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF_n0 GROUP BY value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF_n0 GROUP BY value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3369,9 +3481,13 @@ NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev_samp(key), var_samp(key) FROM DECIMAL_UDF_n0 GROUP BY value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev_samp(key), var_samp(key) FROM DECIMAL_UDF_n0 GROUP BY value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3533,9 +3649,13 @@ NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT histogram_numeric(key, 3) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT histogram_numeric(key, 3) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3617,9 +3737,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MIN(key) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MIN(key) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3747,9 +3871,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MAX(key) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MAX(key) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3877,9 +4005,13 @@ POSTHOOK: Input: default@decimal_udf_n0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT COUNT(key) FROM DECIMAL_UDF_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT COUNT(key) FROM DECIMAL_UDF_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4039,9 +4171,13 @@ POSTHOOK: Lineage: decimal_udf_txt_small.value EXPRESSION [] PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + key FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + key FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4156,9 +4292,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + value FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + value FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4273,9 +4413,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + (value/2) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + (value/2) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4390,9 +4534,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + '1.0' FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key + '1.0' FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4507,9 +4655,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - key FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - key FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4624,9 +4776,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - value FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - value FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4741,9 +4897,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - (value/2) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - (value/2) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4858,9 +5018,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - '1.0' FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key - '1.0' FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4975,9 +5139,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * key FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * key FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5092,9 +5260,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value FROM DECIMAL_UDF_txt_small where key * value > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value FROM DECIMAL_UDF_txt_small where key * value > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5200,9 +5372,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * value FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * value FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5317,9 +5493,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * (value/2) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * (value/2) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5434,9 +5614,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * '2.0' FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key * '2.0' FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5551,9 +5735,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / 0 FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / 0 FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5668,9 +5856,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / key FROM DECIMAL_UDF_txt_small WHERE key is not null and key <> 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / key FROM DECIMAL_UDF_txt_small WHERE key is not null and key <> 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5788,9 +5980,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / value FROM DECIMAL_UDF_txt_small WHERE value is not null and value <> 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / value FROM DECIMAL_UDF_txt_small WHERE value is not null and value <> 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -5898,9 +6094,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / (value/2) FROM DECIMAL_UDF_txt_small WHERE value is not null and value <> 0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key / (value/2) FROM DECIMAL_UDF_txt_small WHERE value is not null and value <> 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6008,9 +6208,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT 1 + (key / '2.0') FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT 1 + (key / '2.0') FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6125,9 +6329,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT abs(key) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT abs(key) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6242,9 +6450,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DECIMAL_UDF_txt_small GROUP BY value ORDER BY value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DECIMAL_UDF_txt_small GROUP BY value ORDER BY value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6441,9 +6653,13 @@ NULL NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT -key FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT -key FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6558,9 +6774,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT +key FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT +key FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6629,8 +6849,12 @@ NULL NULL PREHOOK: query: EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6715,9 +6939,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT FLOOR(key) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT FLOOR(key) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6832,9 +7060,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ROUND(key, 2) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ROUND(key, 2) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -6949,9 +7181,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT POWER(key, 2) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT POWER(key, 2) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7066,9 +7302,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7183,9 +7423,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF_txt_small GROUP BY value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF_txt_small GROUP BY value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7347,9 +7591,13 @@ NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev_samp(key), var_samp(key) FROM DECIMAL_UDF_txt_small GROUP BY value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT value, stddev_samp(key), var_samp(key) FROM DECIMAL_UDF_txt_small GROUP BY value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7511,9 +7759,13 @@ NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT histogram_numeric(key, 3) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT histogram_numeric(key, 3) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7595,9 +7847,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MIN(key) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MIN(key) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7725,9 +7981,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MAX(key) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT MAX(key) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -7855,9 +8115,13 @@ POSTHOOK: Input: default@decimal_udf_txt_small PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT COUNT(key) FROM DECIMAL_UDF_txt_small PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf_txt_small +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT COUNT(key) FROM DECIMAL_UDF_txt_small POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf_txt_small +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_decimal_udf2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_udf2.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_udf2.q.out index eece295..7c1fe9e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_udf2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_udf2.q.out @@ -62,10 +62,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT acos(key), asin(key), atan(key), cos(key), sin(key), tan(key), radians(key) FROM DECIMAL_UDF2_n0 WHERE key = 10 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT acos(key), asin(key), atan(key), cos(key), sin(key), tan(key), radians(key) FROM DECIMAL_UDF2_n0 WHERE key = 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf2_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -169,6 +173,8 @@ SELECT log10(key), sqrt(key) FROM DECIMAL_UDF2_n0 WHERE key = 10 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT exp(key), ln(key), @@ -176,6 +182,8 @@ SELECT log10(key), sqrt(key) FROM DECIMAL_UDF2_n0 WHERE key = 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf2_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -288,10 +296,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT acos(key), asin(key), atan(key), cos(key), sin(key), tan(key), radians(key) FROM DECIMAL_UDF2_txt WHERE key = 10 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf2_txt +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT acos(key), asin(key), atan(key), cos(key), sin(key), tan(key), radians(key) FROM DECIMAL_UDF2_txt WHERE key = 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf2_txt +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -395,6 +407,8 @@ SELECT log10(key), sqrt(key) FROM DECIMAL_UDF2_txt WHERE key = 10 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_udf2_txt +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT exp(key), ln(key), @@ -402,6 +416,8 @@ SELECT log10(key), sqrt(key) FROM DECIMAL_UDF2_txt WHERE key = 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_udf2_txt +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_distinct_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_distinct_2.q.out b/ql/src/test/results/clientpositive/llap/vector_distinct_2.q.out index 6037324..e72e398 100644 --- a/ql/src/test/results/clientpositive/llap/vector_distinct_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_distinct_2.q.out @@ -104,9 +104,13 @@ POSTHOOK: Lineage: vectortab2korc_n3.ts2 SIMPLE [(vectortab2k_n3)vectortab2k_n3. PREHOOK: query: explain vectorization expression select distinct s, t from vectortab2korc_n3 PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select distinct s, t from vectortab2korc_n3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_n3 +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_elt.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_elt.q.out b/ql/src/test/results/clientpositive/llap/vector_elt.q.out index 48972e2..7f92815 100644 --- a/ql/src/test/results/clientpositive/llap/vector_elt.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_elt.q.out @@ -2,10 +2,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT (ctinyint % 2) + 1, cstr FROM alltypesorc WHERE ctinyint > 0 LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT (ctinyint % 2) + 1, cstring1, cint, elt((ctinyint % 2) + 1, cstring1, cint) FROM alltypesorc WHERE ctinyint > 0 LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -112,6 +116,8 @@ SELECT elt(2, 'abc', 'defg'), elt(3, 'abc', 'defg') FROM alltypesorc LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT elt(2, 'abc', 'defg'), elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'), @@ -125,6 +131,8 @@ SELECT elt(2, 'abc', 'defg'), elt(3, 'abc', 'defg') FROM alltypesorc LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### 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/163caed7/ql/src/test/results/clientpositive/llap/vector_full_outer_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_full_outer_join.q.out b/ql/src/test/results/clientpositive/llap/vector_full_outer_join.q.out index 6ddcef6..c53249c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_full_outer_join.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_full_outer_join.q.out @@ -81,9 +81,15 @@ tjoin2stage.rnum tjoin2stage.c1 tjoin2stage.c2 PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: false @@ -180,9 +186,15 @@ NULL NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: false @@ -279,9 +291,15 @@ NULL NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -437,9 +455,15 @@ NULL NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -595,9 +619,15 @@ NULL NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -753,9 +783,15 @@ NULL NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c1 as c1j2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -911,9 +947,15 @@ NULL NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1073,9 +1115,15 @@ NULL NULL NULL EE PREHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 full outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_fast.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_fast.q.out b/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_fast.q.out index 169d94c..2e0d2ad 100644 --- a/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_fast.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_fast.q.out @@ -192,10 +192,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1a +PREHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1a +POSTHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -442,10 +448,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1a +PREHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1a +POSTHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1016,10 +1028,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_timestamp FROM fullouter_long_big_1b b FULL OUTER JOIN fullouter_long_small_1b s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1b +PREHOOK: Input: default@fullouter_long_small_1b +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_timestamp FROM fullouter_long_big_1b b FULL OUTER JOIN fullouter_long_small_1b s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1b +POSTHOOK: Input: default@fullouter_long_small_1b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1386,10 +1404,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, b.b_string, s.key, s.s_decimal FROM fullouter_long_big_1c b FULL OUTER JOIN fullouter_long_small_1c s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1c +PREHOOK: Input: default@fullouter_long_small_1c +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, b.b_string, s.key, s.s_decimal FROM fullouter_long_big_1c b FULL OUTER JOIN fullouter_long_small_1c s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1c +POSTHOOK: Input: default@fullouter_long_small_1c +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1767,10 +1791,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key FROM fullouter_long_big_1d b FULL OUTER JOIN fullouter_long_small_1d s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1d +PREHOOK: Input: default@fullouter_long_small_1d +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key FROM fullouter_long_big_1d b FULL OUTER JOIN fullouter_long_small_1d s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1d +POSTHOOK: Input: default@fullouter_long_small_1d +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2221,10 +2251,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, s.key0, s.key1 FROM fullouter_multikey_big_1a b FULL OUTER JOIN fullouter_multikey_small_1a s ON b.key0 = s.key0 AND b.key1 = s.key1 order by b.key0, b.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_multikey_big_1a +PREHOOK: Input: default@fullouter_multikey_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, s.key0, s.key1 FROM fullouter_multikey_big_1a b FULL OUTER JOIN fullouter_multikey_small_1a s ON b.key0 = s.key0 AND b.key1 = s.key1 order by b.key0, b.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_multikey_big_1a +POSTHOOK: Input: default@fullouter_multikey_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2970,10 +3006,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, b.key2, s.key0, s.key1, s.key2, s.s_decimal FROM fullouter_multikey_big_1b b FULL OUTER JOIN fullouter_multikey_small_1b s ON b.key0 = s.key0 AND b.key1 = s.key1 AND b.key2 = s.key2 order by b.key0, b.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_multikey_big_1b +PREHOOK: Input: default@fullouter_multikey_small_1b +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, b.key2, s.key0, s.key1, s.key2, s.s_decimal FROM fullouter_multikey_big_1b b FULL OUTER JOIN fullouter_multikey_small_1b s ON b.key0 = s.key0 AND b.key1 = s.key1 AND b.key2 = s.key2 order by b.key0, b.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_multikey_big_1b +POSTHOOK: Input: default@fullouter_multikey_small_1b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3509,10 +3551,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date, s.s_timestamp FROM fullouter_string_big_1a b FULL OUTER JOIN fullouter_string_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_string_big_1a +PREHOOK: Input: default@fullouter_string_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date, s.s_timestamp FROM fullouter_string_big_1a b FULL OUTER JOIN fullouter_string_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_string_big_1a +POSTHOOK: Input: default@fullouter_string_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
