http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out index 57a1ea7..661800c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out @@ -247,9 +247,13 @@ POSTHOOK: Input: default@flights_tiny_orc PREHOOK: query: explain vectorization expression select * from flights_tiny_orc sort by fl_num, fl_date limit 25 PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_orc sort by fl_num, fl_date limit 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -412,9 +416,13 @@ Chicago New York 2010-10-27 2010-10-27 07:00:00 -11.0 897 PREHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_orc group by fl_date PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_orc group by fl_date POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -923,9 +931,37 @@ POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 PREHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_date PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc_partitioned_date +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_date POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1154,9 +1190,37 @@ Washington New York 2010-10-31 07:00:00 -18.0 7282 2010-10-31 PREHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25 PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc_partitioned_date +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1343,9 +1407,37 @@ Chicago New York 2010-10-27 07:00:00 -11.0 897 2010-10-27 PREHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc_partitioned_date +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30 +PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1878,9 +1970,37 @@ POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10- PREHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_timestamp PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_timestamp POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2109,9 +2229,37 @@ Washington New York 2010-10-31 -18.0 7282 2010-10-31 07:00:00 PREHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_timestamp sort by fl_num, fl_time limit 25 PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_timestamp sort by fl_num, fl_time limit 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2298,9 +2446,37 @@ Chicago New York 2010-10-27 -11.0 897 2010-10-27 07:00:00 PREHOOK: query: explain vectorization expression select fl_time, count(*) from flights_tiny_orc_partitioned_timestamp group by fl_time PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select fl_time, count(*) from flights_tiny_orc_partitioned_timestamp group by fl_time POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2672,9 +2848,13 @@ POSTHOOK: Input: default@flights_tiny_parquet PREHOOK: query: explain vectorization expression select * from flights_tiny_parquet sort by fl_num, fl_date limit 25 PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_parquet sort by fl_num, fl_date limit 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2837,9 +3017,13 @@ Chicago New York 2010-10-27 2010-10-27 07:00:00 -11.0 897 PREHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_parquet group by fl_date PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_parquet group by fl_date POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3348,9 +3532,37 @@ POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-3 PREHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_date PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-20 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-21 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-22 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-23 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-24 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-25 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-26 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-27 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-28 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-29 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-30 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_date POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-20 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-21 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-22 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-23 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-24 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-25 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-26 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-27 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-28 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-29 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-30 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3579,9 +3791,37 @@ Washington New York 2010-10-31 07:00:00 -18.0 7282 2010-10-31 PREHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_date sort by fl_num, fl_date limit 25 PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-20 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-21 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-22 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-23 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-24 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-25 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-26 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-27 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-28 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-29 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-30 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_date sort by fl_num, fl_date limit 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-20 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-21 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-22 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-23 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-24 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-25 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-26 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-27 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-28 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-29 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-30 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3768,9 +4008,37 @@ Chicago New York 2010-10-27 07:00:00 -11.0 897 2010-10-27 PREHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_parquet_partitioned_date group by fl_date PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-20 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-21 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-22 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-23 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-24 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-25 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-26 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-27 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-28 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-29 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-30 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select fl_date, count(*) from flights_tiny_parquet_partitioned_date group by fl_date POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-20 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-21 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-22 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-23 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-24 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-25 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-26 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-27 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-28 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-29 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-30 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_date@fl_date=2010-10-31 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4303,9 +4571,37 @@ POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010 PREHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_timestamp PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_timestamp POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4534,9 +4830,37 @@ Washington New York 2010-10-31 -18.0 7282 2010-10-31 07:00:00 PREHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_timestamp sort by fl_num, fl_time limit 25 PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_timestamp sort by fl_num, fl_time limit 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4723,9 +5047,37 @@ Chicago New York 2010-10-27 -11.0 897 2010-10-27 07:00:00 PREHOOK: query: explain vectorization expression select fl_time, count(*) from flights_tiny_parquet_partitioned_timestamp group by fl_time PREHOOK: type: QUERY +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +PREHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select fl_time, count(*) from flights_tiny_parquet_partitioned_timestamp group by fl_time POSTHOOK: type: QUERY +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 +POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_ptf_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_ptf_1.q.out b/ql/src/test/results/clientpositive/llap/vector_ptf_1.q.out index ef4934e..a7c7f8e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_ptf_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_ptf_1.q.out @@ -40,11 +40,15 @@ select age, name, avg(gpa), sum(age) over (partition by name) from studentnull100 group by age, name PREHOOK: type: QUERY +PREHOOK: Input: default@studentnull100 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select age, name, avg(gpa), sum(age) over (partition by name) from studentnull100 group by age, name POSTHOOK: type: QUERY +POSTHOOK: Input: default@studentnull100 +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out index e16f843..dd7c198 100644 --- a/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out @@ -100,6 +100,8 @@ count(p_retailprice) over(partition by p_mfgr) as c, count(*) over(partition by p_mfgr) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr) as rn, @@ -111,6 +113,8 @@ count(p_retailprice) over(partition by p_mfgr) as c, count(*) over(partition by p_mfgr) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -360,6 +364,8 @@ count(p_retailprice) over(partition by p_mfgr range between unbounded preceding count(*) over(partition by p_mfgr range between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr range between unbounded preceding and unbounded following) as rn, @@ -371,6 +377,8 @@ count(p_retailprice) over(partition by p_mfgr range between unbounded preceding count(*) over(partition by p_mfgr range between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -589,6 +597,8 @@ count(p_retailprice) over(partition by p_mfgr rows between unbounded preceding a count(*) over(partition by p_mfgr rows between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr rows between unbounded preceding and unbounded following) as rn, @@ -600,6 +610,8 @@ count(p_retailprice) over(partition by p_mfgr rows between unbounded preceding a count(*) over(partition by p_mfgr rows between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -818,6 +830,8 @@ count(p_retailprice) over(partition by p_mfgr order by p_name) as c, count(*) over(partition by p_mfgr order by p_name) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr order by p_name) as rn, @@ -829,6 +843,8 @@ count(p_retailprice) over(partition by p_mfgr order by p_name) as c, count(*) over(partition by p_mfgr order by p_name) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1080,6 +1096,8 @@ count(p_retailprice) over(partition by p_mfgr order by p_name range between unbo count(*) over(partition by p_mfgr order by p_name range between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr order by p_name range between unbounded preceding and unbounded following) as rn, @@ -1091,6 +1109,8 @@ count(p_retailprice) over(partition by p_mfgr order by p_name range between unbo count(*) over(partition by p_mfgr order by p_name range between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1310,6 +1330,8 @@ count(p_retailprice) over(partition by p_mfgr order by p_name rows between unbou count(*) over(partition by p_mfgr order by p_name rows between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr order by p_name rows between unbounded preceding and unbounded following) as rn, @@ -1321,6 +1343,8 @@ count(p_retailprice) over(partition by p_mfgr order by p_name rows between unbou count(*) over(partition by p_mfgr order by p_name rows between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1540,6 +1564,8 @@ count(p_retailprice) over(order by p_name) as c, count(*) over(order by p_name) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(order by p_name) as rn, @@ -1551,6 +1577,8 @@ count(p_retailprice) over(order by p_name) as c, count(*) over(order by p_name) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -1803,6 +1831,8 @@ count(p_retailprice) over(order by p_name range between unbounded preceding and count(*) over(order by p_name range between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(order by p_name range between unbounded preceding and unbounded following) as rn, @@ -1814,6 +1844,8 @@ count(p_retailprice) over(order by p_name range between unbounded preceding and count(*) over(order by p_name range between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2034,6 +2066,8 @@ count(p_retailprice) over(order by p_name rows between unbounded preceding and c count(*) over(order by p_name rows between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(order by p_name rows between unbounded preceding and unbounded following) as rn, @@ -2045,6 +2079,8 @@ count(p_retailprice) over(order by p_name rows between unbounded preceding and c count(*) over(order by p_name rows between unbounded preceding and current row) as cs from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2262,6 +2298,8 @@ max(p_retailprice) over(partition by p_mfgr) as ma, avg(p_retailprice) over(partition by p_mfgr) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr) as s, @@ -2270,6 +2308,8 @@ max(p_retailprice) over(partition by p_mfgr) as ma, avg(p_retailprice) over(partition by p_mfgr) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2490,6 +2530,8 @@ max(p_retailprice) over(partition by p_mfgr range between unbounded preceding an avg(p_retailprice) over(partition by p_mfgr range between unbounded preceding and current row) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr range between unbounded preceding and current row) as s, @@ -2498,6 +2540,8 @@ max(p_retailprice) over(partition by p_mfgr range between unbounded preceding an avg(p_retailprice) over(partition by p_mfgr range between unbounded preceding and current row) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2718,6 +2762,8 @@ max(p_retailprice) over(partition by p_mfgr rows between unbounded preceding and avg(p_retailprice) over(partition by p_mfgr rows between unbounded preceding and current row) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr rows between unbounded preceding and current row) as s, @@ -2726,6 +2772,8 @@ max(p_retailprice) over(partition by p_mfgr rows between unbounded preceding and avg(p_retailprice) over(partition by p_mfgr rows between unbounded preceding and current row) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -2915,6 +2963,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name) as ma, avg(p_retailprice) over(partition by p_mfgr order by p_name) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr order by p_name) as s, @@ -2923,6 +2973,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name) as ma, avg(p_retailprice) over(partition by p_mfgr order by p_name) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3145,6 +3197,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name range between unboun avg(p_retailprice) over(partition by p_mfgr order by p_name range between unbounded preceding and current row) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr order by p_name range between unbounded preceding and current row) as s, @@ -3153,6 +3207,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name range between unboun avg(p_retailprice) over(partition by p_mfgr order by p_name range between unbounded preceding and current row) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3375,6 +3431,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name rows between unbound avg(p_retailprice) over(partition by p_mfgr order by p_name rows between unbounded preceding and current row) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr order by p_name rows between unbounded preceding and current row) as s, @@ -3383,6 +3441,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name rows between unbound avg(p_retailprice) over(partition by p_mfgr order by p_name rows between unbounded preceding and current row) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3573,6 +3633,8 @@ max(p_retailprice) over(order by p_name) as ma, avg(p_retailprice) over(order by p_name) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(order by p_name) as s, @@ -3581,6 +3643,8 @@ max(p_retailprice) over(order by p_name) as ma, avg(p_retailprice) over(order by p_name) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -3804,6 +3868,8 @@ max(p_retailprice) over(order by p_name range between unbounded preceding and cu avg(p_retailprice) over(order by p_name range between unbounded preceding and current row) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(order by p_name range between unbounded preceding and current row) as s, @@ -3812,6 +3878,8 @@ max(p_retailprice) over(order by p_name range between unbounded preceding and cu avg(p_retailprice) over(order by p_name range between unbounded preceding and current row) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4035,6 +4103,8 @@ max(p_retailprice) over(order by p_name rows between unbounded preceding and cur avg(p_retailprice) over(order by p_name rows between unbounded preceding and current row) as av from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(order by p_name rows between unbounded preceding and current row) as s, @@ -4043,6 +4113,8 @@ max(p_retailprice) over(order by p_name rows between unbounded preceding and cur avg(p_retailprice) over(order by p_name rows between unbounded preceding and current row) as av from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4276,6 +4348,8 @@ max(p_retailprice) over(partition by p_mfgr) as ma, avg(p_retailprice) over(partition by p_mfgr) as av from vector_ptf_part_simple_orc_decimal PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc_decimal +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr) as s, @@ -4284,6 +4358,8 @@ max(p_retailprice) over(partition by p_mfgr) as ma, avg(p_retailprice) over(partition by p_mfgr) as av from vector_ptf_part_simple_orc_decimal POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc_decimal +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4504,6 +4580,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name) as ma, avg(p_retailprice) over(partition by p_mfgr order by p_name) as av from vector_ptf_part_simple_orc_decimal PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc_decimal +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr order by p_name) as s, @@ -4512,6 +4590,8 @@ max(p_retailprice) over(partition by p_mfgr order by p_name) as ma, avg(p_retailprice) over(partition by p_mfgr order by p_name) as av from vector_ptf_part_simple_orc_decimal POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc_decimal +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4754,6 +4834,8 @@ max(p_bigint) over(partition by p_mfgr) as ma, avg(p_bigint) over(partition by p_mfgr) as av from vector_ptf_part_simple_orc_long PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc_long +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_bigint, sum(p_bigint) over(partition by p_mfgr) as s, @@ -4762,6 +4844,8 @@ max(p_bigint) over(partition by p_mfgr) as ma, avg(p_bigint) over(partition by p_mfgr) as av from vector_ptf_part_simple_orc_long POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc_long +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -4982,6 +5066,8 @@ max(p_bigint) over(partition by p_mfgr order by p_name) as ma, avg(p_bigint) over(partition by p_mfgr order by p_name) as av from vector_ptf_part_simple_orc_long PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc_long +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr,p_name, p_bigint, sum(p_bigint) over(partition by p_mfgr order by p_name) as s, @@ -4990,6 +5076,8 @@ max(p_bigint) over(partition by p_mfgr order by p_name) as ma, avg(p_bigint) over(partition by p_mfgr order by p_name) as av from vector_ptf_part_simple_orc_long POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc_long +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -5209,11 +5297,15 @@ select p_mfgr, p_retailprice, rank() over(partition by p_mfgr) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, rank() over(partition by p_mfgr) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -5408,11 +5500,15 @@ select p_mfgr, p_retailprice, rank() over(partition by p_mfgr order by p_name) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, rank() over(partition by p_mfgr order by p_name) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -5609,11 +5705,15 @@ select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -5778,11 +5878,15 @@ select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end order by p_name) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end order by p_name) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6110,11 +6214,15 @@ select p_mfgr, p_retailprice, rank() over(partition by p_mfgr) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, rank() over(partition by p_mfgr) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6309,11 +6417,15 @@ select p_mfgr, p_retailprice, rank() over(partition by p_mfgr order by p_name) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, rank() over(partition by p_mfgr order by p_name) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6510,11 +6622,15 @@ select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end order by p_name) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end order by p_name) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true @@ -6712,11 +6828,15 @@ select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end) as r from vector_ptf_part_simple_orc PREHOOK: type: QUERY +PREHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end) as r from vector_ptf_part_simple_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@vector_ptf_part_simple_orc +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_reduce1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_reduce1.q.out b/ql/src/test/results/clientpositive/llap/vector_reduce1.q.out index a3ad696..05afadc 100644 --- a/ql/src/test/results/clientpositive/llap/vector_reduce1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_reduce1.q.out @@ -104,9 +104,13 @@ POSTHOOK: Lineage: vectortab2korc_n7.ts2 SIMPLE [(vectortab2k_n8)vectortab2k_n8. PREHOOK: query: explain vectorization expression select b from vectortab2korc_n7 order by b PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n7 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select b from vectortab2korc_n7 order by b POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_n7 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_reduce2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_reduce2.q.out b/ql/src/test/results/clientpositive/llap/vector_reduce2.q.out index 8ff51ac..c86eea4 100644 --- a/ql/src/test/results/clientpositive/llap/vector_reduce2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_reduce2.q.out @@ -104,9 +104,13 @@ POSTHOOK: Lineage: vectortab2korc_n5.ts2 SIMPLE [(vectortab2k_n5)vectortab2k_n5. PREHOOK: query: explain vectorization expression select s, i, s2 from vectortab2korc_n5 order by s, i, s2 PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n5 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select s, i, s2 from vectortab2korc_n5 order by s, i, s2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_n5 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_reduce3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_reduce3.q.out b/ql/src/test/results/clientpositive/llap/vector_reduce3.q.out index e26c8b2..0fdf539 100644 --- a/ql/src/test/results/clientpositive/llap/vector_reduce3.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_reduce3.q.out @@ -104,9 +104,13 @@ POSTHOOK: Lineage: vectortab2korc_n2.ts2 SIMPLE [(vectortab2k_n2)vectortab2k_n2. PREHOOK: query: explain vectorization expression select s from vectortab2korc_n2 order by s PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select s from vectortab2korc_n2 order by s POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_n2 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_decimal.q.out b/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_decimal.q.out index b241f30..abd2643 100644 --- a/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_decimal.q.out @@ -21,6 +21,8 @@ GROUP BY cint, cdouble, cdecimal1, cdecimal2 ORDER BY cint, cdouble, cdecimal1, cdecimal2 LIMIT 50 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_test_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cint, cdouble, cdecimal1, cdecimal2, min(cdecimal1) as min_decimal1 FROM decimal_test_n2 WHERE cdecimal1 is not null and cdecimal2 is not null @@ -28,6 +30,8 @@ GROUP BY cint, cdouble, cdecimal1, cdecimal2 ORDER BY cint, cdouble, cdecimal1, cdecimal2 LIMIT 50 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_test_n2 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_duplicate_cols.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_duplicate_cols.q.out b/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_duplicate_cols.q.out index bda96da..bc2bf05 100644 --- a/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_duplicate_cols.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_reduce_groupby_duplicate_cols.q.out @@ -24,6 +24,9 @@ join (select 1 as one, 2 as two) b on a.one = b.one and a.two = b.two group by a.one, a.two, a.one PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Input: default@demo +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select one as one_0, two, one as one_1 from demo a @@ -31,6 +34,9 @@ join (select 1 as one, 2 as two) b on a.one = b.one and a.two = b.two group by a.one, a.two, a.one POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Input: default@demo +#### A masked pattern was here #### Explain PLAN VECTORIZATION: enabled: true http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_retry_failure.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_retry_failure.q.out b/ql/src/test/results/clientpositive/llap/vector_retry_failure.q.out index c2342b2..59a9196 100644 --- a/ql/src/test/results/clientpositive/llap/vector_retry_failure.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_retry_failure.q.out @@ -19,9 +19,13 @@ POSTHOOK: Lineage: tx_n0.f SCRIPT [] PREHOOK: query: explain vectorization expression select assert_true(1 > a) from tx_n0 group by a PREHOOK: type: QUERY +PREHOOK: Input: default@tx_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select assert_true(1 > a) from tx_n0 group by a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tx_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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_reuse_scratchcols.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_reuse_scratchcols.q.out b/ql/src/test/results/clientpositive/llap/vector_reuse_scratchcols.q.out index c95d08a..da0bc43 100644 --- a/ql/src/test/results/clientpositive/llap/vector_reuse_scratchcols.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_reuse_scratchcols.q.out @@ -35,6 +35,8 @@ WHERE ((762 = cbigint) AND ((79.553 != cint) AND (cboolean2 != cboolean1))))) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT AVG(cint), (AVG(cint) + -3728), @@ -72,6 +74,8 @@ WHERE ((762 = cbigint) AND ((79.553 != cint) AND (cboolean2 != cboolean1))))) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -242,6 +246,8 @@ WHERE ((762 = cbigint) AND ((79.553 != cint) AND (cboolean2 != cboolean1))))) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT AVG(cint), (AVG(cint) + -3728), @@ -279,6 +285,8 @@ WHERE ((762 = cbigint) AND ((79.553 != cint) AND (cboolean2 != 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_string_concat.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_string_concat.q.out b/ql/src/test/results/clientpositive/llap/vector_string_concat.q.out index 38d9172..1a692f5 100644 --- a/ql/src/test/results/clientpositive/llap/vector_string_concat.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_string_concat.q.out @@ -100,11 +100,15 @@ PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT s AS `string`, CONCAT(CONCAT('|',RTRIM(CONCAT(CONCAT(' ',s),' '))),'|') AS `none_z_rtrim_str` FROM over1korc LIMIT 20 PREHOOK: type: QUERY +PREHOOK: Input: default@over1korc +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT s AS `string`, CONCAT(CONCAT(' ',s),' ') AS `none_padded_str`, CONCAT(CONCAT('|',RTRIM(CONCAT(CONCAT(' ',s),' '))),'|') AS `none_z_rtrim_str` FROM over1korc LIMIT 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1korc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -312,6 +316,8 @@ SELECT CONCAT(CONCAT(CONCAT('Quarter ',CAST(CAST((MONTH(dt) - 1) / 3 + 1 AS INT) ORDER BY `field` LIMIT 50 PREHOOK: type: QUERY +PREHOOK: Input: default@vectortab2korc_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT CONCAT(CONCAT(CONCAT('Quarter ',CAST(CAST((MONTH(dt) - 1) / 3 + 1 AS INT) AS STRING)),'-'),CAST(YEAR(dt) AS STRING)) AS `field` FROM vectortab2korc_n0 @@ -319,6 +325,8 @@ SELECT CONCAT(CONCAT(CONCAT('Quarter ',CAST(CAST((MONTH(dt) - 1) / 3 + 1 AS INT) ORDER BY `field` LIMIT 50 POSTHOOK: type: QUERY +POSTHOOK: Input: default@vectortab2korc_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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_string_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_string_decimal.q.out b/ql/src/test/results/clientpositive/llap/vector_string_decimal.q.out index ff84fe8..aa0abe1 100644 --- a/ql/src/test/results/clientpositive/llap/vector_string_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_string_decimal.q.out @@ -43,9 +43,13 @@ POSTHOOK: Lineage: orc_decimal.id SIMPLE [(staging_n1)staging_n1.FieldSchema(nam PREHOOK: query: explain vectorization expression select * from orc_decimal where id in ('100000000', '200000000') PREHOOK: type: QUERY +PREHOOK: Input: default@orc_decimal +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from orc_decimal where id in ('100000000', '200000000') POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_decimal +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/vector_struct_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_struct_in.q.out b/ql/src/test/results/clientpositive/llap/vector_struct_in.q.out index 671d020..f1cc7dd 100644 --- a/ql/src/test/results/clientpositive/llap/vector_struct_in.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_struct_in.q.out @@ -30,6 +30,8 @@ struct('nine','1'), struct('ten','1') ) PREHOOK: type: QUERY +PREHOOK: Input: default@test_1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from test_1_n1 where struct(`id`, `lineid`) IN ( @@ -44,6 +46,8 @@ struct('nine','1'), struct('ten','1') ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -153,6 +157,8 @@ struct('nine','1'), struct('ten','1') ) as b from test_1_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@test_1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select `id`, `lineid`, struct(`id`, `lineid`) IN ( @@ -167,6 +173,8 @@ struct('nine','1'), struct('ten','1') ) as b from test_1_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -288,6 +296,8 @@ struct(9,1), struct(10,1) ) PREHOOK: type: QUERY +PREHOOK: Input: default@test_2_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from test_2_n1 where struct(`id`, `lineid`) IN ( @@ -302,6 +312,8 @@ struct(9,1), struct(10,1) ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_2_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -411,6 +423,8 @@ struct(9,1), struct(10,1) ) as b from test_2_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@test_2_n1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select `id`, `lineid`, struct(`id`, `lineid`) IN ( @@ -425,6 +439,8 @@ struct(9,1), struct(10,1) ) as b from test_2_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_2_n1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -546,6 +562,8 @@ struct('nine',1), struct('ten',1) ) PREHOOK: type: QUERY +PREHOOK: Input: default@test_3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from test_3 where struct(`id`, `lineid`) IN ( @@ -560,6 +578,8 @@ struct('nine',1), struct('ten',1) ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -669,6 +689,8 @@ struct('nine',1), struct('ten',1) ) as b from test_3 PREHOOK: type: QUERY +PREHOOK: Input: default@test_3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select `id`, `lineid`, struct(`id`, `lineid`) IN ( @@ -683,6 +705,8 @@ struct('nine',1), struct('ten',1) ) as b from test_3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -806,6 +830,8 @@ struct(1L, "a", 0.5D), struct(3L, "b", 1.5D) ) PREHOOK: type: QUERY +PREHOOK: Input: default@test_4 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select * from test_4 where struct(`my_bigint`, `my_string`, `my_double`) IN ( @@ -821,6 +847,8 @@ struct(1L, "a", 0.5D), struct(3L, "b", 1.5D) ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_4 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -932,6 +960,8 @@ struct(1L, "a", 0.5D), struct(3L, "b", 1.5D) ) as b from test_4 PREHOOK: type: QUERY +PREHOOK: Input: default@test_4 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select `my_bigint`, `my_string`, `my_double`, struct(`my_bigint`, `my_string`, `my_double`) IN ( @@ -947,6 +977,8 @@ struct(1L, "a", 0.5D), struct(3L, "b", 1.5D) ) as b from test_4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_4 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true]