http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 02f4683..bd81fcb 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/b356aae0/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 1229c6d..7e15227 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 @@ -846,9 +866,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 @@ -984,9 +1008,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/b356aae0/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 f8220e1..a722595 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/b356aae0/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 dce648a..62e6092 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/b356aae0/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 d00306b..d0b9114 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/b356aae0/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 a262f26..1d99efa 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 @@ -279,6 +283,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 @@ -286,6 +292,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 @@ -553,6 +561,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 @@ -560,6 +570,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/b356aae0/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 bbfba28..ca3bfda 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 @@ -224,10 +228,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 @@ -442,10 +450,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/b356aae0/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 e26b6c5..a3a2e7b 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 @@ -176,11 +180,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/b356aae0/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 35e601d..ce7d5f5 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 @@ -193,11 +197,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 @@ -360,12 +368,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 @@ -527,6 +539,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 @@ -534,6 +548,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 @@ -736,11 +752,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 @@ -897,11 +917,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 @@ -1064,12 +1088,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 @@ -1224,6 +1252,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 @@ -1231,6 +1261,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 @@ -1434,11 +1466,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 @@ -1590,11 +1626,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 @@ -1747,12 +1787,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 @@ -1897,11 +1941,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 @@ -2063,11 +2111,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 @@ -2229,11 +2281,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 @@ -2390,11 +2446,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/b356aae0/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 09c7beb..a6efa3c 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 @@ -865,9 +881,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 @@ -1055,9 +1075,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/b356aae0/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 004af4b..a606e94 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/b356aae0/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 e6628ab..866180b 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/b356aae0/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 19ea9cd..7f4950d 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] @@ -944,6 +956,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) @@ -956,6 +970,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/b356aae0/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 d1f8ac5..a4cc16a 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/b356aae0/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 ab29314..f8c6b1d 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] @@ -169,9 +175,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] @@ -258,9 +270,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] @@ -358,9 +376,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] @@ -454,9 +478,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] @@ -641,9 +671,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] @@ -831,9 +867,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/b356aae0/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 5e946c4..5801bf7 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/b356aae0/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/b356aae0/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 a88e385..e61d68a 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/b356aae0/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 ddcd2a0..e9e82d6 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/b356aae0/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 041990a..ae87f6c 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] http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out b/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out index fb3d7cb..223b504 100644 --- a/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out @@ -35,9 +35,15 @@ POSTHOOK: Lineage: orc_table_2a.c SCRIPT [] PREHOOK: query: explain vectorization detail select t1.a from orc_table_2a t2 join orc_table_1a t1 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1a +PREHOOK: Input: default@orc_table_2a +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.a from orc_table_2a t2 join orc_table_1a t1 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1a +POSTHOOK: Input: default@orc_table_2a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -201,9 +207,15 @@ POSTHOOK: Input: default@orc_table_2a PREHOOK: query: explain vectorization detail select t2.c from orc_table_2a t2 left semi join orc_table_1a t1 on t1.a = t2.c where t2.c > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1a +PREHOOK: Input: default@orc_table_2a +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t2.c from orc_table_2a t2 left semi join orc_table_1a t1 on t1.a = t2.c where t2.c > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1a +POSTHOOK: Input: default@orc_table_2a +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -408,9 +420,15 @@ POSTHOOK: Lineage: orc_table_2b.v2 SCRIPT [] PREHOOK: query: explain vectorization detail select t1.v1, t1.a from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.v1, t1.a from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -576,9 +594,15 @@ three 3 PREHOOK: query: explain vectorization detail select t1.v1, t1.a, t2.c, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.v1, t1.a, t2.c, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -737,9 +761,15 @@ three 3 3 THREE PREHOOK: query: explain vectorization detail select t1.v1, t1.a*2, t2.c*5, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.v1, t1.a*2, t2.c*5, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -907,9 +937,15 @@ three 6 15 THREE PREHOOK: query: explain vectorization detail select t1.v1, t2.v2, t2.c from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.v1, t2.v2, t2.c from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1076,9 +1112,15 @@ three THREE 3 PREHOOK: query: explain vectorization detail select t1.a, t1.v1, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.a, t1.v1, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1245,9 +1287,15 @@ POSTHOOK: Input: default@orc_table_2b PREHOOK: query: explain vectorization detail select t1.v1, t2.v2, t2.c from orc_table_1b t1 join orc_table_2b t2 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.v1, t2.v2, t2.c from orc_table_1b t1 join orc_table_2b t2 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1414,9 +1462,15 @@ three THREE 3 PREHOOK: query: explain vectorization detail select t1.a, t1.v1, t2.v2 from orc_table_1b t1 join orc_table_2b t2 on t1.a = t2.c where t1.a > 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table_1b +PREHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select t1.a, t1.v1, t2.v2 from orc_table_1b t1 join orc_table_2b t2 on t1.a = t2.c where t1.a > 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table_1b +POSTHOOK: Input: default@orc_table_2b +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_interval_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_1.q.out b/ql/src/test/results/clientpositive/llap/vector_interval_1.q.out index 6e0663c..ca280bc 100644 --- a/ql/src/test/results/clientpositive/llap/vector_interval_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_interval_1.q.out @@ -58,6 +58,8 @@ select interval '1 2:3:4' day to second, interval_day_time(str2) from vector_interval_1 order by str1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select str1, @@ -65,6 +67,8 @@ select interval '1 2:3:4' day to second, interval_day_time(str2) from vector_interval_1 order by str1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -183,6 +187,8 @@ select interval '1-2' year to month - interval_year_month(str1) from vector_interval_1 order by dt PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dt, @@ -194,6 +200,8 @@ select interval '1-2' year to month - interval_year_month(str1) from vector_interval_1 order by dt POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -320,6 +328,8 @@ select interval '1 2:3:4' day to second - interval_day_time(str2) from vector_interval_1 order by dt PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dt, @@ -331,6 +341,8 @@ select interval '1 2:3:4' day to second - interval_day_time(str2) from vector_interval_1 order by dt POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -463,6 +475,8 @@ select dt - interval_day_time(str2) from vector_interval_1 order by dt PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dt, @@ -480,6 +494,8 @@ select dt - interval_day_time(str2) from vector_interval_1 order by dt POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -623,6 +639,8 @@ select ts - interval_day_time(str2) from vector_interval_1 order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts, @@ -640,6 +658,8 @@ select ts - interval_day_time(str2) from vector_interval_1 order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -774,6 +794,8 @@ select ts - timestamp '2001-01-01 01:02:03' from vector_interval_1 order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts, @@ -782,6 +804,8 @@ select ts - timestamp '2001-01-01 01:02:03' from vector_interval_1 order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -898,6 +922,8 @@ select dt - date '2001-01-01' from vector_interval_1 order by dt PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dt, @@ -906,6 +932,8 @@ select dt - date '2001-01-01' from vector_interval_1 order by dt POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1025,6 +1053,8 @@ select date '2001-01-01' - ts from vector_interval_1 order by dt PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dt, @@ -1036,6 +1066,8 @@ select date '2001-01-01' - ts from vector_interval_1 order by dt POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out index fec783c..ea15936 100644 --- a/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out @@ -74,6 +74,8 @@ select interval '1-2' year to month != interval_year_month(str2) from vector_interval_2 order by str1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select str1, @@ -106,6 +108,8 @@ select interval '1-2' year to month != interval_year_month(str2) from vector_interval_2 order by str1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -286,6 +290,8 @@ select interval '1-2' year to month != interval_year_month(str1) from vector_interval_2 order by str1 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select str1, @@ -312,6 +318,8 @@ select interval '1-2' year to month != interval_year_month(str1) from vector_interval_2 order by str1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -486,6 +494,8 @@ select interval '1 2:3:4' day to second != interval_day_time(str4) from vector_interval_2 order by str3 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select str3, @@ -518,6 +528,8 @@ select interval '1 2:3:4' day to second != interval_day_time(str4) from vector_interval_2 order by str3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -698,6 +710,8 @@ select interval '1 2:3:4' day to second != interval_day_time(str3) from vector_interval_2 order by str3 PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select str3, @@ -724,6 +738,8 @@ select interval '1 2:3:4' day to second != interval_day_time(str3) from vector_interval_2 order by str3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -891,6 +907,8 @@ where and interval '1-3' year to month > interval_year_month(str1) order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts from vector_interval_2 where @@ -916,6 +934,8 @@ where and interval '1-3' year to month > interval_year_month(str1) order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1085,6 +1105,8 @@ where and interval '1 2:3:5' day to second > interval_day_time(str3) order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts from vector_interval_2 where @@ -1110,6 +1132,8 @@ where and interval '1 2:3:5' day to second > interval_day_time(str3) order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1274,6 +1298,8 @@ where and dt != dt + interval '1-2' year to month order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts from vector_interval_2 where @@ -1294,6 +1320,8 @@ where and dt != dt + interval '1-2' year to month order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1453,6 +1481,8 @@ where and ts > ts - interval '1' year order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts from vector_interval_2 where @@ -1478,6 +1508,8 @@ where and ts > ts - interval '1' year order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1647,6 +1679,8 @@ where and ts > dt - interval '0 1:2:4' day to second order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts from vector_interval_2 where @@ -1672,6 +1706,8 @@ where and ts > dt - interval '0 1:2:4' day to second order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1841,6 +1877,8 @@ where and ts > ts - interval '1' day order by ts PREHOOK: type: QUERY +PREHOOK: Input: default@vector_interval_2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select ts from vector_interval_2 where @@ -1866,6 +1904,8 @@ where and ts > ts - interval '1' day order by ts POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_interval_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/b356aae0/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out b/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out index 2fadf29..9a7b261 100644 --- a/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out @@ -47,6 +47,8 @@ select from interval_arithmetic_1 order by dateval PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dateval, @@ -59,6 +61,8 @@ select from interval_arithmetic_1 order by dateval POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -232,6 +236,8 @@ select from interval_arithmetic_1 order by dateval PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dateval, @@ -241,6 +247,8 @@ select from interval_arithmetic_1 order by dateval POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -411,6 +419,8 @@ select from interval_arithmetic_1 order by tsval PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tsval, @@ -423,6 +433,8 @@ select from interval_arithmetic_1 order by tsval POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -595,6 +607,8 @@ from interval_arithmetic_1 order by interval '2-2' year to month + interval '3-3' year to month limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select interval '2-2' year to month + interval '3-3' year to month, @@ -603,6 +617,8 @@ from interval_arithmetic_1 order by interval '2-2' year to month + interval '3-3' year to month limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -700,6 +716,8 @@ select from interval_arithmetic_1 order by dateval PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dateval, @@ -712,6 +730,8 @@ select from interval_arithmetic_1 order by dateval POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -886,6 +906,8 @@ select from interval_arithmetic_1 order by dateval PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select dateval, @@ -896,6 +918,8 @@ select from interval_arithmetic_1 order by dateval POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1068,6 +1092,8 @@ select from interval_arithmetic_1 order by tsval PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tsval, @@ -1080,6 +1106,8 @@ select from interval_arithmetic_1 order by tsval POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1251,6 +1279,8 @@ select from interval_arithmetic_1 limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second, @@ -1258,6 +1288,8 @@ select from interval_arithmetic_1 limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@interval_arithmetic_1 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out index 2b9fc34..56143e6 100644 --- a/ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out @@ -158,6 +158,9 @@ join on v1.intrvl1 = v2.intrvl2 and v1.s = v2.s PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab_a_1korc +PREHOOK: Input: default@vectortab_b_1korc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select v1.s, @@ -180,6 +183,9 @@ join on v1.intrvl1 = v2.intrvl2 and v1.s = v2.s POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab_a_1korc +POSTHOOK: Input: default@vectortab_b_1korc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_join30.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_join30.q.out b/ql/src/test/results/clientpositive/llap/vector_join30.q.out index 5187574..af8c51a 100644 --- a/ql/src/test/results/clientpositive/llap/vector_join30.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_join30.q.out @@ -18,6 +18,8 @@ JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -26,6 +28,8 @@ JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -217,6 +221,8 @@ LEFT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -225,6 +231,8 @@ LEFT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -403,6 +411,8 @@ RIGHT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -411,6 +421,8 @@ RIGHT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -591,6 +603,8 @@ JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -602,6 +616,8 @@ JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -850,6 +866,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -861,6 +879,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1080,6 +1100,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -1091,6 +1113,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1310,6 +1334,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -1321,6 +1347,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1540,6 +1568,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression FROM (SELECT orcsrc_n0.* FROM orcsrc_n0 sort by key) x @@ -1551,6 +1581,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcsrc_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out b/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out index 3d78cfe..0999b5d 100644 --- a/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out @@ -7,6 +7,8 @@ left outer join alltypesorc hd on hd.ctinyint = c.ctinyint ) t1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select count(*) from (select c.ctinyint from alltypesorc c @@ -16,6 +18,8 @@ left outer join alltypesorc hd on hd.ctinyint = c.ctinyint ) t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out b/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out index 55be910..6da63a2 100644 --- a/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out @@ -79,9 +79,15 @@ POSTHOOK: Lineage: tjoin2.rnum SIMPLE [(tjoin2stage)tjoin2stage.FieldSchema(name PREHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: false enabledConditionsNotMet: [hive.vectorized.execution.enabled IS false] @@ -173,9 +179,15 @@ POSTHOOK: Input: default@tjoin2 PREHOOK: query: explain select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -263,9 +275,15 @@ POSTHOOK: Input: default@tjoin2 PREHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -405,9 +423,15 @@ POSTHOOK: Input: default@tjoin2 PREHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -547,9 +571,15 @@ POSTHOOK: Input: default@tjoin2 PREHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -686,9 +716,15 @@ POSTHOOK: Input: default@tjoin2 PREHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY +PREHOOK: Input: default@tjoin1 +PREHOOK: Input: default@tjoin2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tjoin1 +POSTHOOK: Input: default@tjoin2 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
