http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized.q.out b/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized.q.out index da513db..bd56ba5 100644 --- a/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized.q.out @@ -192,10 +192,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1a +PREHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1a +POSTHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -442,10 +448,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1a +PREHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1a +POSTHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1016,10 +1028,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_timestamp FROM fullouter_long_big_1b b FULL OUTER JOIN fullouter_long_small_1b s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1b +PREHOOK: Input: default@fullouter_long_small_1b +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_timestamp FROM fullouter_long_big_1b b FULL OUTER JOIN fullouter_long_small_1b s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1b +POSTHOOK: Input: default@fullouter_long_small_1b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1386,10 +1404,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, b.b_string, s.key, s.s_decimal FROM fullouter_long_big_1c b FULL OUTER JOIN fullouter_long_small_1c s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1c +PREHOOK: Input: default@fullouter_long_small_1c +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, b.b_string, s.key, s.s_decimal FROM fullouter_long_big_1c b FULL OUTER JOIN fullouter_long_small_1c s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1c +POSTHOOK: Input: default@fullouter_long_small_1c +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1767,10 +1791,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key FROM fullouter_long_big_1d b FULL OUTER JOIN fullouter_long_small_1d s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1d +PREHOOK: Input: default@fullouter_long_small_1d +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key FROM fullouter_long_big_1d b FULL OUTER JOIN fullouter_long_small_1d s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1d +POSTHOOK: Input: default@fullouter_long_small_1d +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2221,10 +2251,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, s.key0, s.key1 FROM fullouter_multikey_big_1a b FULL OUTER JOIN fullouter_multikey_small_1a s ON b.key0 = s.key0 AND b.key1 = s.key1 order by b.key0, b.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_multikey_big_1a +PREHOOK: Input: default@fullouter_multikey_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, s.key0, s.key1 FROM fullouter_multikey_big_1a b FULL OUTER JOIN fullouter_multikey_small_1a s ON b.key0 = s.key0 AND b.key1 = s.key1 order by b.key0, b.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_multikey_big_1a +POSTHOOK: Input: default@fullouter_multikey_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2970,10 +3006,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, b.key2, s.key0, s.key1, s.key2, s.s_decimal FROM fullouter_multikey_big_1b b FULL OUTER JOIN fullouter_multikey_small_1b s ON b.key0 = s.key0 AND b.key1 = s.key1 AND b.key2 = s.key2 order by b.key0, b.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_multikey_big_1b +PREHOOK: Input: default@fullouter_multikey_small_1b +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, b.key2, s.key0, s.key1, s.key2, s.s_decimal FROM fullouter_multikey_big_1b b FULL OUTER JOIN fullouter_multikey_small_1b s ON b.key0 = s.key0 AND b.key1 = s.key1 AND b.key2 = s.key2 order by b.key0, b.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_multikey_big_1b +POSTHOOK: Input: default@fullouter_multikey_small_1b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3509,10 +3551,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date, s.s_timestamp FROM fullouter_string_big_1a b FULL OUTER JOIN fullouter_string_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_string_big_1a +PREHOOK: Input: default@fullouter_string_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date, s.s_timestamp FROM fullouter_string_big_1a b FULL OUTER JOIN fullouter_string_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_string_big_1a +POSTHOOK: Input: default@fullouter_string_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized_passthru.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized_passthru.q.out b/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized_passthru.q.out index 52ca0fb..7b3d655 100644 --- a/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized_passthru.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_fullouter_mapjoin_1_optimized_passthru.q.out @@ -192,10 +192,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1a +PREHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1a +POSTHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -442,10 +448,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1a +PREHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date FROM fullouter_long_big_1a b FULL OUTER JOIN fullouter_long_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1a +POSTHOOK: Input: default@fullouter_long_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1013,10 +1025,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_timestamp FROM fullouter_long_big_1b b FULL OUTER JOIN fullouter_long_small_1b s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1b +PREHOOK: Input: default@fullouter_long_small_1b +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_timestamp FROM fullouter_long_big_1b b FULL OUTER JOIN fullouter_long_small_1b s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1b +POSTHOOK: Input: default@fullouter_long_small_1b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1380,10 +1398,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, b.b_string, s.key, s.s_decimal FROM fullouter_long_big_1c b FULL OUTER JOIN fullouter_long_small_1c s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1c +PREHOOK: Input: default@fullouter_long_small_1c +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, b.b_string, s.key, s.s_decimal FROM fullouter_long_big_1c b FULL OUTER JOIN fullouter_long_small_1c s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1c +POSTHOOK: Input: default@fullouter_long_small_1c +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1757,10 +1781,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key FROM fullouter_long_big_1d b FULL OUTER JOIN fullouter_long_small_1d s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_long_big_1d +PREHOOK: Input: default@fullouter_long_small_1d +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key FROM fullouter_long_big_1d b FULL OUTER JOIN fullouter_long_small_1d s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_long_big_1d +POSTHOOK: Input: default@fullouter_long_small_1d +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2208,10 +2238,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, s.key0, s.key1 FROM fullouter_multikey_big_1a b FULL OUTER JOIN fullouter_multikey_small_1a s ON b.key0 = s.key0 AND b.key1 = s.key1 order by b.key0, b.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_multikey_big_1a +PREHOOK: Input: default@fullouter_multikey_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, s.key0, s.key1 FROM fullouter_multikey_big_1a b FULL OUTER JOIN fullouter_multikey_small_1a s ON b.key0 = s.key0 AND b.key1 = s.key1 order by b.key0, b.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_multikey_big_1a +POSTHOOK: Input: default@fullouter_multikey_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2954,10 +2990,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, b.key2, s.key0, s.key1, s.key2, s.s_decimal FROM fullouter_multikey_big_1b b FULL OUTER JOIN fullouter_multikey_small_1b s ON b.key0 = s.key0 AND b.key1 = s.key1 AND b.key2 = s.key2 order by b.key0, b.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_multikey_big_1b +PREHOOK: Input: default@fullouter_multikey_small_1b +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key0, b.key1, b.key2, s.key0, s.key1, s.key2, s.s_decimal FROM fullouter_multikey_big_1b b FULL OUTER JOIN fullouter_multikey_small_1b s ON b.key0 = s.key0 AND b.key1 = s.key1 AND b.key2 = s.key2 order by b.key0, b.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_multikey_big_1b +POSTHOOK: Input: default@fullouter_multikey_small_1b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3490,10 +3532,16 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date, s.s_timestamp FROM fullouter_string_big_1a b FULL OUTER JOIN fullouter_string_small_1a s ON b.key = s.key order by b.key PREHOOK: type: QUERY +PREHOOK: Input: default@fullouter_string_big_1a +PREHOOK: Input: default@fullouter_string_small_1a +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT b.key, s.key, s.s_date, s.s_timestamp FROM fullouter_string_big_1a b FULL OUTER JOIN fullouter_string_small_1a s ON b.key = s.key order by b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@fullouter_string_big_1a +POSTHOOK: Input: default@fullouter_string_small_1a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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/163caed7/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/163caed7/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 759a09d..3ea544e 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/163caed7/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 6eaf7ad..2319e11 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/163caed7/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 f018a61..c7b3659 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 @@ -188,9 +192,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 @@ -346,9 +354,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 @@ -498,9 +510,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 @@ -650,9 +666,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 @@ -809,9 +829,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/163caed7/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 ff300a0..ef10ace 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 @@ -744,6 +756,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 @@ -752,6 +766,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 @@ -1047,12 +1063,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 @@ -1373,12 +1393,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 @@ -1696,9 +1720,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 @@ -1858,6 +1886,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 @@ -1866,6 +1896,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 @@ -2076,12 +2108,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 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id3.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id3.q.out index c090051..214b865 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id3.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_id3.q.out @@ -34,6 +34,8 @@ GROUP BY key, value GROUPING SETS ((), (key)) HAVING GROUPING__ID = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n112 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) FROM T1_n112 @@ -41,6 +43,8 @@ GROUP BY key, value GROUPING SETS ((), (key)) HAVING GROUPING__ID = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n112 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -210,6 +214,8 @@ GROUP BY key, value GROUPING SETS ((), (key)) HAVING GROUPING__ID = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n112 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, value, GROUPING__ID, count(*) FROM T1_n112 @@ -217,6 +223,8 @@ GROUP BY key, value GROUPING SETS ((), (key)) HAVING GROUPING__ID = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n112 +#### 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_groupby_grouping_sets1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets1.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets1.q.out index eb5480d..6bb3c10 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets1.q.out @@ -46,9 +46,13 @@ t1_n30.a t1_n30.b t1_n30.c PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n30 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n30 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -208,9 +212,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n30 group by cube(a, b) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n30 group by cube(a, b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -370,9 +378,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n30 GROUP BY a, b GROUPING SETS (a, (a, b), b, ()) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n30 GROUP BY a, b GROUPING SETS (a, (a, b), b, ()) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -532,9 +544,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n30 GROUP BY a, b GROUPING SETS (a, (a, b)) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n30 GROUP BY a, b GROUPING SETS (a, (a, b)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -690,9 +706,13 @@ a b _c2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n30 GROUP BY a, b, c GROUPING SETS (a, b, c) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n30 GROUP BY a, b, c GROUPING SETS (a, b, c) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -845,9 +865,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n30 GROUP BY a GROUPING SETS ((a), (a)) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n30 GROUP BY a GROUPING SETS ((a), (a)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -982,9 +1006,13 @@ a PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a + b, count(*) FROM T1_n30 GROUP BY a + b GROUPING SETS (a+b) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n30 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a + b, count(*) FROM T1_n30 GROUP BY a + b GROUPING SETS (a+b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n30 +#### 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_groupby_grouping_sets2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets2.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets2.q.out index 195ea0c..7bee405 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets2.q.out @@ -31,9 +31,13 @@ t1_text_n3.a t1_text_n3.b t1_text_n3.c PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n69 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n69 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n69 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n69 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -212,9 +216,13 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n69 group by cube(a, b) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n69 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n69 group by cube(a, b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n69 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -417,9 +425,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, sum(c) from T1_n69 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n69 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, sum(c) from T1_n69 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n69 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -615,9 +627,13 @@ _col0 _col1 _col2 _col3 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, sum(c+d) from T2_n42 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t2_n42 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, sum(c+d) from T2_n42 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t2_n42 +#### 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_groupby_grouping_sets3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3.q.out index b15a993..077f6c7 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3.q.out @@ -39,9 +39,13 @@ t1_text_n7.a t1_text_n7.b t1_text_n7.c PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c), count(*) from T1_n106 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n106 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c), count(*) from T1_n106 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n106 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -148,9 +152,13 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c), count(*) from T1_n106 group by cube(a, b) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n106 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c), count(*) from T1_n106 group by cube(a, b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n106 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -282,9 +290,13 @@ NULL NULL 3.8333333333333335 12 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c), count(*) from T1_n106 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n106 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c), count(*) from T1_n106 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n106 +#### 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_groupby_grouping_sets3_dec.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3_dec.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3_dec.q.out index 2350830..50f9ad3 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3_dec.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets3_dec.q.out @@ -39,9 +39,13 @@ a b c_dec PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c_dec), count(*) from T1_n115 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n115 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c_dec), count(*) from T1_n115 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n115 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -178,9 +182,13 @@ STAGE PLANS: PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c_dec), count(*) from T1_n115 group by cube(a, b) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n115 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c_dec), count(*) from T1_n115 group by cube(a, b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n115 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -342,9 +350,13 @@ NULL NULL 3.83333333333333333333 12 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c_dec), count(*) from T1_n115 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n115 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, avg(c_dec), count(*) from T1_n115 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n115 +#### 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_groupby_grouping_sets4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets4.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets4.q.out index 31ccb5e..4b736dd 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets4.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets4.q.out @@ -35,6 +35,8 @@ join (SELECT a, b, count(*) from T1_n161 where a < 3 group by a, b with cube) subq2 on subq1.a = subq2.a PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n161 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM (SELECT a, b, count(*) from T1_n161 where a < 3 group by a, b with cube) subq1 @@ -42,6 +44,8 @@ join (SELECT a, b, count(*) from T1_n161 where a < 3 group by a, b with cube) subq2 on subq1.a = subq2.a POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n161 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -283,6 +287,8 @@ join (SELECT a, b, count(*) from T1_n161 where a < 3 group by cube(a, b) ) subq2 on subq1.a = subq2.a PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n161 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM (SELECT a, b, count(*) from T1_n161 where a < 3 group by cube(a, b) ) subq1 @@ -290,6 +296,8 @@ join (SELECT a, b, count(*) from T1_n161 where a < 3 group by cube(a, b) ) subq2 on subq1.a = subq2.a POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n161 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -561,6 +569,8 @@ join (SELECT a, b, count(*) from T1_n161 where a < 3 group by a, b with cube) subq2 on subq1.a = subq2.a PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n161 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM (SELECT a, b, count(*) from T1_n161 where a < 3 group by a, b with cube) subq1 @@ -568,6 +578,8 @@ join (SELECT a, b, count(*) from T1_n161 where a < 3 group by a, b with cube) subq2 on subq1.a = subq2.a POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n161 +#### 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_groupby_grouping_sets5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets5.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets5.q.out index 07c4eed..ff43724 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets5.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets5.q.out @@ -32,10 +32,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM (SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n33 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM (SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n33 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -223,10 +227,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM (SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by cube(a, b) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n33 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM (SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by cube(a, b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n33 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -440,10 +448,14 @@ PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM (SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n33 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM (SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n33 +#### 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_groupby_grouping_sets6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets6.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets6.q.out index 4563bd6..946abaf 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets6.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets6.q.out @@ -33,11 +33,15 @@ SELECT a, b FROM (SELECT a, b from T1_n84 group by a, b grouping sets ( (a,b),a )) res WHERE res.a=5 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n84 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b FROM (SELECT a, b from T1_n84 group by a, b grouping sets ( (a,b),a )) res WHERE res.a=5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n84 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -175,11 +179,15 @@ SELECT a, b FROM (SELECT a, b from T1_n84 group by a, b grouping sets ( (a,b),a )) res WHERE res.a=5 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n84 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b FROM (SELECT a, b from T1_n84 group by a, b grouping sets ( (a,b),a )) res WHERE res.a=5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n84 +#### 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_groupby_grouping_sets_grouping.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out index a5a3758..ab860c3 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out @@ -32,11 +32,15 @@ select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by rollup(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by rollup(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -192,11 +196,15 @@ select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by cube(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by cube(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -358,12 +366,16 @@ from T1_n47 group by cube(key, value) having grouping(key) = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value from T1_n47 group by cube(key, value) having grouping(key) = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -524,6 +536,8 @@ group by cube(key, value) having grouping(key) = 1 OR grouping(value) = 1 order by x desc, case when x = 1 then key end PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, grouping(key)+grouping(value) as x from T1_n47 @@ -531,6 +545,8 @@ group by cube(key, value) having grouping(key) = 1 OR grouping(value) = 1 order by x desc, case when x = 1 then key end POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -732,11 +748,15 @@ select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by rollup(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by rollup(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -892,11 +912,15 @@ select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by cube(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(key), grouping(value) from T1_n47 group by cube(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1058,12 +1082,16 @@ from T1_n47 group by cube(key, value) having grouping(key) = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value from T1_n47 group by cube(key, value) having grouping(key) = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1217,6 +1245,8 @@ group by cube(key, value) having grouping(key) = 1 OR grouping(value) = 1 order by x desc, case when x = 1 then key end PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, grouping(key)+grouping(value) as x from T1_n47 @@ -1224,6 +1254,8 @@ group by cube(key, value) having grouping(key) = 1 OR grouping(value) = 1 order by x desc, case when x = 1 then key end POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1426,11 +1458,15 @@ select key, value, grouping(key), grouping(value) from T1_n47 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, grouping(key), grouping(value) from T1_n47 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1581,11 +1617,15 @@ select key, value, grouping(value) from T1_n47 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, grouping(value) from T1_n47 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1737,12 +1777,16 @@ from T1_n47 group by key, value having grouping(key) = 0 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value from T1_n47 group by key, value having grouping(key) = 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1886,11 +1930,15 @@ select key, value, `grouping__id`, grouping(key, value) from T1_n47 group by cube(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(key, value) from T1_n47 group by cube(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2051,11 +2099,15 @@ select key, value, `grouping__id`, grouping(value, key) from T1_n47 group by cube(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(value, key) from T1_n47 group by cube(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2216,11 +2268,15 @@ select key, value, `grouping__id`, grouping(key, value) from T1_n47 group by rollup(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(key, value) from T1_n47 group by rollup(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2376,11 +2432,15 @@ select key, value, `grouping__id`, grouping(value, key) from T1_n47 group by rollup(key, value) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n47 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select key, value, `grouping__id`, grouping(value, key) from T1_n47 group by rollup(key, value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n47 +#### 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_groupby_grouping_sets_limit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_limit.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_limit.q.out index e7c235a..a629617 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_limit.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_limit.q.out @@ -31,9 +31,13 @@ t1_text_n8.a t1_text_n8.b t1_text_n8.c PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n110 group by a, b with cube order by a, b LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n110 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) from T1_n110 group by a, b with cube order by a, b LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n110 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -241,9 +245,13 @@ a b _c2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n110 GROUP BY a, b GROUPING SETS (a, (a, b), b, ()) order by a, b LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n110 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n110 GROUP BY a, b GROUPING SETS (a, (a, b), b, ()) order by a, b LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n110 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -451,9 +459,13 @@ a b _c2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n110 GROUP BY a, b GROUPING SETS (a, (a, b)) order by a, b LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n110 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a, b, count(*) FROM T1_n110 GROUP BY a, b GROUPING SETS (a, (a, b)) order by a, b LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n110 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -661,9 +673,13 @@ a b _c2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n110 GROUP BY a, b, c GROUPING SETS (a, b, c) order by a LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n110 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n110 GROUP BY a, b, c GROUPING SETS (a, b, c) order by a LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n110 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -863,9 +879,13 @@ NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n110 GROUP BY a GROUPING SETS ((a), (a)) order by a LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n110 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a FROM T1_n110 GROUP BY a GROUPING SETS ((a), (a)) order by a LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n110 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1051,9 +1071,13 @@ a PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a + b ab, count(*) FROM T1_n110 GROUP BY a + b GROUPING SETS (a+b) order by ab LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n110 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT a + b ab, count(*) FROM T1_n110 GROUP BY a + b GROUPING SETS (a+b) order by ab LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n110 +#### 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_groupby_grouping_window.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_window.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_window.q.out index abf1c89..1678546 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_window.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_grouping_window.q.out @@ -25,6 +25,8 @@ GROUP BY category GROUPING SETS ((), (category)) HAVING max(comments) > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@t_n15 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select category, max(live) live, max(comments) comments, rank() OVER (PARTITION BY category ORDER BY comments) rank1 FROM t_n15 @@ -32,6 +34,8 @@ GROUP BY category GROUPING SETS ((), (category)) HAVING max(comments) > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t_n15 +#### 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_groupby_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out index 26795d2..1309bf6 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out @@ -6,6 +6,8 @@ where not key in (select key from src) order by key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from src @@ -13,6 +15,8 @@ where not key in (select key from src) order by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_groupby_reduce.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_reduce.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_reduce.q.out index dfc8828..3696cad 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_reduce.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_reduce.q.out @@ -225,6 +225,8 @@ group by ss_ticket_number order by ss_ticket_number limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ss_ticket_number @@ -234,6 +236,8 @@ group by ss_ticket_number order by ss_ticket_number limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -430,6 +434,8 @@ from group by ss_ticket_number order by m PREHOOK: type: QUERY +PREHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select min(ss_ticket_number) m @@ -442,6 +448,8 @@ from group by ss_ticket_number order by m POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -712,6 +720,8 @@ from group by ss_ticket_number order by ss_ticket_number PREHOOK: type: QUERY +PREHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ss_ticket_number, sum(ss_item_sk), sum(q), avg(q), sum(np), avg(np), sum(decwc), avg(decwc) @@ -725,6 +735,8 @@ from group by ss_ticket_number order by ss_ticket_number POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -945,6 +957,8 @@ from group by ss_ticket_number, ss_item_sk order by ss_ticket_number, ss_item_sk PREHOOK: type: QUERY +PREHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ss_ticket_number, ss_item_sk, sum(q), avg(q), sum(np), avg(np), sum(decwc), avg(decwc) @@ -957,6 +971,8 @@ from group by ss_ticket_number, ss_item_sk order by ss_ticket_number, ss_item_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_sales_n3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_groupby_rollup1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_rollup1.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_rollup1.q.out index abf352d..6109a65 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_rollup1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_rollup1.q.out @@ -29,9 +29,13 @@ POSTHOOK: Lineage: t1_n83.val SIMPLE [(t1_text_n5)t1_text_n5.FieldSchema(name:va PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n83 GROUP BY key, val with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n83 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n83 GROUP BY key, val with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n83 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -186,9 +190,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n83 GROUP BY key with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n83 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n83 GROUP BY key with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n83 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -283,9 +291,13 @@ NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n83 GROUP BY key, val with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n83 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, val, count(1) FROM T1_n83 GROUP BY key, val with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n83 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -485,9 +497,13 @@ NULL NULL 6 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n83 GROUP BY key with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n83 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT key, count(distinct val) FROM T1_n83 GROUP BY key with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n83 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -621,11 +637,17 @@ FROM T1_n83 INSERT OVERWRITE TABLE T2_n52 SELECT key, val, count(1) group by key, val with rollup INSERT OVERWRITE TABLE T3_n17 SELECT key, val, sum(1) group by rollup(key, val) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n83 +PREHOOK: Output: default@t2_n52 +PREHOOK: Output: default@t3_n17 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL FROM T1_n83 INSERT OVERWRITE TABLE T2_n52 SELECT key, val, count(1) group by key, val with rollup INSERT OVERWRITE TABLE T3_n17 SELECT key, val, sum(1) group by rollup(key, val) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n83 +POSTHOOK: Output: default@t2_n52 +POSTHOOK: Output: default@t3_n17 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_groupby_sort_11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_sort_11.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_sort_11.q.out index edc1fae..8d93ddf 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_sort_11.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_sort_11.q.out @@ -23,9 +23,15 @@ POSTHOOK: Lineage: t1_n137 PARTITION(ds=1).val SIMPLE [(src)src.FieldSchema(name PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key) from T1_n137 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key) from T1_n137 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -168,9 +174,15 @@ POSTHOOK: Input: default@t1_n137@ds=1 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -257,9 +269,15 @@ POSTHOOK: Input: default@t1_n137@ds=1 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -357,9 +375,15 @@ POSTHOOK: Input: default@t1_n137@ds=1 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select key, count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select key, count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -453,9 +477,15 @@ POSTHOOK: Input: default@t1_n137@ds=1 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key+key) from T1_n137 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key+key) from T1_n137 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -638,9 +668,15 @@ POSTHOOK: Input: default@t1_n137@ds=1 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct 1) from T1_n137 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct 1) from T1_n137 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -826,9 +862,15 @@ POSTHOOK: Input: default@t1_n137@ds=1 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key) from T1_n137 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n137 +PREHOOK: Input: default@t1_n137@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key) from T1_n137 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n137 +POSTHOOK: Input: default@t1_n137@ds=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_groupby_sort_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_groupby_sort_8.q.out b/ql/src/test/results/clientpositive/llap/vector_groupby_sort_8.q.out index d3ba688..64292e0 100644 --- a/ql/src/test/results/clientpositive/llap/vector_groupby_sort_8.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_groupby_sort_8.q.out @@ -32,9 +32,15 @@ POSTHOOK: Lineage: t1_n2 PARTITION(ds=1).val SIMPLE [(t1_n2)t1_n2.FieldSchema(na PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key) from T1_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n2 +PREHOOK: Input: default@t1_n2@ds=1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL select count(distinct key) from T1_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n2 +POSTHOOK: Input: default@t1_n2@ds=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_grouping_sets.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out b/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out index e0d533f..78de680 100644 --- a/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out @@ -128,11 +128,15 @@ select s_store_id from store_n1 group by s_store_id with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@store_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select s_store_id from store_n1 group by s_store_id with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -259,11 +263,15 @@ select s_store_id, GROUPING__ID from store_n1 group by s_store_id with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@store_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select s_store_id, GROUPING__ID from store_n1 group by s_store_id with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -397,11 +405,15 @@ select s_store_id, GROUPING__ID from store_n1 group by rollup(s_store_id) PREHOOK: type: QUERY +PREHOOK: Input: default@store_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select s_store_id, GROUPING__ID from store_n1 group by rollup(s_store_id) POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/vector_if_expr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_if_expr.q.out b/ql/src/test/results/clientpositive/llap/vector_if_expr.q.out index 00e464d..e95ac92 100644 --- a/ql/src/test/results/clientpositive/llap/vector_if_expr.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_if_expr.q.out @@ -1,9 +1,13 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cboolean1, IF (cboolean1, 'first', 'second') FROM alltypesorc WHERE cboolean1 IS NOT NULL AND cboolean1 ORDER BY cboolean1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cboolean1, IF (cboolean1, 'first', 'second') FROM alltypesorc WHERE cboolean1 IS NOT NULL AND cboolean1 ORDER BY cboolean1 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_if_expr_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_if_expr_2.q.out b/ql/src/test/results/clientpositive/llap/vector_if_expr_2.q.out index f50fe2d..8bf3016 100644 --- a/ql/src/test/results/clientpositive/llap/vector_if_expr_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_if_expr_2.q.out @@ -23,9 +23,13 @@ POSTHOOK: Lineage: foo.y SCRIPT [] PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION select x, IF(x > 0,y,0) from foo order by x PREHOOK: type: QUERY +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION select x, IF(x > 0,y,0) from foo order by x POSTHOOK: type: QUERY +POSTHOOK: Input: default@foo +#### 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_include_no_sel.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_include_no_sel.q.out b/ql/src/test/results/clientpositive/llap/vector_include_no_sel.q.out index c5e1dae..57411c4 100644 --- a/ql/src/test/results/clientpositive/llap/vector_include_no_sel.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_include_no_sel.q.out @@ -168,11 +168,17 @@ select count(1) from customer_demographics,store_sales_n1 where ((customer_demographics.cd_demo_sk = store_sales_n1.ss_cdemo_sk and customer_demographics.cd_marital_status = 'M') or (customer_demographics.cd_demo_sk = store_sales_n1.ss_cdemo_sk and customer_demographics.cd_marital_status = 'U')) PREHOOK: type: QUERY +PREHOOK: Input: default@customer_demographics +PREHOOK: Input: default@store_sales_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select count(1) from customer_demographics,store_sales_n1 where ((customer_demographics.cd_demo_sk = store_sales_n1.ss_cdemo_sk and customer_demographics.cd_marital_status = 'M') or (customer_demographics.cd_demo_sk = store_sales_n1.ss_cdemo_sk and customer_demographics.cd_marital_status = 'U')) POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_demographics +POSTHOOK: Input: default@store_sales_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
