http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 4506cd7..90d1507 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] @@ -250,9 +254,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] @@ -395,6 +403,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 @@ -402,6 +413,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] @@ -626,9 +640,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/b356aae0/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 30a6770..85d0445 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/b356aae0/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 1c3f4b6..5bee194 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] @@ -122,9 +126,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/b356aae0/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 125cd72..4f14a29 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/b356aae0/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 06dd32a..1a43f45 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] @@ -352,9 +358,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] @@ -704,9 +716,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] @@ -979,9 +997,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] @@ -1255,9 +1279,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] @@ -1532,9 +1562,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/b356aae0/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 e3d5044..091a9d6 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] @@ -307,6 +311,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 @@ -344,6 +350,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/b356aae0/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 e9e9290..cbb536f 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] @@ -1170,8 +1174,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/b356aae0/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 0791fca..0391a8b 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/b356aae0/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 4010997..a9ef5be 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/b356aae0/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 450d78d..b75fadd 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/b356aae0/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 54cf861..d8f8823 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] @@ -1221,9 +1261,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] @@ -1338,9 +1382,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] @@ -1455,9 +1503,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] @@ -1572,9 +1624,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] @@ -1689,9 +1745,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] @@ -1808,9 +1868,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] @@ -1917,9 +1981,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] @@ -2026,9 +2094,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] @@ -2143,9 +2215,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] @@ -2260,9 +2336,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] @@ -2459,9 +2539,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] @@ -2576,9 +2660,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] @@ -2647,8 +2735,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 @@ -2733,9 +2825,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] @@ -2850,9 +2946,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] @@ -2967,9 +3067,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] @@ -3084,9 +3188,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] @@ -3201,9 +3309,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] @@ -3365,9 +3477,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] @@ -3529,9 +3645,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] @@ -3613,9 +3733,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] @@ -3744,9 +3868,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] @@ -3875,9 +4003,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] @@ -4038,9 +4170,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] @@ -4155,9 +4291,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] @@ -4272,9 +4412,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] @@ -4389,9 +4533,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] @@ -4506,9 +4654,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] @@ -4623,9 +4775,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] @@ -4740,9 +4896,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] @@ -4857,9 +5017,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] @@ -4974,9 +5138,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] @@ -5091,9 +5259,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] @@ -5198,9 +5370,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] @@ -5315,9 +5491,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] @@ -5432,9 +5612,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] @@ -5549,9 +5733,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] @@ -5666,9 +5854,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] @@ -5785,9 +5977,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] @@ -5894,9 +6090,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] @@ -6003,9 +6203,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] @@ -6120,9 +6324,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] @@ -6237,9 +6445,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] @@ -6436,9 +6648,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] @@ -6553,9 +6769,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] @@ -6624,8 +6844,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 @@ -6710,9 +6934,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] @@ -6827,9 +7055,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] @@ -6944,9 +7176,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] @@ -7061,9 +7297,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] @@ -7178,9 +7418,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] @@ -7342,9 +7586,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] @@ -7506,9 +7754,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] @@ -7590,9 +7842,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] @@ -7721,9 +7977,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] @@ -7852,9 +8112,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/b356aae0/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 4c9b737..3cbf3ae 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] @@ -168,6 +172,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), @@ -175,6 +181,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] @@ -286,10 +294,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] @@ -392,6 +404,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), @@ -399,6 +413,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/b356aae0/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 747b74a..d9e9a4d 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/b356aae0/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 5745af2..dd021a8 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] @@ -111,6 +115,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'), @@ -124,6 +130,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/b356aae0/ql/src/test/results/clientpositive/llap/vector_groupby4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby4.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby4.q.out index 6912d7b..24df11f 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby4.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby4.q.out @@ -22,10 +22,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION FROM srcorc_n1 INSERT OVERWRITE TABLE dest1_n154 SELECT substr(srcorc_n1.key,1,1) GROUP BY substr(srcorc_n1.key,1,1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcorc_n1 +PREHOOK: Output: default@dest1_n154 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION FROM srcorc_n1 INSERT OVERWRITE TABLE dest1_n154 SELECT substr(srcorc_n1.key,1,1) GROUP BY substr(srcorc_n1.key,1,1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcorc_n1 +POSTHOOK: Output: default@dest1_n154 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_groupby6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby6.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby6.q.out index d3c6548..88f8036 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby6.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby6.q.out @@ -22,10 +22,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION FROM srcorc_n0 INSERT OVERWRITE TABLE dest1_n73 SELECT DISTINCT substr(srcorc_n0.value,5,1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcorc_n0 +PREHOOK: Output: default@dest1_n73 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION FROM srcorc_n0 INSERT OVERWRITE TABLE dest1_n73 SELECT DISTINCT substr(srcorc_n0.value,5,1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcorc_n0 +POSTHOOK: Output: default@dest1_n73 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_groupby_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_3.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_3.q.out index a118b2e..a662dc2 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_3.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_3.q.out @@ -104,9 +104,13 @@ POSTHOOK: Lineage: vectortab2korc_n8.ts2 SIMPLE [(vectortab2k_n9)vectortab2k_n9. PREHOOK: query: explain vectorization expression select s, t, max(b) from vectortab2korc_n8 group by s, t PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n8 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select s, t, max(b) from vectortab2korc_n8 group by s, t POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_n8 +#### 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_groupby_cube1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_cube1.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_cube1.q.out index 5c0d6bb..4d8a0d8 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_cube1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_cube1.q.out @@ -17,9 +17,13 @@ POSTHOOK: Output: default@t1_n90 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n90 GROUP BY key, val with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n90 GROUP BY key, val with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -154,9 +158,13 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n90 GROUP BY CUBE(key, val) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n90 GROUP BY CUBE(key, val) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -317,9 +325,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID, count(1) FROM T1_n90 GROUP BY key, val with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID, count(1) FROM T1_n90 GROUP BY key, val with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -479,9 +491,13 @@ NULL NULL 3 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n90 GROUP BY key with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n90 GROUP BY key with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -576,9 +592,13 @@ NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n90 GROUP BY key, val with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n90 GROUP BY key, val with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -784,9 +804,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n90 GROUP BY key with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n90 GROUP BY key with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -920,11 +944,17 @@ FROM T1_n90 INSERT OVERWRITE TABLE T2_n55 SELECT key, val, count(1) group by key, val with cube INSERT OVERWRITE TABLE T3_n19 SELECT key, val, sum(1) group by key, val with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n90 +PREHOOK: Output: default@t2_n55 +PREHOOK: Output: default@t3_n19 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL FROM T1_n90 INSERT OVERWRITE TABLE T2_n55 SELECT key, val, count(1) group by key, val with cube INSERT OVERWRITE TABLE T3_n19 SELECT key, val, sum(1) group by key, val with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n90 +POSTHOOK: Output: default@t2_n55 +POSTHOOK: Output: default@t3_n19 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_groupby_grouping_id1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id1.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id1.q.out index 1ffa0fd..c3a6c56 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id1.q.out @@ -30,9 +30,13 @@ t1_text.key t1_text.val PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID from T1_n17 group by key, val with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID from T1_n17 group by key, val with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n17 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -189,9 +193,13 @@ NULL NULL 3 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID from T1_n17 group by cube(key, val) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID from T1_n17 group by cube(key, val) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n17 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -348,9 +356,13 @@ NULL NULL 3 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, key, val from T1_n17 group by key, val with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, key, val from T1_n17 group by key, val with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n17 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -501,9 +513,13 @@ grouping__id key val PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, key, val from T1_n17 group by rollup (key, val) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, key, val from T1_n17 group by rollup (key, val) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n17 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -654,9 +670,13 @@ grouping__id key val PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID, CASE WHEN GROUPING__ID == 0 THEN "0" WHEN GROUPING__ID == 1 THEN "1" WHEN GROUPING__ID == 2 THEN "2" WHEN GROUPING__ID == 3 THEN "3" ELSE "nothing" END from T1_n17 group by key, val with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID, CASE WHEN GROUPING__ID == 0 THEN "0" WHEN GROUPING__ID == 1 THEN "1" WHEN GROUPING__ID == 2 THEN "2" WHEN GROUPING__ID == 3 THEN "3" ELSE "nothing" END from T1_n17 group by key, val with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n17 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -814,9 +834,13 @@ NULL NULL 3 3 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID, CASE WHEN GROUPING__ID == 0 THEN "0" WHEN GROUPING__ID == 1 THEN "1" WHEN GROUPING__ID == 2 THEN "2" WHEN GROUPING__ID == 3 THEN "3" ELSE "nothing" END from T1_n17 group by cube(key, val) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, GROUPING__ID, CASE WHEN GROUPING__ID == 0 THEN "0" WHEN GROUPING__ID == 1 THEN "1" WHEN GROUPING__ID == 2 THEN "2" WHEN GROUPING__ID == 3 THEN "3" ELSE "nothing" END from T1_n17 group by cube(key, val) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n17 +#### 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_groupby_grouping_id2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id2.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id2.q.out index dce2930..9bc9102 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id2.q.out @@ -30,9 +30,13 @@ t1_text_n4.key t1_text_n4.value PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH ROLLUP PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH ROLLUP POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -232,9 +236,13 @@ NULL NULL 3 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY ROLLUP (key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY ROLLUP (key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -439,6 +447,8 @@ SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH R ) t GROUP BY GROUPING__ID PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, count(*) FROM @@ -447,6 +457,8 @@ SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH R ) t GROUP BY GROUPING__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -746,6 +758,8 @@ SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY ROLLUP(key, value ) t GROUP BY GROUPING__ID PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, count(*) FROM @@ -754,6 +768,8 @@ SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY ROLLUP(key, value ) t GROUP BY GROUPING__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1051,12 +1067,16 @@ JOIN (SELECT GROUPING__ID FROM T1_n73 GROUP BY key, value WITH ROLLUP) t2 ON t1.GROUPING__ID = t2.GROUPING__ID PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT t1.GROUPING__ID, t2.GROUPING__ID FROM (SELECT GROUPING__ID FROM T1_n73 GROUP BY key,value WITH ROLLUP) t1 JOIN (SELECT GROUPING__ID FROM T1_n73 GROUP BY key, value WITH ROLLUP) t2 ON t1.GROUPING__ID = t2.GROUPING__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1379,12 +1399,16 @@ JOIN (SELECT GROUPING__ID FROM T1_n73 GROUP BY ROLLUP(key, value)) t2 ON t1.GROUPING__ID = t2.GROUPING__ID PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT t1.GROUPING__ID, t2.GROUPING__ID FROM (SELECT GROUPING__ID FROM T1_n73 GROUP BY ROLLUP(key,value)) t1 JOIN (SELECT GROUPING__ID FROM T1_n73 GROUP BY ROLLUP(key, value)) t2 ON t1.GROUPING__ID = t2.GROUPING__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1704,9 +1728,13 @@ t1.grouping__id t2.grouping__id PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH ROLLUP PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH ROLLUP POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1866,6 +1894,8 @@ SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH R ) t GROUP BY GROUPING__ID PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT GROUPING__ID, count(*) FROM @@ -1874,6 +1904,8 @@ SELECT key, value, GROUPING__ID, count(*) from T1_n73 GROUP BY key, value WITH R ) t GROUP BY GROUPING__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2085,12 +2117,16 @@ JOIN (SELECT GROUPING__ID FROM T1_n73 GROUP BY key, value WITH ROLLUP) t2 ON t1.GROUPING__ID = t2.GROUPING__ID PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n73 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT t1.GROUPING__ID, t2.GROUPING__ID FROM (SELECT GROUPING__ID FROM T1_n73 GROUP BY key,value WITH ROLLUP) t1 JOIN (SELECT GROUPING__ID FROM T1_n73 GROUP BY key, value WITH ROLLUP) t2 ON t1.GROUPING__ID = t2.GROUPING__ID POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n73 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true
