http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec.q.out index 93b8655..520896c 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec.q.out @@ -125,7 +125,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col7 ASC NULLS FIRST, _col3 ASC NULLS FIRST + order by: _col7 ASC NULLS LAST, _col3 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -347,7 +347,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col7 ASC NULLS FIRST, _col4 ASC NULLS FIRST + order by: _col7 ASC NULLS LAST, _col4 ASC NULLS LAST partition by: _col5 raw input shape: window functions: @@ -570,7 +570,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col4 ASC NULLS FIRST + order by: _col4 ASC NULLS LAST partition by: _col8 raw input shape: window functions: @@ -792,7 +792,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col7 ASC NULLS FIRST, _col4 ASC NULLS FIRST + order by: _col7 ASC NULLS LAST, _col4 ASC NULLS LAST partition by: _col8 raw input shape: window functions: @@ -1014,7 +1014,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col7 ASC NULLS FIRST, _col5 DESC NULLS LAST + order by: _col7 ASC NULLS LAST, _col5 DESC NULLS LAST partition by: _col0 raw input shape: window functions: @@ -1221,7 +1221,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -1249,7 +1249,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col7 ASC NULLS FIRST + order by: _col7 ASC NULLS LAST partition by: _col8 raw input shape: window functions: @@ -1478,7 +1478,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -1506,7 +1506,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col4 ASC NULLS FIRST + order by: _col4 ASC NULLS LAST partition by: _col8 raw input shape: window functions: @@ -1751,7 +1751,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col4 ASC NULLS FIRST + order by: _col4 ASC NULLS LAST partition by: _col8 raw input shape: window functions: @@ -1958,7 +1958,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -1986,7 +1986,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST partition by: _col7 raw input shape: window functions: @@ -2124,7 +2124,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -2152,7 +2152,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST partition by: _col7 raw input shape: window functions: @@ -2290,7 +2290,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -2318,7 +2318,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST partition by: _col7 raw input shape: window functions:
http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec4.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec4.q.out index 78df440..f778872 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec4.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_windowspec4.q.out @@ -124,7 +124,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col0 ASC NULLS FIRST + order by: _col0 ASC NULLS LAST partition by: _col1 raw input shape: window functions: http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_0.q.out b/ql/src/test/results/clientpositive/llap/vectorization_0.q.out index 2de7f71..3cb9d8f 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_0.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_0.q.out @@ -130,7 +130,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -310,7 +310,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -642,7 +642,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -822,7 +822,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -1154,7 +1154,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -1334,7 +1334,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -31071,7 +31071,7 @@ STAGE PLANS: Statistics: Num rows: 300 Data size: 23550 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col1 (type: string) - null sort order: a + null sort order: z sort order: + Statistics: Num rows: 300 Data size: 23550 Basic stats: COMPLETE Column stats: COMPLETE tag: -1 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_12.q.out b/ql/src/test/results/clientpositive/llap/vectorization_12.q.out index 7b508a0..24cd81f 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_12.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_12.q.out @@ -201,7 +201,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aaa + reduceColumnNullOrder: zzz reduceColumnSortOrder: +++ allNative: false usesVectorUDFAdaptor: false http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_13.q.out b/ql/src/test/results/clientpositive/llap/vectorization_13.q.out index 56e3883..a7c8933 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_13.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_13.q.out @@ -203,7 +203,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aaaaaaaaaaaaaaaaaaaaa + reduceColumnNullOrder: zzzzzzzzzzzzzzzzzzzzz reduceColumnSortOrder: +++++++++++++++++++++ allNative: false usesVectorUDFAdaptor: false @@ -313,46 +313,46 @@ LIMIT 40 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL -55 1969-12-31 16:00:11.38 -55.0 NULL 55 -55 0 -55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0 0.47781818181818186 -55.0 0.0 -55 -NULL -55 1969-12-31 16:00:11.751 -55.0 NULL 55 -55 0 -55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0 0.47781818181818186 -55.0 0.0 -55 -NULL -56 1969-12-31 16:00:13.602 -56.0 NULL 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 -NULL -56 1969-12-31 16:00:13.958 -56.0 NULL 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 -NULL -56 1969-12-31 16:00:15.038 -56.0 NULL 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 -NULL -57 1969-12-31 16:00:11.451 -57.0 NULL 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 -NULL -57 1969-12-31 16:00:11.883 -57.0 NULL 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 -NULL -57 1969-12-31 16:00:12.626 -57.0 NULL 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 -NULL -57 1969-12-31 16:00:13.578 -57.0 NULL 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 -NULL -57 1969-12-31 16:00:15.39 -57.0 NULL 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 -NULL -58 1969-12-31 16:00:12.065 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 -NULL -58 1969-12-31 16:00:12.683 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 -NULL -58 1969-12-31 16:00:12.948 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 -NULL -58 1969-12-31 16:00:14.066 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 -NULL -58 1969-12-31 16:00:15.658 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 -NULL -59 1969-12-31 16:00:12.008 -59.0 NULL 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 -NULL -59 1969-12-31 16:00:13.15 -59.0 NULL 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 -NULL -59 1969-12-31 16:00:13.625 -59.0 NULL 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 -NULL -59 1969-12-31 16:00:15.296 -59.0 NULL 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 -NULL -59 1969-12-31 16:00:15.861 -59.0 NULL 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 -NULL -60 1969-12-31 16:00:11.504 -60.0 NULL 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 -NULL -60 1969-12-31 16:00:11.641 -60.0 NULL 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 -NULL -60 1969-12-31 16:00:11.996 -60.0 NULL 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 -NULL -60 1969-12-31 16:00:12.779 -60.0 NULL 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 -NULL -61 1969-12-31 16:00:11.842 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:12.454 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:14.192 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:16.558 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -62 1969-12-31 16:00:12.388 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:12.591 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.154 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.247 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.517 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.965 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -63 1969-12-31 16:00:11.946 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:12.188 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -64 1969-12-31 16:00:11.912 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:12.339 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:13.274 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -55 1969-12-31 16:00:12.297 -55.0 1cGVWH7n1QU 55 -55 0 -55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0 0.47781818181818186 -55.0 0.0 -55 +true -55 1969-12-31 16:00:13.15 -55.0 1cGVWH7n1QU 55 -55 0 -55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0 0.47781818181818186 -55.0 0.0 -55 +true -56 1969-12-31 16:00:11.242 -56.0 cvLH6Eat2yFsyy7p 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 +true -56 1969-12-31 16:00:13.534 -56.0 1cGVWH7n1QU 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 +true -56 1969-12-31 16:00:14.038 -56.0 1cGVWH7n1QU 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 +true -56 1969-12-31 16:00:14.689 -56.0 cvLH6Eat2yFsyy7p 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 +true -56 1969-12-31 16:00:16.37 -56.0 cvLH6Eat2yFsyy7p 56 -56 0 -56.0 -0.0 56.0 -4454.9683 0.0 56.0 0.0 -10.175 -56.0 0.4692857142857143 -56.0 0.0 -56 +true -57 1969-12-31 16:00:11.534 -57.0 cvLH6Eat2yFsyy7p 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 +true -57 1969-12-31 16:00:13.365 -57.0 1cGVWH7n1QU 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 +true -57 1969-12-31 16:00:14.225 -57.0 821UdmGbkEf4j 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57 +true -58 1969-12-31 16:00:12.918 -58.0 cvLH6Eat2yFsyy7p 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 +true -58 1969-12-31 16:00:13.209 -58.0 cvLH6Eat2yFsyy7p 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 +true -58 1969-12-31 16:00:14.933 -58.0 cvLH6Eat2yFsyy7p 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58 +true -59 1969-12-31 16:00:11.065 -59.0 821UdmGbkEf4j 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:11.109 -59.0 1cGVWH7n1QU 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:11.231 -59.0 821UdmGbkEf4j 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:11.758 -59.0 821UdmGbkEf4j 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:12.227 -59.0 cvLH6Eat2yFsyy7p 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:15.242 -59.0 821UdmGbkEf4j 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:15.278 -59.0 cvLH6Eat2yFsyy7p 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:16.069 -59.0 cvLH6Eat2yFsyy7p 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -59 1969-12-31 16:00:16.125 -59.0 cvLH6Eat2yFsyy7p 59 -59 0 -59.0 -0.0 59.0 -4693.627 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59 +true -60 1969-12-31 16:00:11.849 -60.0 1cGVWH7n1QU 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 +true -60 1969-12-31 16:00:12.223 -60.0 1cGVWH7n1QU 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 +true -60 1969-12-31 16:00:12.291 -60.0 821UdmGbkEf4j 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 +true -60 1969-12-31 16:00:13.567 -60.0 821UdmGbkEf4j 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 +true -60 1969-12-31 16:00:15.188 -60.0 cvLH6Eat2yFsyy7p 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 +true -60 1969-12-31 16:00:16.165 -60.0 cvLH6Eat2yFsyy7p 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60 +true -61 1969-12-31 16:00:12.045 -61.0 1cGVWH7n1QU 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:12.75 -61.0 cvLH6Eat2yFsyy7p 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:15.325 -61.0 821UdmGbkEf4j 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:15.694 -61.0 cvLH6Eat2yFsyy7p 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -62 1969-12-31 16:00:13.677 -62.0 cvLH6Eat2yFsyy7p 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:14.872 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:15.153 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -63 1969-12-31 16:00:13.752 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:14.899 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:15.827 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -64 1969-12-31 16:00:11.952 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:12.857 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cboolean1, ctinyint, @@ -643,43 +643,43 @@ LIMIT 40 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL -61 1969-12-31 16:00:00.142 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:02.698 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:03.049 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:04.165 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -61 1969-12-31 16:00:04.977 -61.0 NULL 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 -NULL -62 1969-12-31 16:00:00.037 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:01.22 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:01.515 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:01.734 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:02.373 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:03.85 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:08.198 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:09.025 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:09.889 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:10.069 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:10.225 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:10.485 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:12.388 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:12.591 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.154 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.247 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.517 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -62 1969-12-31 16:00:14.965 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 -NULL -63 1969-12-31 16:00:01.843 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:03.552 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:06.852 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:07.375 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:10.205 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:11.946 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:12.188 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 -NULL -64 1969-12-31 16:00:00.199 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:00.29 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:01.785 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:03.944 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:05.997 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:10.858 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:11.912 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:12.339 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 -NULL -64 1969-12-31 16:00:13.274 -64.0 NULL 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -61 1969-12-31 16:00:00.554 -61.0 1cGVWH7n1QU 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:02.339 -61.0 cvLH6Eat2yFsyy7p 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:02.497 -61.0 cvLH6Eat2yFsyy7p 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:03.742 -61.0 1cGVWH7n1QU 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:07.538 -61.0 821UdmGbkEf4j 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:09.809 -61.0 1cGVWH7n1QU 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:10.713 -61.0 cvLH6Eat2yFsyy7p 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:12.045 -61.0 1cGVWH7n1QU 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -61 1969-12-31 16:00:12.75 -61.0 cvLH6Eat2yFsyy7p 61 -61 0 -61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0 0.4308196721311476 -61.0 0.0 -61 +true -62 1969-12-31 16:00:00.337 -62.0 1cGVWH7n1QU 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:00.659 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:00.684 -62.0 cvLH6Eat2yFsyy7p 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:01.419 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:02.123 -62.0 1cGVWH7n1QU 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:02.922 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:04.978 -62.0 cvLH6Eat2yFsyy7p 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:07.756 -62.0 1cGVWH7n1QU 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:07.847 -62.0 cvLH6Eat2yFsyy7p 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:07.903 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:13.677 -62.0 cvLH6Eat2yFsyy7p 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:14.872 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -62 1969-12-31 16:00:15.153 -62.0 821UdmGbkEf4j 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62 +true -63 1969-12-31 16:00:05.654 -63.0 821UdmGbkEf4j 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:07.623 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:09.14 -63.0 821UdmGbkEf4j 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:13.752 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:14.899 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -63 1969-12-31 16:00:15.827 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63 +true -64 1969-12-31 15:59:58.959 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:00.013 -64.0 1cGVWH7n1QU 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:00.172 -64.0 1cGVWH7n1QU 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:00.631 -64.0 1cGVWH7n1QU 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:01.305 -64.0 cvLH6Eat2yFsyy7p 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:01.79 -64.0 1cGVWH7n1QU 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:02.496 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:03.088 -64.0 cvLH6Eat2yFsyy7p 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:04.662 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:10.273 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:11.952 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 +true -64 1969-12-31 16:00:12.857 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_14.q.out b/ql/src/test/results/clientpositive/llap/vectorization_14.q.out index 6f99dde..b62fc3b 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_14.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_14.q.out @@ -203,7 +203,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aaaa + reduceColumnNullOrder: zzzz reduceColumnSortOrder: ++++ allNative: false usesVectorUDFAdaptor: false http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_17.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_17.q.out b/ql/src/test/results/clientpositive/llap/vectorization_17.q.out index 4d5f2e5..406c6a4 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_17.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_17.q.out @@ -119,7 +119,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: zz reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_7.q.out b/ql/src/test/results/clientpositive/llap/vectorization_7.q.out index 19e39c8..75c0bbd 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_7.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_7.q.out @@ -125,7 +125,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aaaaaaaaaaaaaaa + reduceColumnNullOrder: zzzzzzzzzzzzzzz reduceColumnSortOrder: +++++++++++++++ allNative: false usesVectorUDFAdaptor: false @@ -223,31 +223,31 @@ LIMIT 25 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL -2118149242 -7196 56 1969-12-31 15:59:50.462 NULL -4236298484 0 7196 -56 -39 -15242201945432 NULL -56 0 -NULL -2121399625 -7196 27 1969-12-31 15:59:50.046 NULL -4242799250 0 7196 -27 -10 -15265591701500 NULL -27 0 -NULL -2124802690 -7196 -6 1969-12-31 15:59:57.92 NULL -4249605380 0 7196 6 23 -15290080157240 NULL 6 0 -NULL -2128720310 -7196 -52 1969-12-31 15:59:45.978 NULL -4257440620 0 7196 52 69 -15318271350760 NULL 52 0 -NULL -2132232110 -200 60 1969-12-31 15:59:47.019 NULL -4264464220 -200 200 -60 -43 -426446422000 NULL -60 0 -NULL -2132536965 -7196 9 1969-12-31 15:59:46 NULL -4265073930 0 7196 -9 8 -15345736000140 NULL -9 0 -NULL -2135141157 -7196 50 1969-12-31 15:59:50.192 NULL -4270282314 0 7196 -50 -33 -15364475765772 NULL -50 0 -NULL -2137537679 -7196 -25 1969-12-31 15:59:50.136 NULL -4275075358 0 7196 25 42 -15381721138084 NULL 25 0 -NULL -2145481991 -7196 56 1969-12-31 15:59:55.667 NULL -4290963982 0 7196 -56 -39 -15438888407236 NULL -56 0 -NULL NULL -200 -36 1969-12-31 15:59:57.241 NULL NULL -200 200 36 53 NULL NULL 36 0 -NULL NULL -200 -43 1969-12-31 15:59:53.783 NULL NULL -200 200 43 60 NULL NULL 43 0 -NULL NULL -200 -58 1969-12-31 15:59:51.115 NULL NULL -200 200 58 75 NULL NULL 58 0 -NULL NULL -200 22 1969-12-31 15:59:50.109 NULL NULL -200 200 -22 -5 NULL NULL -22 0 -NULL NULL -200 3 1969-12-31 15:59:50.489 NULL NULL -200 200 -3 14 NULL NULL -3 0 -NULL NULL -200 43 1969-12-31 15:59:57.003 NULL NULL -200 200 -43 -26 NULL NULL -43 0 -NULL NULL -200 53 1969-12-31 15:59:49.46 NULL NULL -200 200 -53 -36 NULL NULL -53 0 -NULL NULL -200 9 1969-12-31 15:59:44.108 NULL NULL -200 200 -9 8 NULL NULL -9 0 -NULL NULL -7196 -38 1969-12-31 15:59:53.503 NULL NULL 0 7196 38 55 NULL NULL 38 0 -NULL NULL -7196 -49 1969-12-31 15:59:51.009 NULL NULL 0 7196 49 66 NULL NULL 49 0 -NULL NULL -7196 -49 1969-12-31 15:59:52.052 NULL NULL 0 7196 49 66 NULL NULL 49 0 -NULL NULL -7196 -50 1969-12-31 15:59:52.424 NULL NULL 0 7196 50 67 NULL NULL 50 0 -NULL NULL -7196 -61 1969-12-31 15:59:44.823 NULL NULL 0 7196 61 78 NULL NULL 61 0 -NULL NULL -7196 1 1969-12-31 15:59:48.361 NULL NULL 0 7196 -1 16 NULL NULL -1 0 -NULL NULL -7196 14 1969-12-31 15:59:50.291 NULL NULL 0 7196 -14 3 NULL NULL -14 0 -NULL NULL -7196 22 1969-12-31 15:59:52.699 NULL NULL 0 7196 -22 -5 NULL NULL -22 0 +true NULL -15892 29 1969-12-31 15:59:57.937 821UdmGbkEf4j NULL -215 15892 -29 -12 NULL 171 -29 0 +true NULL -15899 50 1969-12-31 15:59:46.926 821UdmGbkEf4j NULL -222 15899 -50 -33 NULL 10210 -50 0 +true NULL -15903 -2 1969-12-31 15:59:46.371 cvLH6Eat2yFsyy7p NULL -226 15903 2 19 NULL 14465 2 0 +true NULL -15920 -64 1969-12-31 15:59:51.859 cvLH6Eat2yFsyy7p NULL -243 15920 64 81 NULL 6687 64 0 +true NULL -15922 -17 1969-12-31 15:59:46.164 821UdmGbkEf4j NULL -245 15922 17 34 NULL 10851 17 0 +true NULL -15923 49 1969-12-31 15:59:47.323 cvLH6Eat2yFsyy7p NULL -246 15923 -49 -32 NULL 2628 -49 0 +true NULL -15935 -6 1969-12-31 15:59:45.859 1cGVWH7n1QU NULL -1 15935 6 23 NULL 12046 6 0 +true NULL -15948 31 1969-12-31 15:59:47.577 821UdmGbkEf4j NULL -14 15948 -31 -14 NULL 7799 -31 0 +true NULL -15948 6 1969-12-31 15:59:49.269 1cGVWH7n1QU NULL -14 15948 -6 11 NULL 12436 -6 0 +true NULL -15980 -6 1969-12-31 15:59:54.84 1cGVWH7n1QU NULL -46 15980 6 23 NULL 14836 6 0 +true NULL -15999 4 1969-12-31 15:59:46.491 1cGVWH7n1QU NULL -65 15999 -4 13 NULL 1231 -4 0 +true NULL -16017 -21 1969-12-31 15:59:44.02 821UdmGbkEf4j NULL -83 16017 21 38 NULL 2282 21 0 +true NULL -16025 -42 1969-12-31 15:59:54.534 cvLH6Eat2yFsyy7p NULL -91 16025 42 59 NULL 14242 42 0 +true NULL -16036 -15 1969-12-31 15:59:58.681 1cGVWH7n1QU NULL -102 16036 15 32 NULL 7928 15 0 +true NULL -16059 -35 1969-12-31 15:59:53.038 821UdmGbkEf4j NULL -125 16059 35 52 NULL 12437 35 0 +true NULL -16076 59 1969-12-31 15:59:55.023 821UdmGbkEf4j NULL -142 16076 -59 -42 NULL 7907 -59 0 +true NULL -16122 50 1969-12-31 15:59:51.608 1cGVWH7n1QU NULL -188 16122 -50 -33 NULL 1828 -50 0 +true NULL -16123 -20 1969-12-31 15:59:51.177 1cGVWH7n1QU NULL -189 16123 20 37 NULL 2217 20 0 +true NULL -16153 35 1969-12-31 15:59:52.036 1cGVWH7n1QU NULL -219 16153 -35 -18 NULL 14817 -35 0 +true NULL -16169 5 1969-12-31 15:59:45.059 1cGVWH7n1QU NULL -235 16169 -5 12 NULL 6104 -5 0 +true NULL -16207 -4 1969-12-31 15:59:45.956 cvLH6Eat2yFsyy7p NULL -16 16207 4 21 NULL 8290 4 0 +true NULL -16221 -12 1969-12-31 15:59:45.877 1cGVWH7n1QU NULL -30 16221 12 29 NULL 1378 12 0 +true NULL -16227 2 1969-12-31 15:59:44.065 821UdmGbkEf4j NULL -36 16227 -2 15 NULL 9761 -2 0 +true NULL -16305 3 1969-12-31 15:59:43.878 1cGVWH7n1QU NULL -114 16305 -3 14 NULL 8491 -3 0 +true NULL -16339 15 1969-12-31 15:59:53.966 821UdmGbkEf4j NULL -148 16339 -15 2 NULL 12588 -15 0 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cboolean1, cbigint, http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_8.q.out b/ql/src/test/results/clientpositive/llap/vectorization_8.q.out index 3a09542..5bb2809 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_8.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_8.q.out @@ -121,7 +121,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aaaaaaaaaaaaaa + reduceColumnNullOrder: zzzzzzzzzzzzzz reduceColumnSortOrder: ++++++++++++++ allNative: false usesVectorUDFAdaptor: false http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_div0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_div0.q.out b/ql/src/test/results/clientpositive/llap/vectorization_div0.q.out index 8f4acba..2ba1a4c 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_div0.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_div0.q.out @@ -111,106 +111,106 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### cint cint_div ctinyint ctinyint_div cbigint cbigint_div cdouble cdouble_div -NULL NULL -60 NULL -1016256928 NULL 15601.0 NULL -NULL NULL -60 NULL -1062217466 NULL -200.0 NULL -NULL NULL -60 NULL -1183915345 NULL -7196.0 NULL -NULL NULL -60 NULL -126921733 NULL -200.0 NULL -NULL NULL -60 NULL -1445021496 NULL -200.0 NULL -NULL NULL -60 NULL -1690528981 NULL -200.0 NULL -NULL NULL -60 NULL -1743144280 NULL 15601.0 NULL -NULL NULL -60 NULL -1802243330 NULL -7196.0 NULL -NULL NULL -60 NULL -1860186661 NULL -200.0 NULL -NULL NULL -60 NULL -2041965187 NULL 15601.0 NULL -NULL NULL -60 NULL -483910982 NULL -200.0 NULL -NULL NULL -60 NULL -508015343 NULL -200.0 NULL -NULL NULL -60 NULL -519753851 NULL 15601.0 NULL -NULL NULL -60 NULL -5953872 NULL 15601.0 NULL -NULL NULL -60 NULL -68838726 NULL -7196.0 NULL -NULL NULL -60 NULL -903925845 NULL 15601.0 NULL -NULL NULL -60 NULL 1122241452 NULL 15601.0 NULL -NULL NULL -60 NULL 1172431520 NULL -200.0 NULL -NULL NULL -60 NULL 927847540 NULL -200.0 NULL -NULL NULL -60 NULL NULL NULL -200.0 NULL -NULL NULL -61 NULL -1022679553 NULL 15601.0 NULL -NULL NULL -61 NULL -1062521098 NULL -7196.0 NULL -NULL NULL -61 NULL -1313743110 NULL -200.0 NULL -NULL NULL -61 NULL -1513172815 NULL -7196.0 NULL -NULL NULL -61 NULL -1728754595 NULL -7196.0 NULL -NULL NULL -61 NULL -1769786673 NULL -200.0 NULL -NULL NULL -61 NULL -2114172148 NULL -7196.0 NULL -NULL NULL -61 NULL -2175533 NULL -7196.0 NULL -NULL NULL -61 NULL -836697023 NULL -200.0 NULL -NULL NULL -61 NULL -854893578 NULL 15601.0 NULL -NULL NULL -61 NULL -982179838 NULL 15601.0 NULL -NULL NULL -61 NULL 1114673625 NULL 15601.0 NULL -NULL NULL -61 NULL 1139675920 NULL 15601.0 NULL -NULL NULL -61 NULL 1237548317 NULL -7196.0 NULL -NULL NULL -61 NULL 127734700 NULL -7196.0 NULL -NULL NULL -61 NULL 1399483216 NULL -200.0 NULL -NULL NULL -61 NULL 1415466231 NULL -7196.0 NULL -NULL NULL -61 NULL 184425274 NULL -200.0 NULL -NULL NULL -61 NULL 1977536065 NULL 15601.0 NULL -NULL NULL -61 NULL 484546535 NULL 15601.0 NULL -NULL NULL -61 NULL 623787602 NULL -200.0 NULL -NULL NULL -61 NULL 919939154 NULL 15601.0 NULL -NULL NULL -61 NULL 943547371 NULL -7196.0 NULL -NULL NULL -61 NULL NULL NULL -7196.0 NULL -NULL NULL -61 NULL NULL NULL -7196.0 NULL -NULL NULL -62 NULL -1113073921 NULL -200.0 NULL -NULL NULL -62 NULL -1367753794 NULL -7196.0 NULL -NULL NULL -62 NULL -1592016120 NULL 15601.0 NULL -NULL NULL -62 NULL -167812632 NULL -200.0 NULL -NULL NULL -62 NULL -1726415169 NULL 15601.0 NULL -NULL NULL -62 NULL -1761785534 NULL -7196.0 NULL -NULL NULL -62 NULL -2080605724 NULL -200.0 NULL -NULL NULL -62 NULL -642836823 NULL -7196.0 NULL -NULL NULL -62 NULL -840223244 NULL -7196.0 NULL -NULL NULL -62 NULL 1221804187 NULL -200.0 NULL -NULL NULL -62 NULL 1380844570 NULL -7196.0 NULL -NULL NULL -62 NULL 1443417260 NULL -200.0 NULL -NULL NULL -62 NULL 1607712873 NULL -200.0 NULL -NULL NULL -62 NULL 1670449519 NULL -7196.0 NULL -NULL NULL -62 NULL 2071666427 NULL -200.0 NULL -NULL NULL -62 NULL 281485844 NULL 15601.0 NULL -NULL NULL -62 NULL 325025905 NULL -200.0 NULL -NULL NULL -62 NULL 667693308 NULL 15601.0 NULL -NULL NULL -62 NULL 68899019 NULL 15601.0 NULL -NULL NULL -62 NULL 726070601 NULL -200.0 NULL -NULL NULL -62 NULL 73960976 NULL 15601.0 NULL -NULL NULL -62 NULL 756424745 NULL -7196.0 NULL -NULL NULL -62 NULL 986221936 NULL -7196.0 NULL -NULL NULL -62 NULL NULL NULL -7196.0 NULL -NULL NULL -62 NULL NULL NULL -7196.0 NULL -NULL NULL -63 NULL -1167054574 NULL 15601.0 NULL -NULL NULL -63 NULL -1224023895 NULL -7196.0 NULL -NULL NULL -63 NULL -1574729892 NULL 15601.0 NULL -NULL NULL -63 NULL -1711796768 NULL -7196.0 NULL -NULL NULL -63 NULL -1996001975 NULL 15601.0 NULL -NULL NULL -63 NULL -1999307539 NULL -200.0 NULL -NULL NULL -63 NULL -200542601 NULL 15601.0 NULL -NULL NULL -63 NULL -2070832461 NULL -200.0 NULL -NULL NULL -63 NULL -721244708 NULL 15601.0 NULL -NULL NULL -63 NULL -994504916 NULL -7196.0 NULL -NULL NULL -63 NULL -997946077 NULL -200.0 NULL -NULL NULL -63 NULL 1089367203 NULL -200.0 NULL -NULL NULL -63 NULL 1927856372 NULL -200.0 NULL -NULL NULL -63 NULL 2059199534 NULL 15601.0 NULL -NULL NULL -63 NULL 483904240 NULL 15601.0 NULL -NULL NULL -63 NULL 507317726 NULL -200.0 NULL -NULL NULL -63 NULL 956380949 NULL -200.0 NULL -NULL NULL -64 NULL -1615920595 NULL -7196.0 NULL -NULL NULL -64 NULL -1639157869 NULL -7196.0 NULL -NULL NULL -64 NULL -1809291815 NULL 15601.0 NULL -NULL NULL -64 NULL -1809444706 NULL -200.0 NULL -NULL NULL -64 NULL -527203677 NULL -7196.0 NULL -NULL NULL -64 NULL 1090418478 NULL -7196.0 NULL -NULL NULL -64 NULL 1421812187 NULL 15601.0 NULL -NULL NULL -64 NULL 1805860756 NULL -7196.0 NULL -NULL NULL -64 NULL 1960950366 NULL 15601.0 NULL -NULL NULL -64 NULL 2118653994 NULL -200.0 NULL -NULL NULL -64 NULL 406535485 NULL -7196.0 NULL -NULL NULL -64 NULL 658026952 NULL -7196.0 NULL -NULL NULL -64 NULL 927647669 NULL -200.0 NULL +-1039715238 NULL -51 NULL -86361999 NULL NULL NULL +-1039762548 NULL NULL NULL -1645852809 NULL -3802.0 NULL +-1039776293 NULL NULL NULL -1645852809 NULL 13704.0 NULL +-1041252354 NULL NULL NULL -1887561756 NULL 756.0 NULL +-1041353707 NULL 11 NULL -931949639 NULL NULL NULL +-1041391389 NULL NULL NULL 1864027286 NULL -12970.0 NULL +-1041734429 NULL NULL NULL -1645852809 NULL -836.0 NULL +-1042396242 NULL NULL NULL -1887561756 NULL 9583.0 NULL +-1042712895 NULL NULL NULL -1887561756 NULL 9296.0 NULL +-1042805968 NULL NULL NULL -1887561756 NULL 5133.0 NULL +-1043082182 NULL NULL NULL -1887561756 NULL 9180.0 NULL +-1043132597 NULL NULL NULL -1887561756 NULL 12302.0 NULL +-1043573508 NULL NULL NULL 1864027286 NULL 16216.0 NULL +-1043979188 NULL 11 NULL -8894336 NULL NULL NULL +-1044093617 NULL NULL NULL -1887561756 NULL -3422.0 NULL +-1044207190 NULL NULL NULL -1645852809 NULL 5381.0 NULL +-1044357977 NULL 11 NULL -1392575676 NULL NULL NULL +-1044748460 NULL -51 NULL 538703088 NULL NULL NULL +-1044828205 NULL -51 NULL -1627128549 NULL NULL NULL +-1045087657 NULL NULL NULL -1645852809 NULL -5865.0 NULL +-1045181724 NULL NULL NULL -1887561756 NULL -5706.0 NULL +-1045196363 NULL NULL NULL -1887561756 NULL -5039.0 NULL +-1045737053 NULL 8 NULL -1286738860 NULL NULL NULL +-1045867222 NULL NULL NULL -1887561756 NULL -8034.0 NULL +-1046399794 NULL NULL NULL -1887561756 NULL 4130.0 NULL +-1046766350 NULL 8 NULL -1069616395 NULL NULL NULL +-1046913669 NULL 8 NULL -90393132 NULL NULL NULL +-1047036113 NULL 11 NULL -240113848 NULL NULL NULL +-1047782718 NULL 11 NULL -1527855515 NULL NULL NULL +-1048097158 NULL 11 NULL -234579722 NULL NULL NULL +-1048696030 NULL 11 NULL -1554184139 NULL NULL NULL +-1048934049 NULL NULL NULL -1887561756 NULL -524.0 NULL +-1049984461 NULL 8 NULL -247067895 NULL NULL NULL +-1050165799 NULL NULL NULL 1864027286 NULL 8634.0 NULL +-1050388484 NULL 8 NULL 987404155 NULL NULL NULL +-1050657303 NULL NULL NULL -1645852809 NULL -6999.0 NULL +-1050684541 NULL NULL NULL -1887561756 NULL -8261.0 NULL +-1051223597 NULL 11 NULL -1074802968 NULL NULL NULL +-1052322972 NULL NULL NULL -1645852809 NULL -7433.0 NULL +-1052668265 NULL 8 NULL 1712280188 NULL NULL NULL +-1052745800 NULL NULL NULL -1645852809 NULL -12404.0 NULL +-1053238077 NULL NULL NULL -1645852809 NULL -3704.0 NULL +-1053254526 NULL 11 NULL 1704531790 NULL NULL NULL +-1053385587 NULL NULL NULL -1645852809 NULL 14504.0 NULL +-1054849160 NULL 11 NULL -1027630923 NULL NULL NULL +-1054958082 NULL 8 NULL 762300991 NULL NULL NULL +-1055040773 NULL -51 NULL 1331071870 NULL NULL NULL +-1055076545 NULL 11 NULL 542002983 NULL NULL NULL +-1055185482 NULL 11 NULL -398806473 NULL NULL NULL +-1055316250 NULL NULL NULL -1887561756 NULL -14990.0 NULL +-1055669248 NULL NULL NULL 1864027286 NULL 2570.0 NULL +-1055945837 NULL NULL NULL -1645852809 NULL 13690.0 NULL +-1056684111 NULL NULL NULL 1864027286 NULL 13991.0 NULL +-1058286942 NULL 8 NULL -922041114 NULL NULL NULL +-1058844180 NULL -51 NULL 822773337 NULL NULL NULL +-1058897881 NULL 8 NULL -800997317 NULL NULL NULL +-1059047258 NULL NULL NULL 1864027286 NULL 12452.0 NULL +-1059338191 NULL NULL NULL 1864027286 NULL 7322.0 NULL +-1059487309 NULL 8 NULL 1632546080 NULL NULL NULL +-1059941909 NULL NULL NULL -1887561756 NULL 8782.0 NULL +-1060624784 NULL -51 NULL -941434751 NULL NULL NULL +-1060670281 NULL 11 NULL -1705503157 NULL NULL NULL +-1060990068 NULL 11 NULL 960036652 NULL NULL NULL +-1061057428 NULL NULL NULL -1887561756 NULL -1085.0 NULL +-1061509617 NULL 8 NULL 453428995 NULL NULL NULL +-1061614989 NULL NULL NULL 1864027286 NULL -4234.0 NULL +-1062973443 NULL NULL NULL -1645852809 NULL 10541.0 NULL +-1063164541 NULL 8 NULL -74907656 NULL NULL NULL +-1063498122 NULL NULL NULL 1864027286 NULL -11480.0 NULL +-1063745167 NULL 8 NULL -68741114 NULL NULL NULL +-1064623720 NULL 11 NULL -1894858490 NULL NULL NULL +-1064718136 NULL -51 NULL 156403402 NULL NULL NULL +-1064949302 NULL NULL NULL -1645852809 NULL 6454.0 NULL +-1064981602 NULL -51 NULL -1444011153 NULL NULL NULL +-1065117869 NULL NULL NULL -1887561756 NULL 2538.0 NULL +-1065775394 NULL -51 NULL -1331703092 NULL NULL NULL +-1066226047 NULL NULL NULL 1864027286 NULL -9439.0 NULL +-1066684273 NULL -51 NULL 2034191923 NULL NULL NULL +-1066922682 NULL NULL NULL -1645852809 NULL -9987.0 NULL +-1067386090 NULL NULL NULL -1887561756 NULL -3977.0 NULL +-1067683781 NULL -51 NULL 1750003656 NULL NULL NULL +-1067874703 NULL 11 NULL -1742615956 NULL NULL NULL +-1068206466 NULL 8 NULL 1240583144 NULL NULL NULL +-1068247011 NULL 8 NULL -729456614 NULL NULL NULL +-1068336533 NULL 11 NULL 925708299 NULL NULL NULL +-1068623584 NULL NULL NULL -1887561756 NULL -14005.0 NULL +-1069097390 NULL 11 NULL -1858556598 NULL NULL NULL +-1069103950 NULL 11 NULL -927759444 NULL NULL NULL +-1069109166 NULL NULL NULL -1645852809 NULL 8390.0 NULL +-1069512165 NULL NULL NULL -1645852809 NULL 11417.0 NULL +-1069736047 NULL 11 NULL -453772520 NULL NULL NULL +-1070551679 NULL NULL NULL 1864027286 NULL -947.0 NULL +-1070883071 NULL NULL NULL -1645852809 NULL -741.0 NULL +-1071363017 NULL 8 NULL 1349676361 NULL NULL NULL +-1071480828 NULL -51 NULL -1401575336 NULL NULL NULL +-1072076362 NULL NULL NULL 1864027286 NULL -5470.0 NULL +-1072081801 NULL NULL NULL 1864027286 NULL 8373.0 NULL +-1072910839 NULL 11 NULL 2048385991 NULL NULL NULL +-1073051226 NULL NULL NULL -1887561756 NULL -7382.0 NULL +-1073279343 NULL 11 NULL -1595604468 NULL NULL NULL PREHOOK: query: explain vectorization expression select (cbigint - 988888L) as s1, cdouble / (cbigint - 988888L) as s2, 1.2 / (cbigint - 988888L) as s3 from alltypesorc where cbigint > 0 and cbigint < 100000000 order by s1, s2, s3 limit 100 @@ -838,33 +838,33 @@ cint cbigint ctinyint c1 c2 c3 c4 c5 c6 518304665 1758550605 11 -50.66466248332617 2.3752809176800223 1.0 6799565 277841025 0 519195191 301311742 8 -55.590873825535546 -0.42030748533591705 1.0 5518511 301311742 0 519627078 -1887561756 NULL -58.334667723581276 0.6495936807799166 NULL 2981116 -1887561756 NULL -NULL -1111841132 0 NULL 0.5219820874778469 NULL NULL -1111841132 NULL -NULL -1300968933 0 NULL 0.5609644308891505 NULL NULL -1300968933 NULL -NULL -1355080830 0 NULL 0.5709746619109379 NULL NULL -1355080830 NULL -NULL -1379420228 0 NULL 0.5753299124049946 NULL NULL -1379420228 NULL -NULL -1418871864 0 NULL 0.5822045387685764 NULL NULL -1418871864 NULL -NULL -203039588 0 NULL 0.1662575351985599 NULL NULL -203039588 NULL -NULL -229832118 0 NULL 0.18415622913786178 NULL NULL -229832118 NULL -NULL -277546656 0 NULL 0.21419893397937406 NULL NULL -277546656 NULL -NULL -39854776 0 NULL 0.03766811940658894 NULL NULL -39854776 NULL -NULL -438779645 0 NULL 0.3011578829200047 NULL NULL -438779645 NULL -NULL -495480552 0 NULL 0.32733585778445334 NULL NULL -495480552 NULL -NULL -741129356 0 NULL 0.42125774599060745 NULL NULL -741129356 NULL -NULL -901264012 0 NULL 0.46954044013967267 NULL NULL -901264012 NULL -NULL 1018195815 0 NULL NULL NULL NULL NULL NULL -NULL 1049949527 0 NULL 33.065410651831826 NULL NULL 2077031 NULL -NULL 10989626 0 NULL -0.010910999277030852 NULL NULL 10989626 NULL -NULL 1561097160 0 NULL 2.87547115949768 NULL NULL 475294470 NULL -NULL 1580847931 0 NULL 2.8096365161452623 NULL NULL 455543699 NULL -NULL 1585496199 0 NULL 2.794808964909849 NULL NULL 450895431 NULL -NULL 1638241933 0 NULL 2.6421291665920887 NULL NULL 398149697 NULL -NULL 1738765387 0 NULL 2.413043035072816 NULL NULL 297626243 NULL -NULL 1907356119 0 NULL 2.145120638449015 NULL NULL 129035511 NULL -NULL 2136716416 0 NULL 1.9103058218951838 NULL NULL 1018195815 NULL -NULL 2144209609 0 NULL 1.904248083305452 NULL NULL 1018195815 NULL -NULL 406548885 0 NULL -0.6646790248746937 NULL NULL 406548885 NULL -NULL 473839931 0 NULL -0.8704598313848666 NULL NULL 473839931 NULL -NULL 53950949 0 NULL -0.05595150246825374 NULL NULL 53950949 NULL -NULL 618557893 0 NULL -1.5477957895096852 NULL NULL 218919971 NULL -NULL 738226024 0 NULL -2.636805997401341 NULL NULL 178286442 NULL -NULL 98841361 0 NULL -0.10751170081349277 NULL NULL 98841361 NULL +520081159 -1827280551 8 -61.52179743844285 0.6421703489910483 1.0 4411071 -1827280551 0 +520374125 59296415 8 -63.76632193888667 -0.0618379936414602 1.0 6253679 59296415 0 +520630560 275901824 -51 -65.86752598964071 -0.3716880741932343 1.0 6857105 275901824 0 +520879263 -1480800353 11 -68.03983944100872 0.5925580727020947 1.0 304991 -1480800353 0 +521019755 -1909738698 11 -69.33052868045986 0.6522477499140705 1.0 2483927 -1909738698 0 +521080737 -1918433146 8 -69.90590821340939 0.65327733652355 1.0 6752667 -1918433146 0 +521249276 -1887561756 NULL -71.54621095544556 0.6495936807799166 NULL 3979415 -1887561756 NULL +521256931 1864027286 NULL -71.62251677559098 2.2037809539011586 NULL 4530575 172364344 NULL +521315946 -986052008 11 -72.21621730196662 0.49198107972698546 1.0 1560834 -986052008 0 +521389499 -112901465 -51 -72.96990105899457 0.099815875253453 1.0 6930203 -112901465 0 +521504167 -1645852809 NULL -74.17633871931272 0.6178013397250965 NULL 1239767 -1645852809 NULL +522187830 -1887561756 NULL -82.27398980011934 0.6495936807799166 NULL 1738996 -1887561756 NULL +522957489 -1645852809 NULL -93.76572030298651 0.6178013397250965 NULL 4270635 -1645852809 NULL +523172866 -1928034601 11 -97.57227259511133 0.654407269210678 1.0 3068469 -1928034601 0 +523369608 634246195 -51 -101.32691133031916 -1.651899525255423 1.0 1688549 250296575 0 +523396209 -1887561756 NULL -101.85663156862294 0.6495936807799166 NULL 4401851 -1887561756 NULL +524224864 -801085374 -51 -121.63263627974922 0.44033070799810264 1.0 2726601 -801085374 0 +524852698 -942817737 11 -142.54287412864886 0.48078083705155344 1.0 1998900 -942817737 0 +525437671 752506166 11 -169.6549512833958 -2.832275057881536 1.0 2028447 221126868 0 +525640312 -1887561756 NULL -181.60251653592817 0.6495936807799166 NULL 1743957 -1887561756 NULL +525718152 -1624826596 8 -186.6489214890924 0.6147608091545615 1.0 1827762 -1624826596 0 +525955379 -1645852809 NULL -203.90704267834076 0.6178013397250965 NULL 2339615 -1645852809 NULL +526337887 1864027286 NULL -239.5842681439132 2.2037809539011586 NULL 1283567 172364344 NULL +527127072 1864027286 NULL -374.4611382437247 2.2037809539011586 NULL 649142 172364344 NULL +527187434 -1645852809 NULL -391.2822101143518 0.6178013397250965 NULL 380231 -1645852809 NULL +527554807 1864027286 NULL -538.3432048246867 2.2037809539011586 NULL 336327 172364344 NULL +528023644 1864027286 NULL -1033.0657082541775 2.2037809539011586 NULL 33585 172364344 NULL +528393062 -1131246885 -51 -3728.824402808652 0.5262977631364633 1.0 116822 -1131246885 0 +528534767 NULL -64 NULL NULL 1.0 NULL NULL 0 +528534767 NULL -64 NULL NULL 1.0 NULL NULL 0 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_limit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_limit.q.out b/ql/src/test/results/clientpositive/llap/vectorization_limit.q.out index 6848331..a5b6cd0 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_limit.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_limit.q.out @@ -173,7 +173,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aaa + reduceColumnNullOrder: zzz reduceColumnSortOrder: +++ allNative: false usesVectorUDFAdaptor: false @@ -381,7 +381,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: zz reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -431,6 +431,7 @@ POSTHOOK: query: select ctinyint,avg(cdouble + 1) as cavg from alltypesorc group POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### +-45 326.44444444444446 -46 3033.55 -47 -574.6428571428571 -48 1672.909090909091 @@ -450,7 +451,6 @@ POSTHOOK: Input: default@alltypesorc -62 245.69387755102042 -63 2178.7272727272725 -64 373.52941176470586 -NULL 9370.0945309795 PREHOOK: query: explain vectorization detail select distinct(ctinyint) as cdistinct from alltypesorc order by cdistinct limit 20 PREHOOK: type: QUERY @@ -545,7 +545,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: a + reduceColumnNullOrder: z reduceColumnSortOrder: + allNative: false usesVectorUDFAdaptor: false @@ -599,6 +599,7 @@ POSTHOOK: query: select distinct(ctinyint) as cdistinct from alltypesorc order b POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### +-45 -46 -47 -48 @@ -618,7 +619,6 @@ POSTHOOK: Input: default@alltypesorc -62 -63 -64 -NULL PREHOOK: query: explain vectorization detail select ctinyint, count(distinct(cdouble)) as count_distinct from alltypesorc group by ctinyint order by ctinyint, count_distinct limit 20 PREHOOK: type: QUERY @@ -757,7 +757,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: zz reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -807,6 +807,7 @@ POSTHOOK: query: select ctinyint, count(distinct(cdouble)) as count_distinct fro POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### +-45 24 -46 24 -47 22 -48 29 @@ -826,7 +827,6 @@ POSTHOOK: Input: default@alltypesorc -62 27 -63 19 -64 24 -NULL 2932 PREHOOK: query: explain vectorization detail select ctinyint,cdouble from alltypesorc order by ctinyint,cdouble limit 0 PREHOOK: type: QUERY @@ -982,7 +982,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: zz reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_part_project.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorization_part_project.q.out b/ql/src/test/results/clientpositive/llap/vectorization_part_project.q.out index 89c140e..dd1f20f 100644 --- a/ql/src/test/results/clientpositive/llap/vectorization_part_project.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorization_part_project.q.out @@ -70,7 +70,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_part - Statistics: Num rows: 200 Data size: 1592 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 200 Data size: 1600 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: (cdouble + 2.0D) (type: double) outputColumnNames: _col0 @@ -133,13 +133,13 @@ POSTHOOK: Input: default@alltypesorc_part POSTHOOK: Input: default@alltypesorc_part@ds=2011 POSTHOOK: Input: default@alltypesorc_part@ds=2012 #### A masked pattern was here #### -NULL -NULL --15863.0 --15863.0 --14988.0 --14988.0 --14646.0 --14646.0 --14236.0 --14236.0 +-15990.0 +-15990.0 +-15918.0 +-15918.0 +-15890.0 +-15890.0 +-14305.0 +-14305.0 +-12514.0 +-12514.0
