http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_between_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_between_in.q.out b/ql/src/test/results/clientpositive/llap/vector_between_in.q.out index a2a765b..e9ea461 100644 --- a/ql/src/test/results/clientpositive/llap/vector_between_in.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_between_in.q.out @@ -26,8 +26,12 @@ POSTHOOK: Lineage: decimal_date_test.cdecimal2 EXPRESSION [] POSTHOOK: Lineage: decimal_date_test.cdouble EXPRESSION [] PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdate FROM decimal_date_test WHERE cdate IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE)) ORDER BY cdate PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdate FROM decimal_date_test WHERE cdate IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE)) ORDER BY cdate POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -122,8 +126,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COUNT(*) FROM decimal_date_test WHERE cdate NOT IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE), CAST("1970-01-21" AS DATE)) PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COUNT(*) FROM decimal_date_test WHERE cdate NOT IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE), CAST("1970-01-21" AS DATE)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -232,8 +240,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdecimal1 FROM decimal_date_test WHERE cdecimal1 IN (2365.8945945946, 881.0135135135, -3367.6517567568) ORDER BY cdecimal1 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdecimal1 FROM decimal_date_test WHERE cdecimal1 IN (2365.8945945946, 881.0135135135, -3367.6517567568) ORDER BY cdecimal1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -328,8 +340,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT IN (2365.8945945946, 881.0135135135, -3367.6517567568) PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT IN (2365.8945945946, 881.0135135135, -3367.6517567568) POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -438,8 +454,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdate FROM decimal_date_test WHERE cdate BETWEEN CAST("1969-12-30" AS DATE) AND CAST("1970-01-02" AS DATE) ORDER BY cdate PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdate FROM decimal_date_test WHERE cdate BETWEEN CAST("1969-12-30" AS DATE) AND CAST("1970-01-02" AS DATE) ORDER BY cdate POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -534,8 +554,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdate FROM decimal_date_test WHERE cdate NOT BETWEEN CAST("1968-05-01" AS DATE) AND CAST("1971-09-01" AS DATE) ORDER BY cdate PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdate FROM decimal_date_test WHERE cdate NOT BETWEEN CAST("1968-05-01" AS DATE) AND CAST("1971-09-01" AS DATE) ORDER BY cdate POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -630,8 +654,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdecimal1 FROM decimal_date_test WHERE cdecimal1 BETWEEN -20 AND 45.9918918919 ORDER BY cdecimal1 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cdecimal1 FROM decimal_date_test WHERE cdecimal1 BETWEEN -20 AND 45.9918918919 ORDER BY cdecimal1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -726,8 +754,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1081,8 +1113,12 @@ POSTHOOK: Input: default@decimal_date_test 6172 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdate IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE)) as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdate IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE)) as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1219,8 +1255,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdecimal1 IN (2365.8945945946, 881.0135135135, -3367.6517567568) as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdecimal1 IN (2365.8945945946, 881.0135135135, -3367.6517567568) as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1357,8 +1397,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdate BETWEEN CAST("1969-12-30" AS DATE) AND CAST("1970-01-02" AS DATE) as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdate BETWEEN CAST("1969-12-30" AS DATE) AND CAST("1970-01-02" AS DATE) as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1495,8 +1539,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_date_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT c0, count(1) from (SELECT cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 as c0 FROM decimal_date_test) tab GROUP BY c0 ORDER BY c0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_date_test +#### 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_binary_join_groupby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out b/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out index cabc2b7..5a83157 100644 --- a/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out @@ -100,11 +100,15 @@ SELECT sum(hash(*)) k FROM hundredorc t1 JOIN hundredorc t2 ON t1.bin = t2.bin order by k PREHOOK: type: QUERY +PREHOOK: Input: default@hundredorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT sum(hash(*)) k FROM hundredorc t1 JOIN hundredorc t2 ON t1.bin = t2.bin order by k POSTHOOK: type: QUERY +POSTHOOK: Input: default@hundredorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -328,12 +332,16 @@ FROM hundredorc GROUP BY bin order by bin PREHOOK: type: QUERY +PREHOOK: Input: default@hundredorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT count(*), bin FROM hundredorc GROUP BY bin order by bin POSTHOOK: type: QUERY +POSTHOOK: Input: default@hundredorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -519,10 +527,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT t1.i, t1.bin, t2.bin FROM hundredorc t1 JOIN hundredorc t2 ON t1.i = t2.i PREHOOK: type: QUERY +PREHOOK: Input: default@hundredorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT t1.i, t1.bin, t2.bin FROM hundredorc t1 JOIN hundredorc t2 ON t1.i = t2.i POSTHOOK: type: QUERY +POSTHOOK: Input: default@hundredorc +#### 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_bround.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_bround.q.out b/ql/src/test/results/clientpositive/llap/vector_bround.q.out index 3e9a370..2f945d6 100644 --- a/ql/src/test/results/clientpositive/llap/vector_bround.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_bround.q.out @@ -47,9 +47,13 @@ POSTHOOK: Lineage: test_vector_bround.v1 EXPRESSION [] PREHOOK: query: explain vectorization detail select bround(v0), bround(v1, 1) from test_vector_bround PREHOOK: type: QUERY +PREHOOK: Input: default@test_vector_bround +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select bround(v0), bround(v1, 1) from test_vector_bround POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_vector_bround +#### 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_bucket.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_bucket.q.out b/ql/src/test/results/clientpositive/llap/vector_bucket.q.out index d9a0f09..277deda 100644 --- a/ql/src/test/results/clientpositive/llap/vector_bucket.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_bucket.q.out @@ -9,9 +9,13 @@ POSTHOOK: Output: default@non_orc_table PREHOOK: query: explain vectorization expression insert into table non_orc_table values(1, 'one'),(1, 'one'), (2, 'two'),(3, 'three') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@non_orc_table POSTHOOK: query: explain vectorization expression insert into table non_orc_table values(1, 'one'),(1, 'one'), (2, 'two'),(3, 'three') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@non_orc_table 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_case_when_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out b/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out index 411d693..4b8544a 100644 --- a/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out @@ -141,6 +141,8 @@ SELECT IF(L_SUPPKEY % 500 > 100, DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365)) AS Field_12 FROM lineitem_test PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT L_QUANTITY as Quantity, @@ -182,6 +184,8 @@ SELECT IF(L_SUPPKEY % 500 > 100, DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365)) AS Field_12 FROM lineitem_test POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem_test +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -454,6 +458,8 @@ SELECT IF(L_SUPPKEY % 500 > 100, DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365)) AS Field_12 FROM lineitem_test PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT L_QUANTITY as Quantity, @@ -495,6 +501,8 @@ SELECT IF(L_SUPPKEY % 500 > 100, DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365)) AS Field_12 FROM lineitem_test POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem_test +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -787,6 +795,8 @@ SELECT IF(L_SUPPKEY % 500 > 100, DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365)) AS Field_12 FROM lineitem_test PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem_test +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT L_QUANTITY as Quantity, @@ -828,6 +838,8 @@ SELECT IF(L_SUPPKEY % 500 > 100, DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365)) AS Field_12 FROM lineitem_test POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem_test +#### 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_case_when_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out b/ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out index 243e55e..c64adbf 100644 --- a/ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out @@ -82,6 +82,8 @@ SELECT FROM timestamps ORDER BY ctimestamp1, stimestamp1, ctimestamp2 PREHOOK: type: QUERY +PREHOOK: Input: default@timestamps +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ctimestamp1, @@ -114,6 +116,8 @@ SELECT FROM timestamps ORDER BY ctimestamp1, stimestamp1, ctimestamp2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@timestamps +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -344,6 +348,8 @@ SELECT FROM timestamps ORDER BY ctimestamp1, stimestamp1, ctimestamp2 PREHOOK: type: QUERY +PREHOOK: Input: default@timestamps +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ctimestamp1, @@ -376,6 +382,8 @@ SELECT FROM timestamps ORDER BY ctimestamp1, stimestamp1, ctimestamp2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@timestamps +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -629,6 +637,8 @@ SELECT FROM timestamps ORDER BY ctimestamp1, stimestamp1, ctimestamp2 PREHOOK: type: QUERY +PREHOOK: Input: default@timestamps +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ctimestamp1, @@ -661,6 +671,8 @@ SELECT FROM timestamps ORDER BY ctimestamp1, stimestamp1, ctimestamp2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@timestamps +#### 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_cast_constant.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_cast_constant.q.out b/ql/src/test/results/clientpositive/llap/vector_cast_constant.q.out index 060281a..b4c0ea5 100644 --- a/ql/src/test/results/clientpositive/llap/vector_cast_constant.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_cast_constant.q.out @@ -102,6 +102,8 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` FROM over1korc_n0 GROUP BY i ORDER BY i LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1korc_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT i, AVG(CAST(50 AS INT)) AS `avg_int_ok`, @@ -109,6 +111,8 @@ POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` FROM over1korc_n0 GROUP BY i ORDER BY i LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1korc_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_char_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_char_2.q.out b/ql/src/test/results/clientpositive/llap/vector_char_2.q.out index b58de03..1ba0ab6 100644 --- a/ql/src/test/results/clientpositive/llap/vector_char_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_char_2.q.out @@ -63,12 +63,16 @@ group by value order by value asc limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@char_2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select value, sum(cast(key as int)), count(*) numrows from char_2_n0 group by value order by value asc limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_2_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -268,12 +272,16 @@ group by value order by value desc limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@char_2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select value, sum(cast(key as int)), count(*) numrows from char_2_n0 group by value order by value desc limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_2_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_char_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_char_4.q.out b/ql/src/test/results/clientpositive/llap/vector_char_4.q.out index a418e7a..fa77121 100644 --- a/ql/src/test/results/clientpositive/llap/vector_char_4.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_char_4.q.out @@ -124,9 +124,13 @@ POSTHOOK: Output: default@char_lazy_binary_columnar PREHOOK: query: explain vectorization expression insert overwrite table char_lazy_binary_columnar select t, si, i, b, f, d, s from vectortab2korc PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc +PREHOOK: Output: default@char_lazy_binary_columnar POSTHOOK: query: explain vectorization expression insert overwrite table char_lazy_binary_columnar select t, si, i, b, f, d, s from vectortab2korc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc +POSTHOOK: Output: default@char_lazy_binary_columnar 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_char_mapjoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out b/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out index c92eddf..6cbf417 100644 --- a/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out @@ -126,8 +126,12 @@ POSTHOOK: Lineage: char_join1_str_orc.c1 SIMPLE [(char_join1_str)char_join1_str. POSTHOOK: Lineage: char_join1_str_orc.c2 SIMPLE [(char_join1_str)char_join1_str.FieldSchema(name:c2, type:string, comment:null), ] PREHOOK: query: explain vectorization expression select * from char_join1_vc1_orc a join char_join1_vc1_orc b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY +PREHOOK: Input: default@char_join1_vc1_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from char_join1_vc1_orc a join char_join1_vc1_orc b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_join1_vc1_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -296,8 +300,14 @@ POSTHOOK: Input: default@char_join1_vc1_orc 3 abc 3 abc PREHOOK: query: explain vectorization expression select * from char_join1_vc1_orc a join char_join1_vc2_orc b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY +PREHOOK: Input: default@char_join1_vc1_orc +PREHOOK: Input: default@char_join1_vc2_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from char_join1_vc1_orc a join char_join1_vc2_orc b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_join1_vc1_orc +POSTHOOK: Input: default@char_join1_vc2_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -468,8 +478,14 @@ POSTHOOK: Input: default@char_join1_vc2_orc 3 abc 3 abc PREHOOK: query: explain vectorization expression select * from char_join1_vc1_orc a join char_join1_str_orc b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY +PREHOOK: Input: default@char_join1_str_orc +PREHOOK: Input: default@char_join1_vc1_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from char_join1_vc1_orc a join char_join1_str_orc b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_join1_str_orc +POSTHOOK: Input: default@char_join1_vc1_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_char_simple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_char_simple.q.out b/ql/src/test/results/clientpositive/llap/vector_char_simple.q.out index c283674..0370315 100644 --- a/ql/src/test/results/clientpositive/llap/vector_char_simple.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_char_simple.q.out @@ -50,11 +50,15 @@ from char_2 order by key asc limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@char_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization only select key, value from char_2 order by key asc limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -136,11 +140,15 @@ from char_2 order by key desc limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@char_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization only select key, value from char_2 order by key desc limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -221,9 +229,13 @@ POSTHOOK: Output: default@char_3 PREHOOK: query: explain vectorization only operator insert into table char_3 select cint from alltypesorc limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: default@char_3 POSTHOOK: query: explain vectorization only operator insert into table char_3 select cint from alltypesorc limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: default@char_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_char_varchar_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_char_varchar_1.q.out b/ql/src/test/results/clientpositive/llap/vector_char_varchar_1.q.out index 5a23539..d2db6db 100644 --- a/ql/src/test/results/clientpositive/llap/vector_char_varchar_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_char_varchar_1.q.out @@ -29,9 +29,15 @@ POSTHOOK: Output: default@varchar_table PREHOOK: query: explain vectorization detail create table varchar_ctas_1 as select length(vs),reverse(vs) from varchar_table PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@varchar_table +PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_ctas_1 POSTHOOK: query: explain vectorization detail create table varchar_ctas_1 as select length(vs),reverse(vs) from varchar_table POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@varchar_table +POSTHOOK: Output: database:default +POSTHOOK: Output: default@varchar_ctas_1 Explain PLAN VECTORIZATION: enabled: true @@ -176,9 +182,15 @@ POSTHOOK: Output: default@char_table PREHOOK: query: explain vectorization detail create table char_ctas_1 as select length(vs),reverse(vs) from char_table PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@char_table +PREHOOK: Output: database:default +PREHOOK: Output: default@char_ctas_1 POSTHOOK: query: explain vectorization detail create table char_ctas_1 as select length(vs),reverse(vs) from char_table POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@char_table +POSTHOOK: Output: database:default +POSTHOOK: Output: default@char_ctas_1 Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_coalesce.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_coalesce.q.out b/ql/src/test/results/clientpositive/llap/vector_coalesce.q.out index a65603b..2cdaaf8 100644 --- a/ql/src/test/results/clientpositive/llap/vector_coalesce.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_coalesce.q.out @@ -4,12 +4,16 @@ WHERE (cdouble IS NULL) ORDER BY cdouble, cstring1, cint, cfloat, csmallint, c LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT cdouble, cstring1, cint, cfloat, csmallint, coalesce(cdouble, cstring1, cint, cfloat, csmallint) as c FROM alltypesorc WHERE (cdouble IS NULL) ORDER BY cdouble, cstring1, cint, cfloat, csmallint, c 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,12 +116,16 @@ WHERE (ctinyint IS NULL) ORDER BY ctinyint, cdouble, cint, c LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT ctinyint, cdouble, cint, coalesce(ctinyint+10, (cdouble+log2(cint)), 0) as c FROM alltypesorc WHERE (ctinyint IS NULL) ORDER BY ctinyint, cdouble, cint, c 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] @@ -220,12 +228,16 @@ WHERE (cfloat IS NULL AND cbigint IS NULL) ORDER BY cfloat, cbigint, c LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT cfloat, cbigint, coalesce(cfloat, cbigint, 0) as c FROM alltypesorc WHERE (cfloat IS NULL AND cbigint IS NULL) ORDER BY cfloat, cbigint, c 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] @@ -304,12 +316,16 @@ WHERE ctimestamp1 IS NOT NULL OR ctimestamp2 IS NOT NULL ORDER BY ctimestamp1, ctimestamp2, c LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT ctimestamp1, ctimestamp2, coalesce(ctimestamp1, ctimestamp2) as c FROM alltypesorc WHERE ctimestamp1 IS NOT NULL OR ctimestamp2 IS NOT NULL ORDER BY ctimestamp1, ctimestamp2, c 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] @@ -407,12 +423,16 @@ WHERE (cfloat IS NULL AND cbigint IS NULL) ORDER BY cfloat, cbigint, c LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT cfloat, cbigint, coalesce(cfloat, cbigint) as c FROM alltypesorc WHERE (cfloat IS NULL AND cbigint IS NULL) ORDER BY cfloat, cbigint, c 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] @@ -490,11 +510,15 @@ FROM alltypesorc WHERE cbigint IS NULL LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT cbigint, ctinyint, coalesce(cbigint, ctinyint) as c FROM alltypesorc WHERE cbigint IS 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] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out b/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out index 3776f3e..ec6a786 100644 --- a/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out @@ -32,12 +32,16 @@ SELECT from str_str_orc GROUP BY str2 PREHOOK: type: QUERY +PREHOOK: Input: default@str_str_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT str2, ROUND(sum(cast(COALESCE(str1, 0) as int))/60, 2) as result from str_str_orc GROUP BY str2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@str_str_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -175,10 +179,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COALESCE(str1, 0) as result from str_str_orc PREHOOK: type: QUERY +PREHOOK: Input: default@str_str_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COALESCE(str1, 0) as result from str_str_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@str_str_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -257,12 +265,16 @@ SELECT from str_str_orc GROUP BY str2 PREHOOK: type: QUERY +PREHOOK: Input: default@str_str_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT str2, ROUND(sum(cast(COALESCE(str1, 0) as int))/60, 2) as result from str_str_orc GROUP BY str2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@str_str_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -400,10 +412,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COALESCE(str1, 0) as result from str_str_orc PREHOOK: type: QUERY +PREHOOK: Input: default@str_str_orc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COALESCE(str1, 0) as result from str_str_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@str_str_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_coalesce_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out b/ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out index 1953826..57f3892 100644 --- a/ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out @@ -56,10 +56,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT m.member, (CASE WHEN COALESCE(n.attr, 5)>1 THEN n.attr END) AS attr FROM test_2_n0 m LEFT JOIN test_1_n0 n ON m.member = n.member PREHOOK: type: QUERY +PREHOOK: Input: default@test_1_n0 +PREHOOK: Input: default@test_2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT m.member, (CASE WHEN COALESCE(n.attr, 5)>1 THEN n.attr END) AS attr FROM test_2_n0 m LEFT JOIN test_1_n0 n ON m.member = n.member POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1_n0 +POSTHOOK: Input: default@test_2_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_coalesce_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_coalesce_4.q.out b/ql/src/test/results/clientpositive/llap/vector_coalesce_4.q.out index 01b746d..185f438 100644 --- a/ql/src/test/results/clientpositive/llap/vector_coalesce_4.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_coalesce_4.q.out @@ -29,9 +29,13 @@ POSTHOOK: Lineage: coalesce_test.b EXPRESSION [] PREHOOK: query: explain vectorization detail select coalesce(a, b) from coalesce_test order by a, b PREHOOK: type: QUERY +PREHOOK: Input: default@coalesce_test +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select coalesce(a, b) from coalesce_test order by a, b POSTHOOK: type: QUERY +POSTHOOK: Input: default@coalesce_test +#### 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_complex_all.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out b/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out index b6247ef..f0f5fe7 100644 --- a/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out @@ -69,9 +69,13 @@ orc_create_staging_n0.str orc_create_staging_n0.mp orc_create_staging_n0.lst orc PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -151,9 +155,13 @@ line3 {"key31":"value31","key32":"value32","key33":"value33"} ["g","h","i"] {"a" PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT str FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT str FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -233,9 +241,13 @@ line3 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct, mp, lst FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct, mp, lst FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -315,9 +327,13 @@ strct mp lst PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT lst, str FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT lst, str FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -397,9 +413,13 @@ lst str PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT mp, str FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT mp, str FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -479,9 +499,13 @@ mp str PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct, str FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct, str FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -561,9 +585,13 @@ strct str PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct.B, str FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct.B, str FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -647,10 +675,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL INSERT INTO TABLE orc_create_complex_n0 SELECT orc_create_staging_n0.*, src1.key FROM orc_create_staging_n0 cross join src src1 cross join orc_create_staging_n0 spam1 cross join orc_create_staging_n0 spam2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_staging_n0 +PREHOOK: Input: default@src +PREHOOK: Output: default@orc_create_complex_n0 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL INSERT INTO TABLE orc_create_complex_n0 SELECT orc_create_staging_n0.*, src1.key FROM orc_create_staging_n0 cross join src src1 cross join orc_create_staging_n0 spam1 cross join orc_create_staging_n0 spam2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_staging_n0 +POSTHOOK: Input: default@src +POSTHOOK: Output: default@orc_create_complex_n0 Explain PLAN VECTORIZATION: enabled: true @@ -898,9 +932,13 @@ orc_create_staging_n0.str orc_create_staging_n0.mp orc_create_staging_n0.lst orc PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(*) from orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(*) from orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1027,9 +1065,13 @@ _c0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT distinct lst, strct FROM orc_create_complex_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT distinct lst, strct FROM orc_create_complex_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1116,9 +1158,13 @@ lst strct PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT str, count(val) FROM orc_create_complex_n0 GROUP BY str PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT str, count(val) FROM orc_create_complex_n0 GROUP BY str POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1257,9 +1303,13 @@ line1 4501 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct.B, count(val) FROM orc_create_complex_n0 GROUP BY strct.B PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct.B, count(val) FROM orc_create_complex_n0 GROUP BY strct.B POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1400,9 +1450,13 @@ four 4501 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct, mp, lst, str, count(val) FROM orc_create_complex_n0 GROUP BY strct, mp, lst, str PREHOOK: type: QUERY +PREHOOK: Input: default@orc_create_complex_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct, mp, lst, str, count(val) FROM orc_create_complex_n0 GROUP BY strct, mp, lst, str POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_create_complex_n0 +#### 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_complex_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_complex_join.q.out b/ql/src/test/results/clientpositive/llap/vector_complex_join.q.out index d222460..4c05f7c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_complex_join.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_complex_join.q.out @@ -20,9 +20,15 @@ _c0 _c1 PREHOOK: query: explain vectorization expression select * from alltypesorc join test_n8 where alltypesorc.cint=test_n8.a PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@test_n8 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from alltypesorc join test_n8 where alltypesorc.cint=test_n8.a POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@test_n8 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -202,9 +208,15 @@ col1 PREHOOK: query: explain vectorization expression select * from test2b_n0 join test2a_n0 on test2b_n0.a = test2a_n0.a[1] PREHOOK: type: QUERY +PREHOOK: Input: default@test2a_n0 +PREHOOK: Input: default@test2b_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from test2b_n0 join test2a_n0 on test2b_n0.a = test2a_n0.a[1] POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2a_n0 +POSTHOOK: Input: default@test2b_n0 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -348,9 +360,15 @@ test2b_n0.a test2a_n0.a test2a_n0.index PREHOOK: query: explain vectorization expression select * from test2b_n0 join test2a_n0 on test2b_n0.a = test2a_n0.a[test2a_n0.index] PREHOOK: type: QUERY +PREHOOK: Input: default@test2a_n0 +PREHOOK: Input: default@test2b_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from test2b_n0 join test2a_n0 on test2b_n0.a = test2a_n0.a[test2a_n0.index] POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2a_n0 +POSTHOOK: Input: default@test2b_n0 +#### 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_count.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_count.q.out b/ql/src/test/results/clientpositive/llap/vector_count.q.out index 20a655b..a0f301e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_count.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_count.q.out @@ -45,8 +45,12 @@ POSTHOOK: Input: default@abcd NULL 35 23 6 PREHOOK: query: explain vectorization expression select a, count(distinct b), count(distinct c), sum(d) from abcd group by a PREHOOK: type: QUERY +PREHOOK: Input: default@abcd +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select a, count(distinct b), count(distinct c), sum(d) from abcd group by a POSTHOOK: type: QUERY +POSTHOOK: Input: default@abcd +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -134,8 +138,12 @@ POSTHOOK: Input: default@abcd NULL 1 1 6 PREHOOK: query: explain vectorization expression select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd PREHOOK: type: QUERY +PREHOOK: Input: default@abcd +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd POSTHOOK: type: QUERY +POSTHOOK: Input: default@abcd +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -222,8 +230,12 @@ POSTHOOK: Input: default@abcd 7 7 6 6 6 7 3 3 6 7 4 5 6 6 5 6 4 5 5 5 4 PREHOOK: query: explain vectorization expression select a, count(distinct b), count(distinct c), sum(d) from abcd group by a PREHOOK: type: QUERY +PREHOOK: Input: default@abcd +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select a, count(distinct b), count(distinct c), sum(d) from abcd group by a POSTHOOK: type: QUERY +POSTHOOK: Input: default@abcd +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -319,8 +331,12 @@ POSTHOOK: Input: default@abcd NULL 1 1 6 PREHOOK: query: explain vectorization expression select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd PREHOOK: type: QUERY +PREHOOK: Input: default@abcd +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd POSTHOOK: type: QUERY +POSTHOOK: Input: default@abcd +#### 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_count_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_count_distinct.q.out b/ql/src/test/results/clientpositive/llap/vector_count_distinct.q.out index dd54bd5..ca8232e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_count_distinct.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_count_distinct.q.out @@ -1228,9 +1228,73 @@ POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=9).ws_wholesale_cost SIMPL PREHOOK: query: explain vectorization expression select count(distinct ws_order_number) from web_sales PREHOOK: type: QUERY +PREHOOK: Input: default@web_sales +PREHOOK: Input: default@web_sales@ws_web_site_sk=1 +PREHOOK: Input: default@web_sales@ws_web_site_sk=10 +PREHOOK: Input: default@web_sales@ws_web_site_sk=11 +PREHOOK: Input: default@web_sales@ws_web_site_sk=12 +PREHOOK: Input: default@web_sales@ws_web_site_sk=13 +PREHOOK: Input: default@web_sales@ws_web_site_sk=14 +PREHOOK: Input: default@web_sales@ws_web_site_sk=15 +PREHOOK: Input: default@web_sales@ws_web_site_sk=16 +PREHOOK: Input: default@web_sales@ws_web_site_sk=17 +PREHOOK: Input: default@web_sales@ws_web_site_sk=18 +PREHOOK: Input: default@web_sales@ws_web_site_sk=19 +PREHOOK: Input: default@web_sales@ws_web_site_sk=2 +PREHOOK: Input: default@web_sales@ws_web_site_sk=20 +PREHOOK: Input: default@web_sales@ws_web_site_sk=21 +PREHOOK: Input: default@web_sales@ws_web_site_sk=22 +PREHOOK: Input: default@web_sales@ws_web_site_sk=23 +PREHOOK: Input: default@web_sales@ws_web_site_sk=24 +PREHOOK: Input: default@web_sales@ws_web_site_sk=25 +PREHOOK: Input: default@web_sales@ws_web_site_sk=26 +PREHOOK: Input: default@web_sales@ws_web_site_sk=27 +PREHOOK: Input: default@web_sales@ws_web_site_sk=28 +PREHOOK: Input: default@web_sales@ws_web_site_sk=29 +PREHOOK: Input: default@web_sales@ws_web_site_sk=3 +PREHOOK: Input: default@web_sales@ws_web_site_sk=30 +PREHOOK: Input: default@web_sales@ws_web_site_sk=4 +PREHOOK: Input: default@web_sales@ws_web_site_sk=5 +PREHOOK: Input: default@web_sales@ws_web_site_sk=6 +PREHOOK: Input: default@web_sales@ws_web_site_sk=7 +PREHOOK: Input: default@web_sales@ws_web_site_sk=8 +PREHOOK: Input: default@web_sales@ws_web_site_sk=9 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select count(distinct ws_order_number) from web_sales POSTHOOK: type: QUERY +POSTHOOK: Input: default@web_sales +POSTHOOK: Input: default@web_sales@ws_web_site_sk=1 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=10 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=11 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=12 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=13 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=14 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=15 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=16 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=17 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=18 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=19 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=2 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=20 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=21 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=22 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=23 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=24 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=25 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=26 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=27 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=28 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=29 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=3 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=30 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=4 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=5 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=6 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=7 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=8 +POSTHOOK: Input: default@web_sales@ws_web_site_sk=9 +#### 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_create_struct_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_create_struct_table.q.out b/ql/src/test/results/clientpositive/llap/vector_create_struct_table.q.out index f312244..4a669cf 100644 --- a/ql/src/test/results/clientpositive/llap/vector_create_struct_table.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_create_struct_table.q.out @@ -25,9 +25,13 @@ POSTHOOK: Output: default@string_fields_n0 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT strct, strct.a, strct.b, strct.c FROM string_fields_n0 LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@string_fields_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT strct, strct.a, strct.b, strct.c FROM string_fields_n0 LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@string_fields_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -136,9 +140,13 @@ POSTHOOK: Output: default@char_fields_n0 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT strct, strct.a, strct.b, strct.c FROM char_fields_n0 LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@char_fields_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT strct, strct.a, strct.b, strct.c FROM char_fields_n0 LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_fields_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -247,9 +255,13 @@ POSTHOOK: Output: default@varchar_fields_n0 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT strct, strct.a, strct.b, strct.c FROM varchar_fields_n0 LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_fields_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT strct, strct.a, strct.b, strct.c FROM varchar_fields_n0 LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_fields_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_data_types.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_data_types.q.out b/ql/src/test/results/clientpositive/llap/vector_data_types.q.out index 9bd7bc1..be1776c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_data_types.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_data_types.q.out @@ -116,8 +116,12 @@ POSTHOOK: Lineage: over1korc_n1.t EXPRESSION [] POSTHOOK: Lineage: over1korc_n1.ts EXPRESSION [] PREHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY +PREHOOK: Input: default@over1korc_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1korc_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -212,8 +216,12 @@ POSTHOOK: Input: default@over1korc_n1 -25838728092 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION select t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY +PREHOOK: Input: default@over1korc_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION select t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1korc_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -338,10 +346,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT SUM(HASH(*)) FROM (SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i) as q PREHOOK: type: QUERY +PREHOOK: Input: default@over1korc_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT SUM(HASH(*)) FROM (SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i) as q POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1korc_n1 +#### 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_date_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_date_1.q.out b/ql/src/test/results/clientpositive/llap/vector_date_1.q.out index 5d275de..e79a7b7 100644 --- a/ql/src/test/results/clientpositive/llap/vector_date_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_date_1.q.out @@ -75,6 +75,8 @@ select dt2 > dt1 from vector_date_1 order by dt1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select dt1, dt2, @@ -89,6 +91,8 @@ select dt2 > dt1 from vector_date_1 order by dt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -240,6 +244,8 @@ select dt2 < dt1 from vector_date_1 order by dt1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select dt1, dt2, @@ -254,6 +260,8 @@ select dt2 < dt1 from vector_date_1 order by dt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -405,6 +413,8 @@ select date '1970-01-01' < dt1 from vector_date_1 order by dt1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select dt1, @@ -419,6 +429,8 @@ select date '1970-01-01' < dt1 from vector_date_1 order by dt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -570,6 +582,8 @@ select date '1970-01-01' > dt1 from vector_date_1 order by dt1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select dt1, @@ -584,6 +598,8 @@ select date '1970-01-01' > dt1 from vector_date_1 order by dt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -734,6 +750,8 @@ where and dt2 >= dt1 order by dt1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select dt1, dt2 @@ -747,6 +765,8 @@ where and dt2 >= dt1 order by dt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -903,6 +923,8 @@ where and date '1970-01-01' <= dt1 order by dt1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select dt1, dt2 @@ -918,6 +940,8 @@ where and date '1970-01-01' <= dt1 order by dt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1028,9 +1052,13 @@ dt1 dt2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT dt1 FROM vector_date_1 WHERE dt1 IN (date '1970-01-01', date '2001-01-01') PREHOOK: type: QUERY +PREHOOK: Input: default@vector_date_1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT dt1 FROM vector_date_1 WHERE dt1 IN (date '1970-01-01', date '2001-01-01') POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_date_1 +#### 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_decimal_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_1.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_1.q.out index 4c81131..78aa411 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_1.q.out @@ -46,9 +46,13 @@ POSTHOOK: Lineage: decimal_1.v EXPRESSION [] PREHOOK: query: explain vectorization detail select cast(t as boolean) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as boolean) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -162,9 +166,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -278,9 +286,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -394,9 +406,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as int) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as int) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -510,9 +526,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -626,9 +646,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as float) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as float) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -742,9 +766,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as double) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as double) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -858,9 +886,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as string) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as string) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -974,9 +1006,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as timestamp) from decimal_1 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as timestamp) from decimal_1 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1 +#### 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_10_0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_10_0.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_10_0.q.out index b61ffca..9f940d3 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_10_0.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_10_0.q.out @@ -36,9 +36,13 @@ POSTHOOK: Lineage: decimal.dec SIMPLE [(decimal_txt)decimal_txt.FieldSchema(name PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT `dec` FROM `DECIMAL` order by `dec` PREHOOK: type: QUERY +PREHOOK: Input: default@decimal +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT `dec` FROM `DECIMAL` order by `dec` POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -151,9 +155,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT `dec` FROM `decimal_txt` order by `dec` PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_txt +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT `dec` FROM `decimal_txt` order by `dec` POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_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_decimal_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_2.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_2.q.out index c05f9fe..43a1aed 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_2.q.out @@ -24,9 +24,13 @@ POSTHOOK: Lineage: decimal_2.t EXPRESSION [] PREHOOK: query: explain vectorization detail select cast(t as boolean) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as boolean) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -139,9 +143,13 @@ true PREHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -254,9 +262,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -369,9 +381,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as int) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as int) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -484,9 +500,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -599,9 +619,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as float) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as float) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -714,9 +738,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as double) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as double) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -829,9 +857,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as string) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as string) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -955,9 +987,13 @@ POSTHOOK: Lineage: decimal_2.t EXPRESSION [] PREHOOK: query: explain vectorization detail select cast(t as boolean) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as boolean) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1070,9 +1106,13 @@ true PREHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1185,9 +1225,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1300,9 +1344,13 @@ NULL PREHOOK: query: explain vectorization detail select cast(t as int) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as int) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1415,9 +1463,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1530,9 +1582,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as float) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as float) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1645,9 +1701,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as double) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as double) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1760,9 +1820,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(t as string) from decimal_2 order by t PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(t as string) from decimal_2 order by t POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1875,9 +1939,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(3.14 as decimal(4,2)) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(3.14 as decimal(4,2)) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1954,9 +2022,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(cast(3.14 as float) as decimal(4,2)) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(cast(3.14 as float) as decimal(4,2)) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2033,9 +2105,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2112,9 +2188,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(true as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(true as decimal) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2182,9 +2262,13 @@ STAGE PLANS: PREHOOK: query: explain vectorization detail select cast(true as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(true as decimal) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2261,9 +2345,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(3Y as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(3Y as decimal) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2340,9 +2428,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(3S as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(3S as decimal) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2419,9 +2511,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(cast(3 as int) as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(cast(3 as int) as decimal) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2498,9 +2594,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(3L as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(3L as decimal) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2577,9 +2677,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast(0.99999999999999999999 as decimal(20,19)) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast(0.99999999999999999999 as decimal(20,19)) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2656,9 +2760,13 @@ POSTHOOK: Input: default@decimal_2 PREHOOK: query: explain vectorization detail select cast('0.99999999999999999999' as decimal(20,20)) as c from decimal_2 order by c PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select cast('0.99999999999999999999' as decimal(20,20)) as c from decimal_2 order by c POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_2 +#### 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_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_5.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_5.q.out index 585dab4..58c40cd 100644 --- a/ql/src/test/results/clientpositive/llap/vector_decimal_5.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_decimal_5.q.out @@ -131,8 +131,12 @@ POSTHOOK: Input: default@decimal_5 NULL PREHOOK: query: explain SELECT cast(key as decimal) FROM DECIMAL_5 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_5 +#### A masked pattern was here #### POSTHOOK: query: explain SELECT cast(key as decimal) FROM DECIMAL_5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1