This is an automated email from the ASF dual-hosted git repository.
krisztiankasa pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new 41410affa60 HIVE-28302: Let SUM UDF return NULL when all rows have
non-numeric texts (Shohei Okumiya, reviewed by Krisztian Kasa)
41410affa60 is described below
commit 41410affa60a4fe1cece85060e3b00e54340f0fa
Author: okumin <[email protected]>
AuthorDate: Mon Jul 22 17:06:00 2024 +0900
HIVE-28302: Let SUM UDF return NULL when all rows have non-numeric texts
(Shohei Okumiya, reviewed by Krisztian Kasa)
---
.../hadoop/hive/ql/udf/generic/GenericUDAFSum.java | 6 +-
.../cbo_aggregate_reduce_functions_rule.q | 282 +-
.../llap/cbo_aggregate_reduce_functions_rule.q.out | 570 +--
.../llap/exception_in_vertex_udf.q.out | 12 +-
.../clientpositive/llap/ppd_windowing2.q.out | 3748 ++++++++++----------
.../clientpositive/llap/udaf_number_format.q.out | 2 +-
.../clientpositive/llap/windowing_distinct.q.out | 12 +-
7 files changed, 2316 insertions(+), 2316 deletions(-)
diff --git
a/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFSum.java
b/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFSum.java
index a78b5f5734d..1f6c0fee981 100644
--- a/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFSum.java
+++ b/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFSum.java
@@ -288,9 +288,9 @@ public class GenericUDAFSum extends
AbstractGenericUDAFResolver {
assert (parameters.length == 1);
try {
if (isEligibleValue((SumHiveDecimalWritableAgg) agg, parameters[0])) {
- ((SumHiveDecimalWritableAgg)agg).nonNullCount++;
((SumHiveDecimalWritableAgg)agg).sum.mutateAdd(
PrimitiveObjectInspectorUtils.getHiveDecimal(parameters[0],
inputOI));
+ ((SumHiveDecimalWritableAgg)agg).nonNullCount++;
}
} catch (NumberFormatException e) {
if (!warned) {
@@ -440,8 +440,8 @@ public class GenericUDAFSum extends
AbstractGenericUDAFResolver {
assert (parameters.length == 1);
try {
if (isEligibleValue((SumDoubleAgg) agg, parameters[0])) {
- ((SumDoubleAgg)agg).nonNullCount++;
((SumDoubleAgg)agg).sum +=
PrimitiveObjectInspectorUtils.getDouble(parameters[0], inputOI);
+ ((SumDoubleAgg)agg).nonNullCount++;
}
} catch (NumberFormatException e) {
if (!warned) {
@@ -578,8 +578,8 @@ public class GenericUDAFSum extends
AbstractGenericUDAFResolver {
assert (parameters.length == 1);
try {
if (isEligibleValue((SumLongAgg) agg, parameters[0])) {
- ((SumLongAgg)agg).nonNullCount++;
((SumLongAgg)agg).sum +=
PrimitiveObjectInspectorUtils.getLong(parameters[0], inputOI);
+ ((SumLongAgg)agg).nonNullCount++;
}
} catch (NumberFormatException e) {
if (!warned) {
diff --git
a/ql/src/test/queries/clientpositive/cbo_aggregate_reduce_functions_rule.q
b/ql/src/test/queries/clientpositive/cbo_aggregate_reduce_functions_rule.q
index 24e67c234d6..e87613c060c 100644
--- a/ql/src/test/queries/clientpositive/cbo_aggregate_reduce_functions_rule.q
+++ b/ql/src/test/queries/clientpositive/cbo_aggregate_reduce_functions_rule.q
@@ -11,55 +11,55 @@ INSERT INTO test VALUES
EXPLAIN CBO
SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -70,55 +70,55 @@ SELECT
FROM test;
SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -132,55 +132,55 @@ FROM test;
SET hive.cbo.enable=false;
SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
diff --git
a/ql/src/test/results/clientpositive/llap/cbo_aggregate_reduce_functions_rule.q.out
b/ql/src/test/results/clientpositive/llap/cbo_aggregate_reduce_functions_rule.q.out
index 20b62a7d6ff..45f839ad423 100644
---
a/ql/src/test/results/clientpositive/llap/cbo_aggregate_reduce_functions_rule.q.out
+++
b/ql/src/test/results/clientpositive/llap/cbo_aggregate_reduce_functions_rule.q.out
@@ -35,55 +35,55 @@ POSTHOOK: Lineage: test.c_non_numeric SCRIPT []
POSTHOOK: Lineage: test.c_numeric SCRIPT []
PREHOOK: query: EXPLAIN CBO
SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -97,55 +97,55 @@ PREHOOK: Input: default@test
#### A masked pattern was here ####
POSTHOOK: query: EXPLAIN CBO
SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -158,61 +158,61 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@test
#### A masked pattern was here ####
CBO PLAN:
-HiveProject(_o__c0=[round(COALESCE($0, 0E0:DOUBLE), 3)],
_o__c1=[round(COALESCE($1, 0E0:DOUBLE), 3)], _o__c2=[round(COALESCE($2,
0E0:DOUBLE), 3)], _o__c3=[round(COALESCE($3, 0E0:DOUBLE), 3)],
_o__c4=[round(COALESCE($4, 0E0:DOUBLE), 3)], _o__c5=[round(COALESCE($5,
0E0:DOUBLE), 3)], _o__c6=[round(/($6, $7), 3)], _o__c7=[round(/($1, $8), 3)],
_o__c8=[round(/($9, $10), 3)], _o__c9=[round(/($3, $11), 3)],
_o__c10=[round(/($12, $13), 3)], _o__c11=[round(/($5, $14), 3)],
_o__c12=[round(POWER(/( [...]
+HiveProject(_o__c0=[COALESCE($0, 0E0:DOUBLE)], _o__c1=[COALESCE($1,
0E0:DOUBLE)], _o__c2=[COALESCE($2, 0E0:DOUBLE)], _o__c3=[COALESCE($3,
0E0:DOUBLE)], _o__c4=[COALESCE($4, 0E0:DOUBLE)], _o__c5=[COALESCE($5,
0E0:DOUBLE)], _o__c6=[/($6, $7)], _o__c7=[/($1, $8)], _o__c8=[/($9, $10)],
_o__c9=[/($3, $11)], _o__c10=[/($12, $13)], _o__c11=[/($5, $14)],
_o__c12=[POWER(/(-($15, /(*($6, $6), $7)), $7), 0.5:DECIMAL(2, 1))],
_o__c13=[POWER(/(-($16, /(*($1, $1), $8)), $8), 0.5:DECIMAL(2, 1))], _o__c [...]
HiveAggregate(group=[{}], agg#0=[sum($0)], agg#1=[sum($1)], agg#2=[sum($2)],
agg#3=[sum($3)], agg#4=[sum($4)], agg#5=[sum($5)], agg#6=[sum($6)],
agg#7=[count($6)], agg#8=[count($1)], agg#9=[sum($7)], agg#10=[count($7)],
agg#11=[count($3)], agg#12=[sum($8)], agg#13=[count($8)], agg#14=[count($5)],
agg#15=[sum($9)], agg#16=[sum($10)], agg#17=[sum($11)], agg#18=[sum($12)],
agg#19=[sum($13)], agg#20=[sum($14)], agg#21=[count($0)], agg#22=[count($2)],
agg#23=[count($4)])
HiveProject($f0=[$0], $f1=[CAST($0):DOUBLE], $f2=[$1],
$f3=[CAST($1):DOUBLE], $f4=[$2], $f5=[CAST($2):DOUBLE], $f00=[CAST($0):DOUBLE],
$f20=[CAST($1):DOUBLE], $f40=[CAST($2):DOUBLE], $f9=[*(CAST($0):DOUBLE,
CAST($0):DOUBLE)], $f10=[*(CAST($0):DOUBLE, CAST($0):DOUBLE)],
$f11=[*(CAST($1):DOUBLE, CAST($1):DOUBLE)], $f12=[*(CAST($1):DOUBLE,
CAST($1):DOUBLE)], $f13=[*(CAST($2):DOUBLE, CAST($2):DOUBLE)],
$f14=[*(CAST($2):DOUBLE, CAST($2):DOUBLE)])
HiveTableScan(table=[[default, test]], table:alias=[test])
PREHOOK: query: SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -225,55 +225,55 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@test
#### A masked pattern was here ####
POSTHOOK: query: SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -285,57 +285,57 @@ FROM test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test
#### A masked pattern was here ####
-228.0 228.0 0.0 0.0 193.0 193.0 28.5 28.5 NULL NULL
32.167 32.167 47.344 47.344 NULL NULL 53.524 53.524 50.613 50.613
NULL NULL 58.632 58.632 2241.5 2241.5 NULL NULL 2864.806
2864.806 2561.714 2561.714 NULL NULL 3437.767
3437.767 228.0 228.0 0.0 NULL 193.0 193.0 8 8
8 0 8 6
+228.0 228.0 0.0 0.0 193.0 193.0 28.5 28.5 NULL NULL
32.166666666666664 32.166666666666664 47.34448225506326
47.34448225506326 NULL NULL 53.52387836802893
53.52387836802893 50.61338050075578 50.61338050075578 NULL
NULL 58.63247109466449 58.63247109466449 2241.5 2241.5 NULL
NULL 2864.805555555555 2864.805555555555 2561.714285714286
2561.714285714286 NULL NULL 3437.7666666666664
3437.7666666666664 228.0 228.0 NULL NULL 193.0 193.0 8
8 8 0 8 6
PREHOOK: query: SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -348,55 +348,55 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@test
#### A masked pattern was here ####
POSTHOOK: query: SELECT
- ROUND(`$SUM0`(c_numeric), 3),
- ROUND(`$SUM0`(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_non_numeric), 3),
- ROUND(`$SUM0`(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(`$SUM0`(c_mix), 3),
- ROUND(`$SUM0`(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(AVG(c_numeric), 3),
- ROUND(AVG(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_non_numeric), 3),
- ROUND(AVG(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(AVG(c_mix), 3),
- ROUND(AVG(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_POP(c_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_non_numeric), 3),
- ROUND(STDDEV_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_POP(c_mix), 3),
- ROUND(STDDEV_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(STDDEV_SAMP(c_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_non_numeric), 3),
- ROUND(STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(STDDEV_SAMP(c_mix), 3),
- ROUND(STDDEV_SAMP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_POP(c_numeric), 3),
- ROUND(VAR_POP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_non_numeric), 3),
- ROUND(VAR_POP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_POP(c_mix), 3),
- ROUND(VAR_POP(CAST(c_mix AS DOUBLE)), 3),
-
- ROUND(VAR_SAMP(c_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_non_numeric), 3),
- ROUND(VAR_SAMP(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(VAR_SAMP(c_mix), 3),
- ROUND(VAR_SAMP(CAST(c_mix AS DOUBLE)), 3),
+ `$SUM0`(c_numeric),
+ `$SUM0`(CAST(c_numeric AS DOUBLE)),
+ `$SUM0`(c_non_numeric),
+ `$SUM0`(CAST(c_non_numeric AS DOUBLE)),
+ `$SUM0`(c_mix),
+ `$SUM0`(CAST(c_mix AS DOUBLE)),
+
+ AVG(c_numeric),
+ AVG(CAST(c_numeric AS DOUBLE)),
+ AVG(c_non_numeric),
+ AVG(CAST(c_non_numeric AS DOUBLE)),
+ AVG(c_mix),
+ AVG(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_POP(c_numeric),
+ STDDEV_POP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_POP(c_non_numeric),
+ STDDEV_POP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_POP(c_mix),
+ STDDEV_POP(CAST(c_mix AS DOUBLE)),
+
+ STDDEV_SAMP(c_numeric),
+ STDDEV_SAMP(CAST(c_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_non_numeric),
+ STDDEV_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ STDDEV_SAMP(c_mix),
+ STDDEV_SAMP(CAST(c_mix AS DOUBLE)),
+
+ VAR_POP(c_numeric),
+ VAR_POP(CAST(c_numeric AS DOUBLE)),
+ VAR_POP(c_non_numeric),
+ VAR_POP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_POP(c_mix),
+ VAR_POP(CAST(c_mix AS DOUBLE)),
+
+ VAR_SAMP(c_numeric),
+ VAR_SAMP(CAST(c_numeric AS DOUBLE)),
+ VAR_SAMP(c_non_numeric),
+ VAR_SAMP(CAST(c_non_numeric AS DOUBLE)),
+ VAR_SAMP(c_mix),
+ VAR_SAMP(CAST(c_mix AS DOUBLE)),
-- SUM and COUNT are not converted but used in the transformations
- ROUND(SUM(c_numeric), 3),
- ROUND(SUM(CAST(c_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_non_numeric), 3),
- ROUND(SUM(CAST(c_non_numeric AS DOUBLE)), 3),
- ROUND(SUM(c_mix), 3),
- ROUND(SUM(CAST(c_mix AS DOUBLE)), 3),
+ SUM(c_numeric),
+ SUM(CAST(c_numeric AS DOUBLE)),
+ SUM(c_non_numeric),
+ SUM(CAST(c_non_numeric AS DOUBLE)),
+ SUM(c_mix),
+ SUM(CAST(c_mix AS DOUBLE)),
COUNT(c_numeric),
COUNT(CAST(c_numeric AS DOUBLE)),
@@ -408,4 +408,4 @@ FROM test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test
#### A masked pattern was here ####
-228.0 228.0 0.0 0.0 193.0 193.0 28.5 28.5 NULL NULL
32.167 32.167 47.344 47.344 NULL NULL 53.524 53.524 50.613 50.613
NULL NULL 58.632 58.632 2241.5 2241.5 NULL NULL 2864.806
2864.806 2561.714 2561.714 NULL NULL 3437.767
3437.767 228.0 228.0 0.0 NULL 193.0 193.0 8 8
8 0 8 6
+228.0 228.0 0.0 0.0 193.0 193.0 28.5 28.5 NULL NULL
32.166666666666664 32.166666666666664 47.34448225506326
47.34448225506326 NULL NULL 53.52387836802894
53.52387836802894 50.61338050075578 50.61338050075578 NULL
NULL 58.632471094664496 58.632471094664496 2241.5 2241.5 NULL
NULL 2864.805555555556 2864.805555555556 2561.714285714286
2561.714285714286 NULL NULL 3437.7666666666673
3437.7666666666673 228.0 228.0 NULL NULL 193.0 193.0 8
8 8 0 8 6
diff --git
a/ql/src/test/results/clientpositive/llap/exception_in_vertex_udf.q.out
b/ql/src/test/results/clientpositive/llap/exception_in_vertex_udf.q.out
index 0753aea4a95..b90e5d3a9eb 100644
--- a/ql/src/test/results/clientpositive/llap/exception_in_vertex_udf.q.out
+++ b/ql/src/test/results/clientpositive/llap/exception_in_vertex_udf.q.out
@@ -424,7 +424,7 @@ JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL
+NULL NULL
PREHOOK: query: SELECT sum(src1.value), exception_in_vertex_udaf ("Reducer 2",
"0,1,2", 0)
FROM src src1
JOIN src src2 ON (src1.key = src2.key)
@@ -437,7 +437,7 @@ JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL
+NULL NULL
PREHOOK: query: SELECT sum(src1.value), exception_in_vertex_udaf ("Reducer 2",
"0-2", 0)
FROM src src1
JOIN src src2 ON (src1.key = src2.key)
@@ -450,7 +450,7 @@ JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL
+NULL NULL
PREHOOK: query: SELECT sum(src1.value), exception_in_vertex_udaf ("Reducer 2",
0, "0")
FROM src src1
JOIN src src2 ON (src1.key = src2.key)
@@ -463,7 +463,7 @@ JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL
+NULL NULL
PREHOOK: query: SELECT sum(src1.value), exception_in_vertex_udaf ("Reducer 2",
0, "0")
FROM src src1
JOIN src src2 ON (src1.key = src2.key)
@@ -476,7 +476,7 @@ JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL
+NULL NULL
PREHOOK: query: EXPLAIN
SELECT sum(src1.value), exception_in_vertex_udaf ("Reducer 3", 0, 0)
FROM src src1
@@ -607,7 +607,7 @@ JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL
+NULL NULL
PREHOOK: query: EXPLAIN
SELECT exception_in_vertex_udf (src1.value, "Map 1")
FROM src src1
diff --git a/ql/src/test/results/clientpositive/llap/ppd_windowing2.q.out
b/ql/src/test/results/clientpositive/llap/ppd_windowing2.q.out
index 6f82153c951..13947391c88 100644
--- a/ql/src/test/results/clientpositive/llap/ppd_windowing2.q.out
+++ b/ql/src/test/results/clientpositive/llap/ppd_windowing2.q.out
@@ -6732,387 +6732,387 @@ POSTHOOK: query: select * from (SELECT key, sum(key)
over(partition by key,value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-20 20.0 0.0
-200 400.0 0.0
-200 400.0 0.0
-201 201.0 0.0
-202 202.0 0.0
-203 406.0 0.0
-203 406.0 0.0
-205 410.0 0.0
-205 410.0 0.0
-207 414.0 0.0
-207 414.0 0.0
-208 624.0 0.0
-208 624.0 0.0
-208 624.0 0.0
-209 418.0 0.0
-209 418.0 0.0
-213 426.0 0.0
-213 426.0 0.0
-214 214.0 0.0
-216 432.0 0.0
-216 432.0 0.0
-217 434.0 0.0
-217 434.0 0.0
-218 218.0 0.0
-219 438.0 0.0
-219 438.0 0.0
-221 442.0 0.0
-221 442.0 0.0
-222 222.0 0.0
-223 446.0 0.0
-223 446.0 0.0
-224 448.0 0.0
-224 448.0 0.0
-226 226.0 0.0
-228 228.0 0.0
-229 458.0 0.0
-229 458.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-233 466.0 0.0
-233 466.0 0.0
-235 235.0 0.0
-237 474.0 0.0
-237 474.0 0.0
-238 476.0 0.0
-238 476.0 0.0
-239 478.0 0.0
-239 478.0 0.0
-24 48.0 0.0
-24 48.0 0.0
-241 241.0 0.0
-242 484.0 0.0
-242 484.0 0.0
-244 244.0 0.0
-247 247.0 0.0
-248 248.0 0.0
-249 249.0 0.0
-252 252.0 0.0
-255 510.0 0.0
-255 510.0 0.0
-256 512.0 0.0
-256 512.0 0.0
-257 257.0 0.0
-258 258.0 0.0
-26 52.0 0.0
-26 52.0 0.0
-260 260.0 0.0
-262 262.0 0.0
-263 263.0 0.0
-265 530.0 0.0
-265 530.0 0.0
-266 266.0 0.0
-27 27.0 0.0
-272 544.0 0.0
-272 544.0 0.0
-273 819.0 0.0
-273 819.0 0.0
-273 819.0 0.0
-274 274.0 0.0
-275 275.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-278 556.0 0.0
-278 556.0 0.0
-28 28.0 0.0
-280 560.0 0.0
-280 560.0 0.0
-281 562.0 0.0
-281 562.0 0.0
-282 564.0 0.0
-282 564.0 0.0
-283 283.0 0.0
-284 284.0 0.0
-285 285.0 0.0
-286 286.0 0.0
-287 287.0 0.0
-288 576.0 0.0
-288 576.0 0.0
-289 289.0 0.0
-291 291.0 0.0
-292 292.0 0.0
-296 296.0 0.0
-298 894.0 0.0
-298 894.0 0.0
-298 894.0 0.0
-30 30.0 0.0
-302 302.0 0.0
-305 305.0 0.0
-306 306.0 0.0
-307 614.0 0.0
-307 614.0 0.0
-308 308.0 0.0
-309 618.0 0.0
-309 618.0 0.0
-310 310.0 0.0
-311 933.0 0.0
-311 933.0 0.0
-311 933.0 0.0
-315 315.0 0.0
-316 948.0 0.0
-316 948.0 0.0
-316 948.0 0.0
-317 634.0 0.0
-317 634.0 0.0
-318 954.0 0.0
-318 954.0 0.0
-318 954.0 0.0
-321 642.0 0.0
-321 642.0 0.0
-322 644.0 0.0
-322 644.0 0.0
-323 323.0 0.0
-325 650.0 0.0
-325 650.0 0.0
-327 981.0 0.0
-327 981.0 0.0
-327 981.0 0.0
-33 33.0 0.0
-331 662.0 0.0
-331 662.0 0.0
-332 332.0 0.0
-333 666.0 0.0
-333 666.0 0.0
-335 335.0 0.0
-336 336.0 0.0
-338 338.0 0.0
-339 339.0 0.0
-34 34.0 0.0
-341 341.0 0.0
-342 684.0 0.0
-342 684.0 0.0
-344 688.0 0.0
-344 688.0 0.0
-345 345.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-35 105.0 0.0
-35 105.0 0.0
-35 105.0 0.0
-351 351.0 0.0
-353 706.0 0.0
-353 706.0 0.0
-356 356.0 0.0
-360 360.0 0.0
-362 362.0 0.0
-364 364.0 0.0
-365 365.0 0.0
-366 366.0 0.0
-367 734.0 0.0
-367 734.0 0.0
-368 368.0 0.0
-369 1107.0 0.0
-369 1107.0 0.0
-369 1107.0 0.0
-37 74.0 0.0
-37 74.0 0.0
-373 373.0 0.0
-374 374.0 0.0
-375 375.0 0.0
-377 377.0 0.0
-378 378.0 0.0
-379 379.0 0.0
-382 764.0 0.0
-382 764.0 0.0
-384 1152.0 0.0
-384 1152.0 0.0
-384 1152.0 0.0
-386 386.0 0.0
-389 389.0 0.0
-392 392.0 0.0
-393 393.0 0.0
-394 394.0 0.0
-395 790.0 0.0
-395 790.0 0.0
-396 1188.0 0.0
-396 1188.0 0.0
-396 1188.0 0.0
-397 794.0 0.0
-397 794.0 0.0
-399 798.0 0.0
-399 798.0 0.0
-4 4.0 0.0
-400 400.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-402 402.0 0.0
-403 1209.0 0.0
-403 1209.0 0.0
-403 1209.0 0.0
-404 808.0 0.0
-404 808.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-407 407.0 0.0
-409 1227.0 0.0
-409 1227.0 0.0
-409 1227.0 0.0
-41 41.0 0.0
-411 411.0 0.0
-413 826.0 0.0
-413 826.0 0.0
-414 828.0 0.0
-414 828.0 0.0
-417 1251.0 0.0
-417 1251.0 0.0
-417 1251.0 0.0
-418 418.0 0.0
-419 419.0 0.0
-42 84.0 0.0
-42 84.0 0.0
-421 421.0 0.0
-424 848.0 0.0
-424 848.0 0.0
-427 427.0 0.0
-429 858.0 0.0
-429 858.0 0.0
-43 43.0 0.0
-430 1290.0 0.0
-430 1290.0 0.0
-430 1290.0 0.0
-431 1293.0 0.0
-431 1293.0 0.0
-431 1293.0 0.0
-432 432.0 0.0
-435 435.0 0.0
-436 436.0 0.0
-437 437.0 0.0
-438 1314.0 0.0
-438 1314.0 0.0
-438 1314.0 0.0
-439 878.0 0.0
-439 878.0 0.0
-44 44.0 0.0
-443 443.0 0.0
-444 444.0 0.0
-446 446.0 0.0
-448 448.0 0.0
-449 449.0 0.0
-452 452.0 0.0
-453 453.0 0.0
-454 1362.0 0.0
-454 1362.0 0.0
-454 1362.0 0.0
-455 455.0 0.0
-457 457.0 0.0
-458 916.0 0.0
-458 916.0 0.0
-459 918.0 0.0
-459 918.0 0.0
-460 460.0 0.0
-462 924.0 0.0
-462 924.0 0.0
-463 926.0 0.0
-463 926.0 0.0
-466 1398.0 0.0
-466 1398.0 0.0
-466 1398.0 0.0
-467 467.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-47 47.0 0.0
-470 470.0 0.0
-472 472.0 0.0
-475 475.0 0.0
-477 477.0 0.0
-478 956.0 0.0
-478 956.0 0.0
-479 479.0 0.0
-480 1440.0 0.0
-480 1440.0 0.0
-480 1440.0 0.0
-481 481.0 0.0
-482 482.0 0.0
-483 483.0 0.0
-484 484.0 0.0
-485 485.0 0.0
-487 487.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-490 490.0 0.0
-491 491.0 0.0
-492 984.0 0.0
-492 984.0 0.0
-493 493.0 0.0
-494 494.0 0.0
-495 495.0 0.0
-496 496.0 0.0
-497 497.0 0.0
-498 1494.0 0.0
-498 1494.0 0.0
-498 1494.0 0.0
-5 15.0 0.0
-5 15.0 0.0
-5 15.0 0.0
-51 102.0 0.0
-51 102.0 0.0
-53 53.0 0.0
-54 54.0 0.0
-57 57.0 0.0
-58 116.0 0.0
-58 116.0 0.0
-64 64.0 0.0
-65 65.0 0.0
-66 66.0 0.0
-67 134.0 0.0
-67 134.0 0.0
-69 69.0 0.0
-70 210.0 0.0
-70 210.0 0.0
-70 210.0 0.0
-72 144.0 0.0
-72 144.0 0.0
-74 74.0 0.0
-76 152.0 0.0
-76 152.0 0.0
-77 77.0 0.0
-78 78.0 0.0
-8 8.0 0.0
-80 80.0 0.0
-82 82.0 0.0
-83 166.0 0.0
-83 166.0 0.0
-84 168.0 0.0
-84 168.0 0.0
-85 85.0 0.0
-86 86.0 0.0
-87 87.0 0.0
-9 9.0 0.0
-90 270.0 0.0
-90 270.0 0.0
-90 270.0 0.0
-92 92.0 0.0
-95 190.0 0.0
-95 190.0 0.0
-96 96.0 0.0
-97 194.0 0.0
-97 194.0 0.0
-98 196.0 0.0
-98 196.0 0.0
+20 20.0 NULL
+200 400.0 NULL
+200 400.0 NULL
+201 201.0 NULL
+202 202.0 NULL
+203 406.0 NULL
+203 406.0 NULL
+205 410.0 NULL
+205 410.0 NULL
+207 414.0 NULL
+207 414.0 NULL
+208 624.0 NULL
+208 624.0 NULL
+208 624.0 NULL
+209 418.0 NULL
+209 418.0 NULL
+213 426.0 NULL
+213 426.0 NULL
+214 214.0 NULL
+216 432.0 NULL
+216 432.0 NULL
+217 434.0 NULL
+217 434.0 NULL
+218 218.0 NULL
+219 438.0 NULL
+219 438.0 NULL
+221 442.0 NULL
+221 442.0 NULL
+222 222.0 NULL
+223 446.0 NULL
+223 446.0 NULL
+224 448.0 NULL
+224 448.0 NULL
+226 226.0 NULL
+228 228.0 NULL
+229 458.0 NULL
+229 458.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+233 466.0 NULL
+233 466.0 NULL
+235 235.0 NULL
+237 474.0 NULL
+237 474.0 NULL
+238 476.0 NULL
+238 476.0 NULL
+239 478.0 NULL
+239 478.0 NULL
+24 48.0 NULL
+24 48.0 NULL
+241 241.0 NULL
+242 484.0 NULL
+242 484.0 NULL
+244 244.0 NULL
+247 247.0 NULL
+248 248.0 NULL
+249 249.0 NULL
+252 252.0 NULL
+255 510.0 NULL
+255 510.0 NULL
+256 512.0 NULL
+256 512.0 NULL
+257 257.0 NULL
+258 258.0 NULL
+26 52.0 NULL
+26 52.0 NULL
+260 260.0 NULL
+262 262.0 NULL
+263 263.0 NULL
+265 530.0 NULL
+265 530.0 NULL
+266 266.0 NULL
+27 27.0 NULL
+272 544.0 NULL
+272 544.0 NULL
+273 819.0 NULL
+273 819.0 NULL
+273 819.0 NULL
+274 274.0 NULL
+275 275.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+278 556.0 NULL
+278 556.0 NULL
+28 28.0 NULL
+280 560.0 NULL
+280 560.0 NULL
+281 562.0 NULL
+281 562.0 NULL
+282 564.0 NULL
+282 564.0 NULL
+283 283.0 NULL
+284 284.0 NULL
+285 285.0 NULL
+286 286.0 NULL
+287 287.0 NULL
+288 576.0 NULL
+288 576.0 NULL
+289 289.0 NULL
+291 291.0 NULL
+292 292.0 NULL
+296 296.0 NULL
+298 894.0 NULL
+298 894.0 NULL
+298 894.0 NULL
+30 30.0 NULL
+302 302.0 NULL
+305 305.0 NULL
+306 306.0 NULL
+307 614.0 NULL
+307 614.0 NULL
+308 308.0 NULL
+309 618.0 NULL
+309 618.0 NULL
+310 310.0 NULL
+311 933.0 NULL
+311 933.0 NULL
+311 933.0 NULL
+315 315.0 NULL
+316 948.0 NULL
+316 948.0 NULL
+316 948.0 NULL
+317 634.0 NULL
+317 634.0 NULL
+318 954.0 NULL
+318 954.0 NULL
+318 954.0 NULL
+321 642.0 NULL
+321 642.0 NULL
+322 644.0 NULL
+322 644.0 NULL
+323 323.0 NULL
+325 650.0 NULL
+325 650.0 NULL
+327 981.0 NULL
+327 981.0 NULL
+327 981.0 NULL
+33 33.0 NULL
+331 662.0 NULL
+331 662.0 NULL
+332 332.0 NULL
+333 666.0 NULL
+333 666.0 NULL
+335 335.0 NULL
+336 336.0 NULL
+338 338.0 NULL
+339 339.0 NULL
+34 34.0 NULL
+341 341.0 NULL
+342 684.0 NULL
+342 684.0 NULL
+344 688.0 NULL
+344 688.0 NULL
+345 345.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+35 105.0 NULL
+35 105.0 NULL
+35 105.0 NULL
+351 351.0 NULL
+353 706.0 NULL
+353 706.0 NULL
+356 356.0 NULL
+360 360.0 NULL
+362 362.0 NULL
+364 364.0 NULL
+365 365.0 NULL
+366 366.0 NULL
+367 734.0 NULL
+367 734.0 NULL
+368 368.0 NULL
+369 1107.0 NULL
+369 1107.0 NULL
+369 1107.0 NULL
+37 74.0 NULL
+37 74.0 NULL
+373 373.0 NULL
+374 374.0 NULL
+375 375.0 NULL
+377 377.0 NULL
+378 378.0 NULL
+379 379.0 NULL
+382 764.0 NULL
+382 764.0 NULL
+384 1152.0 NULL
+384 1152.0 NULL
+384 1152.0 NULL
+386 386.0 NULL
+389 389.0 NULL
+392 392.0 NULL
+393 393.0 NULL
+394 394.0 NULL
+395 790.0 NULL
+395 790.0 NULL
+396 1188.0 NULL
+396 1188.0 NULL
+396 1188.0 NULL
+397 794.0 NULL
+397 794.0 NULL
+399 798.0 NULL
+399 798.0 NULL
+4 4.0 NULL
+400 400.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+402 402.0 NULL
+403 1209.0 NULL
+403 1209.0 NULL
+403 1209.0 NULL
+404 808.0 NULL
+404 808.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+407 407.0 NULL
+409 1227.0 NULL
+409 1227.0 NULL
+409 1227.0 NULL
+41 41.0 NULL
+411 411.0 NULL
+413 826.0 NULL
+413 826.0 NULL
+414 828.0 NULL
+414 828.0 NULL
+417 1251.0 NULL
+417 1251.0 NULL
+417 1251.0 NULL
+418 418.0 NULL
+419 419.0 NULL
+42 84.0 NULL
+42 84.0 NULL
+421 421.0 NULL
+424 848.0 NULL
+424 848.0 NULL
+427 427.0 NULL
+429 858.0 NULL
+429 858.0 NULL
+43 43.0 NULL
+430 1290.0 NULL
+430 1290.0 NULL
+430 1290.0 NULL
+431 1293.0 NULL
+431 1293.0 NULL
+431 1293.0 NULL
+432 432.0 NULL
+435 435.0 NULL
+436 436.0 NULL
+437 437.0 NULL
+438 1314.0 NULL
+438 1314.0 NULL
+438 1314.0 NULL
+439 878.0 NULL
+439 878.0 NULL
+44 44.0 NULL
+443 443.0 NULL
+444 444.0 NULL
+446 446.0 NULL
+448 448.0 NULL
+449 449.0 NULL
+452 452.0 NULL
+453 453.0 NULL
+454 1362.0 NULL
+454 1362.0 NULL
+454 1362.0 NULL
+455 455.0 NULL
+457 457.0 NULL
+458 916.0 NULL
+458 916.0 NULL
+459 918.0 NULL
+459 918.0 NULL
+460 460.0 NULL
+462 924.0 NULL
+462 924.0 NULL
+463 926.0 NULL
+463 926.0 NULL
+466 1398.0 NULL
+466 1398.0 NULL
+466 1398.0 NULL
+467 467.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+47 47.0 NULL
+470 470.0 NULL
+472 472.0 NULL
+475 475.0 NULL
+477 477.0 NULL
+478 956.0 NULL
+478 956.0 NULL
+479 479.0 NULL
+480 1440.0 NULL
+480 1440.0 NULL
+480 1440.0 NULL
+481 481.0 NULL
+482 482.0 NULL
+483 483.0 NULL
+484 484.0 NULL
+485 485.0 NULL
+487 487.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+490 490.0 NULL
+491 491.0 NULL
+492 984.0 NULL
+492 984.0 NULL
+493 493.0 NULL
+494 494.0 NULL
+495 495.0 NULL
+496 496.0 NULL
+497 497.0 NULL
+498 1494.0 NULL
+498 1494.0 NULL
+498 1494.0 NULL
+5 15.0 NULL
+5 15.0 NULL
+5 15.0 NULL
+51 102.0 NULL
+51 102.0 NULL
+53 53.0 NULL
+54 54.0 NULL
+57 57.0 NULL
+58 116.0 NULL
+58 116.0 NULL
+64 64.0 NULL
+65 65.0 NULL
+66 66.0 NULL
+67 134.0 NULL
+67 134.0 NULL
+69 69.0 NULL
+70 210.0 NULL
+70 210.0 NULL
+70 210.0 NULL
+72 144.0 NULL
+72 144.0 NULL
+74 74.0 NULL
+76 152.0 NULL
+76 152.0 NULL
+77 77.0 NULL
+78 78.0 NULL
+8 8.0 NULL
+80 80.0 NULL
+82 82.0 NULL
+83 166.0 NULL
+83 166.0 NULL
+84 168.0 NULL
+84 168.0 NULL
+85 85.0 NULL
+86 86.0 NULL
+87 87.0 NULL
+9 9.0 NULL
+90 270.0 NULL
+90 270.0 NULL
+90 270.0 NULL
+92 92.0 NULL
+95 190.0 NULL
+95 190.0 NULL
+96 96.0 NULL
+97 194.0 NULL
+97 194.0 NULL
+98 196.0 NULL
+98 196.0 NULL
PREHOOK: query: select * from (SELECT key, sum(key) over(partition by
key,value) as c1, sum(value) over(partition by key) as c2 from src)r1 where
key > 2
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -7121,502 +7121,502 @@ POSTHOOK: query: select * from (SELECT key, sum(key)
over(partition by key,value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-10 10.0 0.0
-100 200.0 0.0
-100 200.0 0.0
-103 206.0 0.0
-103 206.0 0.0
-104 208.0 0.0
-104 208.0 0.0
-105 105.0 0.0
-11 11.0 0.0
-111 111.0 0.0
-113 226.0 0.0
-113 226.0 0.0
-114 114.0 0.0
-116 116.0 0.0
-118 236.0 0.0
-118 236.0 0.0
-119 357.0 0.0
-119 357.0 0.0
-119 357.0 0.0
-12 24.0 0.0
-12 24.0 0.0
-120 240.0 0.0
-120 240.0 0.0
-125 250.0 0.0
-125 250.0 0.0
-126 126.0 0.0
-128 384.0 0.0
-128 384.0 0.0
-128 384.0 0.0
-129 258.0 0.0
-129 258.0 0.0
-131 131.0 0.0
-133 133.0 0.0
-134 268.0 0.0
-134 268.0 0.0
-136 136.0 0.0
-137 274.0 0.0
-137 274.0 0.0
-138 552.0 0.0
-138 552.0 0.0
-138 552.0 0.0
-138 552.0 0.0
-143 143.0 0.0
-145 145.0 0.0
-146 292.0 0.0
-146 292.0 0.0
-149 298.0 0.0
-149 298.0 0.0
-15 30.0 0.0
-15 30.0 0.0
-150 150.0 0.0
-152 304.0 0.0
-152 304.0 0.0
-153 153.0 0.0
-155 155.0 0.0
-156 156.0 0.0
-157 157.0 0.0
-158 158.0 0.0
-160 160.0 0.0
-162 162.0 0.0
-163 163.0 0.0
-164 328.0 0.0
-164 328.0 0.0
-165 330.0 0.0
-165 330.0 0.0
-166 166.0 0.0
-167 501.0 0.0
-167 501.0 0.0
-167 501.0 0.0
-168 168.0 0.0
-169 676.0 0.0
-169 676.0 0.0
-169 676.0 0.0
-169 676.0 0.0
-17 17.0 0.0
-170 170.0 0.0
-172 344.0 0.0
-172 344.0 0.0
-174 348.0 0.0
-174 348.0 0.0
-175 350.0 0.0
-175 350.0 0.0
-176 352.0 0.0
-176 352.0 0.0
-177 177.0 0.0
-178 178.0 0.0
-179 358.0 0.0
-179 358.0 0.0
-18 36.0 0.0
-18 36.0 0.0
-180 180.0 0.0
-181 181.0 0.0
-183 183.0 0.0
-186 186.0 0.0
-187 561.0 0.0
-187 561.0 0.0
-187 561.0 0.0
-189 189.0 0.0
-19 19.0 0.0
-190 190.0 0.0
-191 382.0 0.0
-191 382.0 0.0
-192 192.0 0.0
-193 579.0 0.0
-193 579.0 0.0
-193 579.0 0.0
-194 194.0 0.0
-195 390.0 0.0
-195 390.0 0.0
-196 196.0 0.0
-197 394.0 0.0
-197 394.0 0.0
-199 597.0 0.0
-199 597.0 0.0
-199 597.0 0.0
-20 20.0 0.0
-200 400.0 0.0
-200 400.0 0.0
-201 201.0 0.0
-202 202.0 0.0
-203 406.0 0.0
-203 406.0 0.0
-205 410.0 0.0
-205 410.0 0.0
-207 414.0 0.0
-207 414.0 0.0
-208 624.0 0.0
-208 624.0 0.0
-208 624.0 0.0
-209 418.0 0.0
-209 418.0 0.0
-213 426.0 0.0
-213 426.0 0.0
-214 214.0 0.0
-216 432.0 0.0
-216 432.0 0.0
-217 434.0 0.0
-217 434.0 0.0
-218 218.0 0.0
-219 438.0 0.0
-219 438.0 0.0
-221 442.0 0.0
-221 442.0 0.0
-222 222.0 0.0
-223 446.0 0.0
-223 446.0 0.0
-224 448.0 0.0
-224 448.0 0.0
-226 226.0 0.0
-228 228.0 0.0
-229 458.0 0.0
-229 458.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-233 466.0 0.0
-233 466.0 0.0
-235 235.0 0.0
-237 474.0 0.0
-237 474.0 0.0
-238 476.0 0.0
-238 476.0 0.0
-239 478.0 0.0
-239 478.0 0.0
-24 48.0 0.0
-24 48.0 0.0
-241 241.0 0.0
-242 484.0 0.0
-242 484.0 0.0
-244 244.0 0.0
-247 247.0 0.0
-248 248.0 0.0
-249 249.0 0.0
-252 252.0 0.0
-255 510.0 0.0
-255 510.0 0.0
-256 512.0 0.0
-256 512.0 0.0
-257 257.0 0.0
-258 258.0 0.0
-26 52.0 0.0
-26 52.0 0.0
-260 260.0 0.0
-262 262.0 0.0
-263 263.0 0.0
-265 530.0 0.0
-265 530.0 0.0
-266 266.0 0.0
-27 27.0 0.0
-272 544.0 0.0
-272 544.0 0.0
-273 819.0 0.0
-273 819.0 0.0
-273 819.0 0.0
-274 274.0 0.0
-275 275.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-278 556.0 0.0
-278 556.0 0.0
-28 28.0 0.0
-280 560.0 0.0
-280 560.0 0.0
-281 562.0 0.0
-281 562.0 0.0
-282 564.0 0.0
-282 564.0 0.0
-283 283.0 0.0
-284 284.0 0.0
-285 285.0 0.0
-286 286.0 0.0
-287 287.0 0.0
-288 576.0 0.0
-288 576.0 0.0
-289 289.0 0.0
-291 291.0 0.0
-292 292.0 0.0
-296 296.0 0.0
-298 894.0 0.0
-298 894.0 0.0
-298 894.0 0.0
-30 30.0 0.0
-302 302.0 0.0
-305 305.0 0.0
-306 306.0 0.0
-307 614.0 0.0
-307 614.0 0.0
-308 308.0 0.0
-309 618.0 0.0
-309 618.0 0.0
-310 310.0 0.0
-311 933.0 0.0
-311 933.0 0.0
-311 933.0 0.0
-315 315.0 0.0
-316 948.0 0.0
-316 948.0 0.0
-316 948.0 0.0
-317 634.0 0.0
-317 634.0 0.0
-318 954.0 0.0
-318 954.0 0.0
-318 954.0 0.0
-321 642.0 0.0
-321 642.0 0.0
-322 644.0 0.0
-322 644.0 0.0
-323 323.0 0.0
-325 650.0 0.0
-325 650.0 0.0
-327 981.0 0.0
-327 981.0 0.0
-327 981.0 0.0
-33 33.0 0.0
-331 662.0 0.0
-331 662.0 0.0
-332 332.0 0.0
-333 666.0 0.0
-333 666.0 0.0
-335 335.0 0.0
-336 336.0 0.0
-338 338.0 0.0
-339 339.0 0.0
-34 34.0 0.0
-341 341.0 0.0
-342 684.0 0.0
-342 684.0 0.0
-344 688.0 0.0
-344 688.0 0.0
-345 345.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-35 105.0 0.0
-35 105.0 0.0
-35 105.0 0.0
-351 351.0 0.0
-353 706.0 0.0
-353 706.0 0.0
-356 356.0 0.0
-360 360.0 0.0
-362 362.0 0.0
-364 364.0 0.0
-365 365.0 0.0
-366 366.0 0.0
-367 734.0 0.0
-367 734.0 0.0
-368 368.0 0.0
-369 1107.0 0.0
-369 1107.0 0.0
-369 1107.0 0.0
-37 74.0 0.0
-37 74.0 0.0
-373 373.0 0.0
-374 374.0 0.0
-375 375.0 0.0
-377 377.0 0.0
-378 378.0 0.0
-379 379.0 0.0
-382 764.0 0.0
-382 764.0 0.0
-384 1152.0 0.0
-384 1152.0 0.0
-384 1152.0 0.0
-386 386.0 0.0
-389 389.0 0.0
-392 392.0 0.0
-393 393.0 0.0
-394 394.0 0.0
-395 790.0 0.0
-395 790.0 0.0
-396 1188.0 0.0
-396 1188.0 0.0
-396 1188.0 0.0
-397 794.0 0.0
-397 794.0 0.0
-399 798.0 0.0
-399 798.0 0.0
-4 4.0 0.0
-400 400.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-402 402.0 0.0
-403 1209.0 0.0
-403 1209.0 0.0
-403 1209.0 0.0
-404 808.0 0.0
-404 808.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-407 407.0 0.0
-409 1227.0 0.0
-409 1227.0 0.0
-409 1227.0 0.0
-41 41.0 0.0
-411 411.0 0.0
-413 826.0 0.0
-413 826.0 0.0
-414 828.0 0.0
-414 828.0 0.0
-417 1251.0 0.0
-417 1251.0 0.0
-417 1251.0 0.0
-418 418.0 0.0
-419 419.0 0.0
-42 84.0 0.0
-42 84.0 0.0
-421 421.0 0.0
-424 848.0 0.0
-424 848.0 0.0
-427 427.0 0.0
-429 858.0 0.0
-429 858.0 0.0
-43 43.0 0.0
-430 1290.0 0.0
-430 1290.0 0.0
-430 1290.0 0.0
-431 1293.0 0.0
-431 1293.0 0.0
-431 1293.0 0.0
-432 432.0 0.0
-435 435.0 0.0
-436 436.0 0.0
-437 437.0 0.0
-438 1314.0 0.0
-438 1314.0 0.0
-438 1314.0 0.0
-439 878.0 0.0
-439 878.0 0.0
-44 44.0 0.0
-443 443.0 0.0
-444 444.0 0.0
-446 446.0 0.0
-448 448.0 0.0
-449 449.0 0.0
-452 452.0 0.0
-453 453.0 0.0
-454 1362.0 0.0
-454 1362.0 0.0
-454 1362.0 0.0
-455 455.0 0.0
-457 457.0 0.0
-458 916.0 0.0
-458 916.0 0.0
-459 918.0 0.0
-459 918.0 0.0
-460 460.0 0.0
-462 924.0 0.0
-462 924.0 0.0
-463 926.0 0.0
-463 926.0 0.0
-466 1398.0 0.0
-466 1398.0 0.0
-466 1398.0 0.0
-467 467.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-47 47.0 0.0
-470 470.0 0.0
-472 472.0 0.0
-475 475.0 0.0
-477 477.0 0.0
-478 956.0 0.0
-478 956.0 0.0
-479 479.0 0.0
-480 1440.0 0.0
-480 1440.0 0.0
-480 1440.0 0.0
-481 481.0 0.0
-482 482.0 0.0
-483 483.0 0.0
-484 484.0 0.0
-485 485.0 0.0
-487 487.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-490 490.0 0.0
-491 491.0 0.0
-492 984.0 0.0
-492 984.0 0.0
-493 493.0 0.0
-494 494.0 0.0
-495 495.0 0.0
-496 496.0 0.0
-497 497.0 0.0
-498 1494.0 0.0
-498 1494.0 0.0
-498 1494.0 0.0
-5 15.0 0.0
-5 15.0 0.0
-5 15.0 0.0
-51 102.0 0.0
-51 102.0 0.0
-53 53.0 0.0
-54 54.0 0.0
-57 57.0 0.0
-58 116.0 0.0
-58 116.0 0.0
-64 64.0 0.0
-65 65.0 0.0
-66 66.0 0.0
-67 134.0 0.0
-67 134.0 0.0
-69 69.0 0.0
-70 210.0 0.0
-70 210.0 0.0
-70 210.0 0.0
-72 144.0 0.0
-72 144.0 0.0
-74 74.0 0.0
-76 152.0 0.0
-76 152.0 0.0
-77 77.0 0.0
-78 78.0 0.0
-8 8.0 0.0
-80 80.0 0.0
-82 82.0 0.0
-83 166.0 0.0
-83 166.0 0.0
-84 168.0 0.0
-84 168.0 0.0
-85 85.0 0.0
-86 86.0 0.0
-87 87.0 0.0
-9 9.0 0.0
-90 270.0 0.0
-90 270.0 0.0
-90 270.0 0.0
-92 92.0 0.0
-95 190.0 0.0
-95 190.0 0.0
-96 96.0 0.0
-97 194.0 0.0
-97 194.0 0.0
-98 196.0 0.0
-98 196.0 0.0
+10 10.0 NULL
+100 200.0 NULL
+100 200.0 NULL
+103 206.0 NULL
+103 206.0 NULL
+104 208.0 NULL
+104 208.0 NULL
+105 105.0 NULL
+11 11.0 NULL
+111 111.0 NULL
+113 226.0 NULL
+113 226.0 NULL
+114 114.0 NULL
+116 116.0 NULL
+118 236.0 NULL
+118 236.0 NULL
+119 357.0 NULL
+119 357.0 NULL
+119 357.0 NULL
+12 24.0 NULL
+12 24.0 NULL
+120 240.0 NULL
+120 240.0 NULL
+125 250.0 NULL
+125 250.0 NULL
+126 126.0 NULL
+128 384.0 NULL
+128 384.0 NULL
+128 384.0 NULL
+129 258.0 NULL
+129 258.0 NULL
+131 131.0 NULL
+133 133.0 NULL
+134 268.0 NULL
+134 268.0 NULL
+136 136.0 NULL
+137 274.0 NULL
+137 274.0 NULL
+138 552.0 NULL
+138 552.0 NULL
+138 552.0 NULL
+138 552.0 NULL
+143 143.0 NULL
+145 145.0 NULL
+146 292.0 NULL
+146 292.0 NULL
+149 298.0 NULL
+149 298.0 NULL
+15 30.0 NULL
+15 30.0 NULL
+150 150.0 NULL
+152 304.0 NULL
+152 304.0 NULL
+153 153.0 NULL
+155 155.0 NULL
+156 156.0 NULL
+157 157.0 NULL
+158 158.0 NULL
+160 160.0 NULL
+162 162.0 NULL
+163 163.0 NULL
+164 328.0 NULL
+164 328.0 NULL
+165 330.0 NULL
+165 330.0 NULL
+166 166.0 NULL
+167 501.0 NULL
+167 501.0 NULL
+167 501.0 NULL
+168 168.0 NULL
+169 676.0 NULL
+169 676.0 NULL
+169 676.0 NULL
+169 676.0 NULL
+17 17.0 NULL
+170 170.0 NULL
+172 344.0 NULL
+172 344.0 NULL
+174 348.0 NULL
+174 348.0 NULL
+175 350.0 NULL
+175 350.0 NULL
+176 352.0 NULL
+176 352.0 NULL
+177 177.0 NULL
+178 178.0 NULL
+179 358.0 NULL
+179 358.0 NULL
+18 36.0 NULL
+18 36.0 NULL
+180 180.0 NULL
+181 181.0 NULL
+183 183.0 NULL
+186 186.0 NULL
+187 561.0 NULL
+187 561.0 NULL
+187 561.0 NULL
+189 189.0 NULL
+19 19.0 NULL
+190 190.0 NULL
+191 382.0 NULL
+191 382.0 NULL
+192 192.0 NULL
+193 579.0 NULL
+193 579.0 NULL
+193 579.0 NULL
+194 194.0 NULL
+195 390.0 NULL
+195 390.0 NULL
+196 196.0 NULL
+197 394.0 NULL
+197 394.0 NULL
+199 597.0 NULL
+199 597.0 NULL
+199 597.0 NULL
+20 20.0 NULL
+200 400.0 NULL
+200 400.0 NULL
+201 201.0 NULL
+202 202.0 NULL
+203 406.0 NULL
+203 406.0 NULL
+205 410.0 NULL
+205 410.0 NULL
+207 414.0 NULL
+207 414.0 NULL
+208 624.0 NULL
+208 624.0 NULL
+208 624.0 NULL
+209 418.0 NULL
+209 418.0 NULL
+213 426.0 NULL
+213 426.0 NULL
+214 214.0 NULL
+216 432.0 NULL
+216 432.0 NULL
+217 434.0 NULL
+217 434.0 NULL
+218 218.0 NULL
+219 438.0 NULL
+219 438.0 NULL
+221 442.0 NULL
+221 442.0 NULL
+222 222.0 NULL
+223 446.0 NULL
+223 446.0 NULL
+224 448.0 NULL
+224 448.0 NULL
+226 226.0 NULL
+228 228.0 NULL
+229 458.0 NULL
+229 458.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+233 466.0 NULL
+233 466.0 NULL
+235 235.0 NULL
+237 474.0 NULL
+237 474.0 NULL
+238 476.0 NULL
+238 476.0 NULL
+239 478.0 NULL
+239 478.0 NULL
+24 48.0 NULL
+24 48.0 NULL
+241 241.0 NULL
+242 484.0 NULL
+242 484.0 NULL
+244 244.0 NULL
+247 247.0 NULL
+248 248.0 NULL
+249 249.0 NULL
+252 252.0 NULL
+255 510.0 NULL
+255 510.0 NULL
+256 512.0 NULL
+256 512.0 NULL
+257 257.0 NULL
+258 258.0 NULL
+26 52.0 NULL
+26 52.0 NULL
+260 260.0 NULL
+262 262.0 NULL
+263 263.0 NULL
+265 530.0 NULL
+265 530.0 NULL
+266 266.0 NULL
+27 27.0 NULL
+272 544.0 NULL
+272 544.0 NULL
+273 819.0 NULL
+273 819.0 NULL
+273 819.0 NULL
+274 274.0 NULL
+275 275.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+278 556.0 NULL
+278 556.0 NULL
+28 28.0 NULL
+280 560.0 NULL
+280 560.0 NULL
+281 562.0 NULL
+281 562.0 NULL
+282 564.0 NULL
+282 564.0 NULL
+283 283.0 NULL
+284 284.0 NULL
+285 285.0 NULL
+286 286.0 NULL
+287 287.0 NULL
+288 576.0 NULL
+288 576.0 NULL
+289 289.0 NULL
+291 291.0 NULL
+292 292.0 NULL
+296 296.0 NULL
+298 894.0 NULL
+298 894.0 NULL
+298 894.0 NULL
+30 30.0 NULL
+302 302.0 NULL
+305 305.0 NULL
+306 306.0 NULL
+307 614.0 NULL
+307 614.0 NULL
+308 308.0 NULL
+309 618.0 NULL
+309 618.0 NULL
+310 310.0 NULL
+311 933.0 NULL
+311 933.0 NULL
+311 933.0 NULL
+315 315.0 NULL
+316 948.0 NULL
+316 948.0 NULL
+316 948.0 NULL
+317 634.0 NULL
+317 634.0 NULL
+318 954.0 NULL
+318 954.0 NULL
+318 954.0 NULL
+321 642.0 NULL
+321 642.0 NULL
+322 644.0 NULL
+322 644.0 NULL
+323 323.0 NULL
+325 650.0 NULL
+325 650.0 NULL
+327 981.0 NULL
+327 981.0 NULL
+327 981.0 NULL
+33 33.0 NULL
+331 662.0 NULL
+331 662.0 NULL
+332 332.0 NULL
+333 666.0 NULL
+333 666.0 NULL
+335 335.0 NULL
+336 336.0 NULL
+338 338.0 NULL
+339 339.0 NULL
+34 34.0 NULL
+341 341.0 NULL
+342 684.0 NULL
+342 684.0 NULL
+344 688.0 NULL
+344 688.0 NULL
+345 345.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+35 105.0 NULL
+35 105.0 NULL
+35 105.0 NULL
+351 351.0 NULL
+353 706.0 NULL
+353 706.0 NULL
+356 356.0 NULL
+360 360.0 NULL
+362 362.0 NULL
+364 364.0 NULL
+365 365.0 NULL
+366 366.0 NULL
+367 734.0 NULL
+367 734.0 NULL
+368 368.0 NULL
+369 1107.0 NULL
+369 1107.0 NULL
+369 1107.0 NULL
+37 74.0 NULL
+37 74.0 NULL
+373 373.0 NULL
+374 374.0 NULL
+375 375.0 NULL
+377 377.0 NULL
+378 378.0 NULL
+379 379.0 NULL
+382 764.0 NULL
+382 764.0 NULL
+384 1152.0 NULL
+384 1152.0 NULL
+384 1152.0 NULL
+386 386.0 NULL
+389 389.0 NULL
+392 392.0 NULL
+393 393.0 NULL
+394 394.0 NULL
+395 790.0 NULL
+395 790.0 NULL
+396 1188.0 NULL
+396 1188.0 NULL
+396 1188.0 NULL
+397 794.0 NULL
+397 794.0 NULL
+399 798.0 NULL
+399 798.0 NULL
+4 4.0 NULL
+400 400.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+402 402.0 NULL
+403 1209.0 NULL
+403 1209.0 NULL
+403 1209.0 NULL
+404 808.0 NULL
+404 808.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+407 407.0 NULL
+409 1227.0 NULL
+409 1227.0 NULL
+409 1227.0 NULL
+41 41.0 NULL
+411 411.0 NULL
+413 826.0 NULL
+413 826.0 NULL
+414 828.0 NULL
+414 828.0 NULL
+417 1251.0 NULL
+417 1251.0 NULL
+417 1251.0 NULL
+418 418.0 NULL
+419 419.0 NULL
+42 84.0 NULL
+42 84.0 NULL
+421 421.0 NULL
+424 848.0 NULL
+424 848.0 NULL
+427 427.0 NULL
+429 858.0 NULL
+429 858.0 NULL
+43 43.0 NULL
+430 1290.0 NULL
+430 1290.0 NULL
+430 1290.0 NULL
+431 1293.0 NULL
+431 1293.0 NULL
+431 1293.0 NULL
+432 432.0 NULL
+435 435.0 NULL
+436 436.0 NULL
+437 437.0 NULL
+438 1314.0 NULL
+438 1314.0 NULL
+438 1314.0 NULL
+439 878.0 NULL
+439 878.0 NULL
+44 44.0 NULL
+443 443.0 NULL
+444 444.0 NULL
+446 446.0 NULL
+448 448.0 NULL
+449 449.0 NULL
+452 452.0 NULL
+453 453.0 NULL
+454 1362.0 NULL
+454 1362.0 NULL
+454 1362.0 NULL
+455 455.0 NULL
+457 457.0 NULL
+458 916.0 NULL
+458 916.0 NULL
+459 918.0 NULL
+459 918.0 NULL
+460 460.0 NULL
+462 924.0 NULL
+462 924.0 NULL
+463 926.0 NULL
+463 926.0 NULL
+466 1398.0 NULL
+466 1398.0 NULL
+466 1398.0 NULL
+467 467.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+47 47.0 NULL
+470 470.0 NULL
+472 472.0 NULL
+475 475.0 NULL
+477 477.0 NULL
+478 956.0 NULL
+478 956.0 NULL
+479 479.0 NULL
+480 1440.0 NULL
+480 1440.0 NULL
+480 1440.0 NULL
+481 481.0 NULL
+482 482.0 NULL
+483 483.0 NULL
+484 484.0 NULL
+485 485.0 NULL
+487 487.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+490 490.0 NULL
+491 491.0 NULL
+492 984.0 NULL
+492 984.0 NULL
+493 493.0 NULL
+494 494.0 NULL
+495 495.0 NULL
+496 496.0 NULL
+497 497.0 NULL
+498 1494.0 NULL
+498 1494.0 NULL
+498 1494.0 NULL
+5 15.0 NULL
+5 15.0 NULL
+5 15.0 NULL
+51 102.0 NULL
+51 102.0 NULL
+53 53.0 NULL
+54 54.0 NULL
+57 57.0 NULL
+58 116.0 NULL
+58 116.0 NULL
+64 64.0 NULL
+65 65.0 NULL
+66 66.0 NULL
+67 134.0 NULL
+67 134.0 NULL
+69 69.0 NULL
+70 210.0 NULL
+70 210.0 NULL
+70 210.0 NULL
+72 144.0 NULL
+72 144.0 NULL
+74 74.0 NULL
+76 152.0 NULL
+76 152.0 NULL
+77 77.0 NULL
+78 78.0 NULL
+8 8.0 NULL
+80 80.0 NULL
+82 82.0 NULL
+83 166.0 NULL
+83 166.0 NULL
+84 168.0 NULL
+84 168.0 NULL
+85 85.0 NULL
+86 86.0 NULL
+87 87.0 NULL
+9 9.0 NULL
+90 270.0 NULL
+90 270.0 NULL
+90 270.0 NULL
+92 92.0 NULL
+95 190.0 NULL
+95 190.0 NULL
+96 96.0 NULL
+97 194.0 NULL
+97 194.0 NULL
+98 196.0 NULL
+98 196.0 NULL
PREHOOK: query: select * from (SELECT key, sum(key) over(partition by
key,value) as c1, sum(value) over(partition by key) as c2 from src)r1 where
(cast(key as int) + 1) > 2
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -7625,503 +7625,503 @@ POSTHOOK: query: select * from (SELECT key, sum(key)
over(partition by key,value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-10 10.0 0.0
-100 200.0 0.0
-100 200.0 0.0
-103 206.0 0.0
-103 206.0 0.0
-104 208.0 0.0
-104 208.0 0.0
-105 105.0 0.0
-11 11.0 0.0
-111 111.0 0.0
-113 226.0 0.0
-113 226.0 0.0
-114 114.0 0.0
-116 116.0 0.0
-118 236.0 0.0
-118 236.0 0.0
-119 357.0 0.0
-119 357.0 0.0
-119 357.0 0.0
-12 24.0 0.0
-12 24.0 0.0
-120 240.0 0.0
-120 240.0 0.0
-125 250.0 0.0
-125 250.0 0.0
-126 126.0 0.0
-128 384.0 0.0
-128 384.0 0.0
-128 384.0 0.0
-129 258.0 0.0
-129 258.0 0.0
-131 131.0 0.0
-133 133.0 0.0
-134 268.0 0.0
-134 268.0 0.0
-136 136.0 0.0
-137 274.0 0.0
-137 274.0 0.0
-138 552.0 0.0
-138 552.0 0.0
-138 552.0 0.0
-138 552.0 0.0
-143 143.0 0.0
-145 145.0 0.0
-146 292.0 0.0
-146 292.0 0.0
-149 298.0 0.0
-149 298.0 0.0
-15 30.0 0.0
-15 30.0 0.0
-150 150.0 0.0
-152 304.0 0.0
-152 304.0 0.0
-153 153.0 0.0
-155 155.0 0.0
-156 156.0 0.0
-157 157.0 0.0
-158 158.0 0.0
-160 160.0 0.0
-162 162.0 0.0
-163 163.0 0.0
-164 328.0 0.0
-164 328.0 0.0
-165 330.0 0.0
-165 330.0 0.0
-166 166.0 0.0
-167 501.0 0.0
-167 501.0 0.0
-167 501.0 0.0
-168 168.0 0.0
-169 676.0 0.0
-169 676.0 0.0
-169 676.0 0.0
-169 676.0 0.0
-17 17.0 0.0
-170 170.0 0.0
-172 344.0 0.0
-172 344.0 0.0
-174 348.0 0.0
-174 348.0 0.0
-175 350.0 0.0
-175 350.0 0.0
-176 352.0 0.0
-176 352.0 0.0
-177 177.0 0.0
-178 178.0 0.0
-179 358.0 0.0
-179 358.0 0.0
-18 36.0 0.0
-18 36.0 0.0
-180 180.0 0.0
-181 181.0 0.0
-183 183.0 0.0
-186 186.0 0.0
-187 561.0 0.0
-187 561.0 0.0
-187 561.0 0.0
-189 189.0 0.0
-19 19.0 0.0
-190 190.0 0.0
-191 382.0 0.0
-191 382.0 0.0
-192 192.0 0.0
-193 579.0 0.0
-193 579.0 0.0
-193 579.0 0.0
-194 194.0 0.0
-195 390.0 0.0
-195 390.0 0.0
-196 196.0 0.0
-197 394.0 0.0
-197 394.0 0.0
-199 597.0 0.0
-199 597.0 0.0
-199 597.0 0.0
-2 2.0 0.0
-20 20.0 0.0
-200 400.0 0.0
-200 400.0 0.0
-201 201.0 0.0
-202 202.0 0.0
-203 406.0 0.0
-203 406.0 0.0
-205 410.0 0.0
-205 410.0 0.0
-207 414.0 0.0
-207 414.0 0.0
-208 624.0 0.0
-208 624.0 0.0
-208 624.0 0.0
-209 418.0 0.0
-209 418.0 0.0
-213 426.0 0.0
-213 426.0 0.0
-214 214.0 0.0
-216 432.0 0.0
-216 432.0 0.0
-217 434.0 0.0
-217 434.0 0.0
-218 218.0 0.0
-219 438.0 0.0
-219 438.0 0.0
-221 442.0 0.0
-221 442.0 0.0
-222 222.0 0.0
-223 446.0 0.0
-223 446.0 0.0
-224 448.0 0.0
-224 448.0 0.0
-226 226.0 0.0
-228 228.0 0.0
-229 458.0 0.0
-229 458.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-230 1150.0 0.0
-233 466.0 0.0
-233 466.0 0.0
-235 235.0 0.0
-237 474.0 0.0
-237 474.0 0.0
-238 476.0 0.0
-238 476.0 0.0
-239 478.0 0.0
-239 478.0 0.0
-24 48.0 0.0
-24 48.0 0.0
-241 241.0 0.0
-242 484.0 0.0
-242 484.0 0.0
-244 244.0 0.0
-247 247.0 0.0
-248 248.0 0.0
-249 249.0 0.0
-252 252.0 0.0
-255 510.0 0.0
-255 510.0 0.0
-256 512.0 0.0
-256 512.0 0.0
-257 257.0 0.0
-258 258.0 0.0
-26 52.0 0.0
-26 52.0 0.0
-260 260.0 0.0
-262 262.0 0.0
-263 263.0 0.0
-265 530.0 0.0
-265 530.0 0.0
-266 266.0 0.0
-27 27.0 0.0
-272 544.0 0.0
-272 544.0 0.0
-273 819.0 0.0
-273 819.0 0.0
-273 819.0 0.0
-274 274.0 0.0
-275 275.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-277 1108.0 0.0
-278 556.0 0.0
-278 556.0 0.0
-28 28.0 0.0
-280 560.0 0.0
-280 560.0 0.0
-281 562.0 0.0
-281 562.0 0.0
-282 564.0 0.0
-282 564.0 0.0
-283 283.0 0.0
-284 284.0 0.0
-285 285.0 0.0
-286 286.0 0.0
-287 287.0 0.0
-288 576.0 0.0
-288 576.0 0.0
-289 289.0 0.0
-291 291.0 0.0
-292 292.0 0.0
-296 296.0 0.0
-298 894.0 0.0
-298 894.0 0.0
-298 894.0 0.0
-30 30.0 0.0
-302 302.0 0.0
-305 305.0 0.0
-306 306.0 0.0
-307 614.0 0.0
-307 614.0 0.0
-308 308.0 0.0
-309 618.0 0.0
-309 618.0 0.0
-310 310.0 0.0
-311 933.0 0.0
-311 933.0 0.0
-311 933.0 0.0
-315 315.0 0.0
-316 948.0 0.0
-316 948.0 0.0
-316 948.0 0.0
-317 634.0 0.0
-317 634.0 0.0
-318 954.0 0.0
-318 954.0 0.0
-318 954.0 0.0
-321 642.0 0.0
-321 642.0 0.0
-322 644.0 0.0
-322 644.0 0.0
-323 323.0 0.0
-325 650.0 0.0
-325 650.0 0.0
-327 981.0 0.0
-327 981.0 0.0
-327 981.0 0.0
-33 33.0 0.0
-331 662.0 0.0
-331 662.0 0.0
-332 332.0 0.0
-333 666.0 0.0
-333 666.0 0.0
-335 335.0 0.0
-336 336.0 0.0
-338 338.0 0.0
-339 339.0 0.0
-34 34.0 0.0
-341 341.0 0.0
-342 684.0 0.0
-342 684.0 0.0
-344 688.0 0.0
-344 688.0 0.0
-345 345.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-348 1740.0 0.0
-35 105.0 0.0
-35 105.0 0.0
-35 105.0 0.0
-351 351.0 0.0
-353 706.0 0.0
-353 706.0 0.0
-356 356.0 0.0
-360 360.0 0.0
-362 362.0 0.0
-364 364.0 0.0
-365 365.0 0.0
-366 366.0 0.0
-367 734.0 0.0
-367 734.0 0.0
-368 368.0 0.0
-369 1107.0 0.0
-369 1107.0 0.0
-369 1107.0 0.0
-37 74.0 0.0
-37 74.0 0.0
-373 373.0 0.0
-374 374.0 0.0
-375 375.0 0.0
-377 377.0 0.0
-378 378.0 0.0
-379 379.0 0.0
-382 764.0 0.0
-382 764.0 0.0
-384 1152.0 0.0
-384 1152.0 0.0
-384 1152.0 0.0
-386 386.0 0.0
-389 389.0 0.0
-392 392.0 0.0
-393 393.0 0.0
-394 394.0 0.0
-395 790.0 0.0
-395 790.0 0.0
-396 1188.0 0.0
-396 1188.0 0.0
-396 1188.0 0.0
-397 794.0 0.0
-397 794.0 0.0
-399 798.0 0.0
-399 798.0 0.0
-4 4.0 0.0
-400 400.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-401 2005.0 0.0
-402 402.0 0.0
-403 1209.0 0.0
-403 1209.0 0.0
-403 1209.0 0.0
-404 808.0 0.0
-404 808.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-406 1624.0 0.0
-407 407.0 0.0
-409 1227.0 0.0
-409 1227.0 0.0
-409 1227.0 0.0
-41 41.0 0.0
-411 411.0 0.0
-413 826.0 0.0
-413 826.0 0.0
-414 828.0 0.0
-414 828.0 0.0
-417 1251.0 0.0
-417 1251.0 0.0
-417 1251.0 0.0
-418 418.0 0.0
-419 419.0 0.0
-42 84.0 0.0
-42 84.0 0.0
-421 421.0 0.0
-424 848.0 0.0
-424 848.0 0.0
-427 427.0 0.0
-429 858.0 0.0
-429 858.0 0.0
-43 43.0 0.0
-430 1290.0 0.0
-430 1290.0 0.0
-430 1290.0 0.0
-431 1293.0 0.0
-431 1293.0 0.0
-431 1293.0 0.0
-432 432.0 0.0
-435 435.0 0.0
-436 436.0 0.0
-437 437.0 0.0
-438 1314.0 0.0
-438 1314.0 0.0
-438 1314.0 0.0
-439 878.0 0.0
-439 878.0 0.0
-44 44.0 0.0
-443 443.0 0.0
-444 444.0 0.0
-446 446.0 0.0
-448 448.0 0.0
-449 449.0 0.0
-452 452.0 0.0
-453 453.0 0.0
-454 1362.0 0.0
-454 1362.0 0.0
-454 1362.0 0.0
-455 455.0 0.0
-457 457.0 0.0
-458 916.0 0.0
-458 916.0 0.0
-459 918.0 0.0
-459 918.0 0.0
-460 460.0 0.0
-462 924.0 0.0
-462 924.0 0.0
-463 926.0 0.0
-463 926.0 0.0
-466 1398.0 0.0
-466 1398.0 0.0
-466 1398.0 0.0
-467 467.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-468 1872.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-469 2345.0 0.0
-47 47.0 0.0
-470 470.0 0.0
-472 472.0 0.0
-475 475.0 0.0
-477 477.0 0.0
-478 956.0 0.0
-478 956.0 0.0
-479 479.0 0.0
-480 1440.0 0.0
-480 1440.0 0.0
-480 1440.0 0.0
-481 481.0 0.0
-482 482.0 0.0
-483 483.0 0.0
-484 484.0 0.0
-485 485.0 0.0
-487 487.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-489 1956.0 0.0
-490 490.0 0.0
-491 491.0 0.0
-492 984.0 0.0
-492 984.0 0.0
-493 493.0 0.0
-494 494.0 0.0
-495 495.0 0.0
-496 496.0 0.0
-497 497.0 0.0
-498 1494.0 0.0
-498 1494.0 0.0
-498 1494.0 0.0
-5 15.0 0.0
-5 15.0 0.0
-5 15.0 0.0
-51 102.0 0.0
-51 102.0 0.0
-53 53.0 0.0
-54 54.0 0.0
-57 57.0 0.0
-58 116.0 0.0
-58 116.0 0.0
-64 64.0 0.0
-65 65.0 0.0
-66 66.0 0.0
-67 134.0 0.0
-67 134.0 0.0
-69 69.0 0.0
-70 210.0 0.0
-70 210.0 0.0
-70 210.0 0.0
-72 144.0 0.0
-72 144.0 0.0
-74 74.0 0.0
-76 152.0 0.0
-76 152.0 0.0
-77 77.0 0.0
-78 78.0 0.0
-8 8.0 0.0
-80 80.0 0.0
-82 82.0 0.0
-83 166.0 0.0
-83 166.0 0.0
-84 168.0 0.0
-84 168.0 0.0
-85 85.0 0.0
-86 86.0 0.0
-87 87.0 0.0
-9 9.0 0.0
-90 270.0 0.0
-90 270.0 0.0
-90 270.0 0.0
-92 92.0 0.0
-95 190.0 0.0
-95 190.0 0.0
-96 96.0 0.0
-97 194.0 0.0
-97 194.0 0.0
-98 196.0 0.0
-98 196.0 0.0
+10 10.0 NULL
+100 200.0 NULL
+100 200.0 NULL
+103 206.0 NULL
+103 206.0 NULL
+104 208.0 NULL
+104 208.0 NULL
+105 105.0 NULL
+11 11.0 NULL
+111 111.0 NULL
+113 226.0 NULL
+113 226.0 NULL
+114 114.0 NULL
+116 116.0 NULL
+118 236.0 NULL
+118 236.0 NULL
+119 357.0 NULL
+119 357.0 NULL
+119 357.0 NULL
+12 24.0 NULL
+12 24.0 NULL
+120 240.0 NULL
+120 240.0 NULL
+125 250.0 NULL
+125 250.0 NULL
+126 126.0 NULL
+128 384.0 NULL
+128 384.0 NULL
+128 384.0 NULL
+129 258.0 NULL
+129 258.0 NULL
+131 131.0 NULL
+133 133.0 NULL
+134 268.0 NULL
+134 268.0 NULL
+136 136.0 NULL
+137 274.0 NULL
+137 274.0 NULL
+138 552.0 NULL
+138 552.0 NULL
+138 552.0 NULL
+138 552.0 NULL
+143 143.0 NULL
+145 145.0 NULL
+146 292.0 NULL
+146 292.0 NULL
+149 298.0 NULL
+149 298.0 NULL
+15 30.0 NULL
+15 30.0 NULL
+150 150.0 NULL
+152 304.0 NULL
+152 304.0 NULL
+153 153.0 NULL
+155 155.0 NULL
+156 156.0 NULL
+157 157.0 NULL
+158 158.0 NULL
+160 160.0 NULL
+162 162.0 NULL
+163 163.0 NULL
+164 328.0 NULL
+164 328.0 NULL
+165 330.0 NULL
+165 330.0 NULL
+166 166.0 NULL
+167 501.0 NULL
+167 501.0 NULL
+167 501.0 NULL
+168 168.0 NULL
+169 676.0 NULL
+169 676.0 NULL
+169 676.0 NULL
+169 676.0 NULL
+17 17.0 NULL
+170 170.0 NULL
+172 344.0 NULL
+172 344.0 NULL
+174 348.0 NULL
+174 348.0 NULL
+175 350.0 NULL
+175 350.0 NULL
+176 352.0 NULL
+176 352.0 NULL
+177 177.0 NULL
+178 178.0 NULL
+179 358.0 NULL
+179 358.0 NULL
+18 36.0 NULL
+18 36.0 NULL
+180 180.0 NULL
+181 181.0 NULL
+183 183.0 NULL
+186 186.0 NULL
+187 561.0 NULL
+187 561.0 NULL
+187 561.0 NULL
+189 189.0 NULL
+19 19.0 NULL
+190 190.0 NULL
+191 382.0 NULL
+191 382.0 NULL
+192 192.0 NULL
+193 579.0 NULL
+193 579.0 NULL
+193 579.0 NULL
+194 194.0 NULL
+195 390.0 NULL
+195 390.0 NULL
+196 196.0 NULL
+197 394.0 NULL
+197 394.0 NULL
+199 597.0 NULL
+199 597.0 NULL
+199 597.0 NULL
+2 2.0 NULL
+20 20.0 NULL
+200 400.0 NULL
+200 400.0 NULL
+201 201.0 NULL
+202 202.0 NULL
+203 406.0 NULL
+203 406.0 NULL
+205 410.0 NULL
+205 410.0 NULL
+207 414.0 NULL
+207 414.0 NULL
+208 624.0 NULL
+208 624.0 NULL
+208 624.0 NULL
+209 418.0 NULL
+209 418.0 NULL
+213 426.0 NULL
+213 426.0 NULL
+214 214.0 NULL
+216 432.0 NULL
+216 432.0 NULL
+217 434.0 NULL
+217 434.0 NULL
+218 218.0 NULL
+219 438.0 NULL
+219 438.0 NULL
+221 442.0 NULL
+221 442.0 NULL
+222 222.0 NULL
+223 446.0 NULL
+223 446.0 NULL
+224 448.0 NULL
+224 448.0 NULL
+226 226.0 NULL
+228 228.0 NULL
+229 458.0 NULL
+229 458.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+230 1150.0 NULL
+233 466.0 NULL
+233 466.0 NULL
+235 235.0 NULL
+237 474.0 NULL
+237 474.0 NULL
+238 476.0 NULL
+238 476.0 NULL
+239 478.0 NULL
+239 478.0 NULL
+24 48.0 NULL
+24 48.0 NULL
+241 241.0 NULL
+242 484.0 NULL
+242 484.0 NULL
+244 244.0 NULL
+247 247.0 NULL
+248 248.0 NULL
+249 249.0 NULL
+252 252.0 NULL
+255 510.0 NULL
+255 510.0 NULL
+256 512.0 NULL
+256 512.0 NULL
+257 257.0 NULL
+258 258.0 NULL
+26 52.0 NULL
+26 52.0 NULL
+260 260.0 NULL
+262 262.0 NULL
+263 263.0 NULL
+265 530.0 NULL
+265 530.0 NULL
+266 266.0 NULL
+27 27.0 NULL
+272 544.0 NULL
+272 544.0 NULL
+273 819.0 NULL
+273 819.0 NULL
+273 819.0 NULL
+274 274.0 NULL
+275 275.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+277 1108.0 NULL
+278 556.0 NULL
+278 556.0 NULL
+28 28.0 NULL
+280 560.0 NULL
+280 560.0 NULL
+281 562.0 NULL
+281 562.0 NULL
+282 564.0 NULL
+282 564.0 NULL
+283 283.0 NULL
+284 284.0 NULL
+285 285.0 NULL
+286 286.0 NULL
+287 287.0 NULL
+288 576.0 NULL
+288 576.0 NULL
+289 289.0 NULL
+291 291.0 NULL
+292 292.0 NULL
+296 296.0 NULL
+298 894.0 NULL
+298 894.0 NULL
+298 894.0 NULL
+30 30.0 NULL
+302 302.0 NULL
+305 305.0 NULL
+306 306.0 NULL
+307 614.0 NULL
+307 614.0 NULL
+308 308.0 NULL
+309 618.0 NULL
+309 618.0 NULL
+310 310.0 NULL
+311 933.0 NULL
+311 933.0 NULL
+311 933.0 NULL
+315 315.0 NULL
+316 948.0 NULL
+316 948.0 NULL
+316 948.0 NULL
+317 634.0 NULL
+317 634.0 NULL
+318 954.0 NULL
+318 954.0 NULL
+318 954.0 NULL
+321 642.0 NULL
+321 642.0 NULL
+322 644.0 NULL
+322 644.0 NULL
+323 323.0 NULL
+325 650.0 NULL
+325 650.0 NULL
+327 981.0 NULL
+327 981.0 NULL
+327 981.0 NULL
+33 33.0 NULL
+331 662.0 NULL
+331 662.0 NULL
+332 332.0 NULL
+333 666.0 NULL
+333 666.0 NULL
+335 335.0 NULL
+336 336.0 NULL
+338 338.0 NULL
+339 339.0 NULL
+34 34.0 NULL
+341 341.0 NULL
+342 684.0 NULL
+342 684.0 NULL
+344 688.0 NULL
+344 688.0 NULL
+345 345.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+348 1740.0 NULL
+35 105.0 NULL
+35 105.0 NULL
+35 105.0 NULL
+351 351.0 NULL
+353 706.0 NULL
+353 706.0 NULL
+356 356.0 NULL
+360 360.0 NULL
+362 362.0 NULL
+364 364.0 NULL
+365 365.0 NULL
+366 366.0 NULL
+367 734.0 NULL
+367 734.0 NULL
+368 368.0 NULL
+369 1107.0 NULL
+369 1107.0 NULL
+369 1107.0 NULL
+37 74.0 NULL
+37 74.0 NULL
+373 373.0 NULL
+374 374.0 NULL
+375 375.0 NULL
+377 377.0 NULL
+378 378.0 NULL
+379 379.0 NULL
+382 764.0 NULL
+382 764.0 NULL
+384 1152.0 NULL
+384 1152.0 NULL
+384 1152.0 NULL
+386 386.0 NULL
+389 389.0 NULL
+392 392.0 NULL
+393 393.0 NULL
+394 394.0 NULL
+395 790.0 NULL
+395 790.0 NULL
+396 1188.0 NULL
+396 1188.0 NULL
+396 1188.0 NULL
+397 794.0 NULL
+397 794.0 NULL
+399 798.0 NULL
+399 798.0 NULL
+4 4.0 NULL
+400 400.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+401 2005.0 NULL
+402 402.0 NULL
+403 1209.0 NULL
+403 1209.0 NULL
+403 1209.0 NULL
+404 808.0 NULL
+404 808.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+406 1624.0 NULL
+407 407.0 NULL
+409 1227.0 NULL
+409 1227.0 NULL
+409 1227.0 NULL
+41 41.0 NULL
+411 411.0 NULL
+413 826.0 NULL
+413 826.0 NULL
+414 828.0 NULL
+414 828.0 NULL
+417 1251.0 NULL
+417 1251.0 NULL
+417 1251.0 NULL
+418 418.0 NULL
+419 419.0 NULL
+42 84.0 NULL
+42 84.0 NULL
+421 421.0 NULL
+424 848.0 NULL
+424 848.0 NULL
+427 427.0 NULL
+429 858.0 NULL
+429 858.0 NULL
+43 43.0 NULL
+430 1290.0 NULL
+430 1290.0 NULL
+430 1290.0 NULL
+431 1293.0 NULL
+431 1293.0 NULL
+431 1293.0 NULL
+432 432.0 NULL
+435 435.0 NULL
+436 436.0 NULL
+437 437.0 NULL
+438 1314.0 NULL
+438 1314.0 NULL
+438 1314.0 NULL
+439 878.0 NULL
+439 878.0 NULL
+44 44.0 NULL
+443 443.0 NULL
+444 444.0 NULL
+446 446.0 NULL
+448 448.0 NULL
+449 449.0 NULL
+452 452.0 NULL
+453 453.0 NULL
+454 1362.0 NULL
+454 1362.0 NULL
+454 1362.0 NULL
+455 455.0 NULL
+457 457.0 NULL
+458 916.0 NULL
+458 916.0 NULL
+459 918.0 NULL
+459 918.0 NULL
+460 460.0 NULL
+462 924.0 NULL
+462 924.0 NULL
+463 926.0 NULL
+463 926.0 NULL
+466 1398.0 NULL
+466 1398.0 NULL
+466 1398.0 NULL
+467 467.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+468 1872.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+469 2345.0 NULL
+47 47.0 NULL
+470 470.0 NULL
+472 472.0 NULL
+475 475.0 NULL
+477 477.0 NULL
+478 956.0 NULL
+478 956.0 NULL
+479 479.0 NULL
+480 1440.0 NULL
+480 1440.0 NULL
+480 1440.0 NULL
+481 481.0 NULL
+482 482.0 NULL
+483 483.0 NULL
+484 484.0 NULL
+485 485.0 NULL
+487 487.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+489 1956.0 NULL
+490 490.0 NULL
+491 491.0 NULL
+492 984.0 NULL
+492 984.0 NULL
+493 493.0 NULL
+494 494.0 NULL
+495 495.0 NULL
+496 496.0 NULL
+497 497.0 NULL
+498 1494.0 NULL
+498 1494.0 NULL
+498 1494.0 NULL
+5 15.0 NULL
+5 15.0 NULL
+5 15.0 NULL
+51 102.0 NULL
+51 102.0 NULL
+53 53.0 NULL
+54 54.0 NULL
+57 57.0 NULL
+58 116.0 NULL
+58 116.0 NULL
+64 64.0 NULL
+65 65.0 NULL
+66 66.0 NULL
+67 134.0 NULL
+67 134.0 NULL
+69 69.0 NULL
+70 210.0 NULL
+70 210.0 NULL
+70 210.0 NULL
+72 144.0 NULL
+72 144.0 NULL
+74 74.0 NULL
+76 152.0 NULL
+76 152.0 NULL
+77 77.0 NULL
+78 78.0 NULL
+8 8.0 NULL
+80 80.0 NULL
+82 82.0 NULL
+83 166.0 NULL
+83 166.0 NULL
+84 168.0 NULL
+84 168.0 NULL
+85 85.0 NULL
+86 86.0 NULL
+87 87.0 NULL
+9 9.0 NULL
+90 270.0 NULL
+90 270.0 NULL
+90 270.0 NULL
+92 92.0 NULL
+95 190.0 NULL
+95 190.0 NULL
+96 96.0 NULL
+97 194.0 NULL
+97 194.0 NULL
+98 196.0 NULL
+98 196.0 NULL
PREHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key)
over(partition by key,value) as c1, sum(value) over(partition by key) as c2
from src)r1 where (cast(key as int) + 1) > 2
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -8130,506 +8130,506 @@ POSTHOOK: query: select * from (SELECT (cast(key as
int))+2 as key, sum(key) ove
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-10 8.0 0.0
-100 196.0 0.0
-100 196.0 0.0
-102 200.0 0.0
-102 200.0 0.0
-105 206.0 0.0
-105 206.0 0.0
-106 208.0 0.0
-106 208.0 0.0
-107 105.0 0.0
-11 9.0 0.0
-113 111.0 0.0
-115 226.0 0.0
-115 226.0 0.0
-116 114.0 0.0
-118 116.0 0.0
-12 10.0 0.0
-120 236.0 0.0
-120 236.0 0.0
-121 357.0 0.0
-121 357.0 0.0
-121 357.0 0.0
-122 240.0 0.0
-122 240.0 0.0
-127 250.0 0.0
-127 250.0 0.0
-128 126.0 0.0
-13 11.0 0.0
-130 384.0 0.0
-130 384.0 0.0
-130 384.0 0.0
-131 258.0 0.0
-131 258.0 0.0
-133 131.0 0.0
-135 133.0 0.0
-136 268.0 0.0
-136 268.0 0.0
-138 136.0 0.0
-139 274.0 0.0
-139 274.0 0.0
-14 24.0 0.0
-14 24.0 0.0
-140 552.0 0.0
-140 552.0 0.0
-140 552.0 0.0
-140 552.0 0.0
-145 143.0 0.0
-147 145.0 0.0
-148 292.0 0.0
-148 292.0 0.0
-151 298.0 0.0
-151 298.0 0.0
-152 150.0 0.0
-154 304.0 0.0
-154 304.0 0.0
-155 153.0 0.0
-157 155.0 0.0
-158 156.0 0.0
-159 157.0 0.0
-160 158.0 0.0
-162 160.0 0.0
-164 162.0 0.0
-165 163.0 0.0
-166 328.0 0.0
-166 328.0 0.0
-167 330.0 0.0
-167 330.0 0.0
-168 166.0 0.0
-169 501.0 0.0
-169 501.0 0.0
-169 501.0 0.0
-17 30.0 0.0
-17 30.0 0.0
-170 168.0 0.0
-171 676.0 0.0
-171 676.0 0.0
-171 676.0 0.0
-171 676.0 0.0
-172 170.0 0.0
-174 344.0 0.0
-174 344.0 0.0
-176 348.0 0.0
-176 348.0 0.0
-177 350.0 0.0
-177 350.0 0.0
-178 352.0 0.0
-178 352.0 0.0
-179 177.0 0.0
-180 178.0 0.0
-181 358.0 0.0
-181 358.0 0.0
-182 180.0 0.0
-183 181.0 0.0
-185 183.0 0.0
-188 186.0 0.0
-189 561.0 0.0
-189 561.0 0.0
-189 561.0 0.0
-19 17.0 0.0
-191 189.0 0.0
-192 190.0 0.0
-193 382.0 0.0
-193 382.0 0.0
-194 192.0 0.0
-195 579.0 0.0
-195 579.0 0.0
-195 579.0 0.0
-196 194.0 0.0
-197 390.0 0.0
-197 390.0 0.0
-198 196.0 0.0
-199 394.0 0.0
-199 394.0 0.0
-2 0.0 0.0
-2 0.0 0.0
-2 0.0 0.0
-20 36.0 0.0
-20 36.0 0.0
-201 597.0 0.0
-201 597.0 0.0
-201 597.0 0.0
-202 400.0 0.0
-202 400.0 0.0
-203 201.0 0.0
-204 202.0 0.0
-205 406.0 0.0
-205 406.0 0.0
-207 410.0 0.0
-207 410.0 0.0
-209 414.0 0.0
-209 414.0 0.0
-21 19.0 0.0
-210 624.0 0.0
-210 624.0 0.0
-210 624.0 0.0
-211 418.0 0.0
-211 418.0 0.0
-215 426.0 0.0
-215 426.0 0.0
-216 214.0 0.0
-218 432.0 0.0
-218 432.0 0.0
-219 434.0 0.0
-219 434.0 0.0
-22 20.0 0.0
-220 218.0 0.0
-221 438.0 0.0
-221 438.0 0.0
-223 442.0 0.0
-223 442.0 0.0
-224 222.0 0.0
-225 446.0 0.0
-225 446.0 0.0
-226 448.0 0.0
-226 448.0 0.0
-228 226.0 0.0
-230 228.0 0.0
-231 458.0 0.0
-231 458.0 0.0
-232 1150.0 0.0
-232 1150.0 0.0
-232 1150.0 0.0
-232 1150.0 0.0
-232 1150.0 0.0
-235 466.0 0.0
-235 466.0 0.0
-237 235.0 0.0
-239 474.0 0.0
-239 474.0 0.0
-240 476.0 0.0
-240 476.0 0.0
-241 478.0 0.0
-241 478.0 0.0
-243 241.0 0.0
-244 484.0 0.0
-244 484.0 0.0
-246 244.0 0.0
-249 247.0 0.0
-250 248.0 0.0
-251 249.0 0.0
-254 252.0 0.0
-257 510.0 0.0
-257 510.0 0.0
-258 512.0 0.0
-258 512.0 0.0
-259 257.0 0.0
-26 48.0 0.0
-26 48.0 0.0
-260 258.0 0.0
-262 260.0 0.0
-264 262.0 0.0
-265 263.0 0.0
-267 530.0 0.0
-267 530.0 0.0
-268 266.0 0.0
-274 544.0 0.0
-274 544.0 0.0
-275 819.0 0.0
-275 819.0 0.0
-275 819.0 0.0
-276 274.0 0.0
-277 275.0 0.0
-279 1108.0 0.0
-279 1108.0 0.0
-279 1108.0 0.0
-279 1108.0 0.0
-28 52.0 0.0
-28 52.0 0.0
-280 556.0 0.0
-280 556.0 0.0
-282 560.0 0.0
-282 560.0 0.0
-283 562.0 0.0
-283 562.0 0.0
-284 564.0 0.0
-284 564.0 0.0
-285 283.0 0.0
-286 284.0 0.0
-287 285.0 0.0
-288 286.0 0.0
-289 287.0 0.0
-29 27.0 0.0
-290 576.0 0.0
-290 576.0 0.0
-291 289.0 0.0
-293 291.0 0.0
-294 292.0 0.0
-298 296.0 0.0
-30 28.0 0.0
-300 894.0 0.0
-300 894.0 0.0
-300 894.0 0.0
-304 302.0 0.0
-307 305.0 0.0
-308 306.0 0.0
-309 614.0 0.0
-309 614.0 0.0
-310 308.0 0.0
-311 618.0 0.0
-311 618.0 0.0
-312 310.0 0.0
-313 933.0 0.0
-313 933.0 0.0
-313 933.0 0.0
-317 315.0 0.0
-318 948.0 0.0
-318 948.0 0.0
-318 948.0 0.0
-319 634.0 0.0
-319 634.0 0.0
-32 30.0 0.0
-320 954.0 0.0
-320 954.0 0.0
-320 954.0 0.0
-323 642.0 0.0
-323 642.0 0.0
-324 644.0 0.0
-324 644.0 0.0
-325 323.0 0.0
-327 650.0 0.0
-327 650.0 0.0
-329 981.0 0.0
-329 981.0 0.0
-329 981.0 0.0
-333 662.0 0.0
-333 662.0 0.0
-334 332.0 0.0
-335 666.0 0.0
-335 666.0 0.0
-337 335.0 0.0
-338 336.0 0.0
-340 338.0 0.0
-341 339.0 0.0
-343 341.0 0.0
-344 684.0 0.0
-344 684.0 0.0
-346 688.0 0.0
-346 688.0 0.0
-347 345.0 0.0
-35 33.0 0.0
-350 1740.0 0.0
-350 1740.0 0.0
-350 1740.0 0.0
-350 1740.0 0.0
-350 1740.0 0.0
-353 351.0 0.0
-355 706.0 0.0
-355 706.0 0.0
-358 356.0 0.0
-36 34.0 0.0
-362 360.0 0.0
-364 362.0 0.0
-366 364.0 0.0
-367 365.0 0.0
-368 366.0 0.0
-369 734.0 0.0
-369 734.0 0.0
-37 105.0 0.0
-37 105.0 0.0
-37 105.0 0.0
-370 368.0 0.0
-371 1107.0 0.0
-371 1107.0 0.0
-371 1107.0 0.0
-375 373.0 0.0
-376 374.0 0.0
-377 375.0 0.0
-379 377.0 0.0
-380 378.0 0.0
-381 379.0 0.0
-384 764.0 0.0
-384 764.0 0.0
-386 1152.0 0.0
-386 1152.0 0.0
-386 1152.0 0.0
-388 386.0 0.0
-39 74.0 0.0
-39 74.0 0.0
-391 389.0 0.0
-394 392.0 0.0
-395 393.0 0.0
-396 394.0 0.0
-397 790.0 0.0
-397 790.0 0.0
-398 1188.0 0.0
-398 1188.0 0.0
-398 1188.0 0.0
-399 794.0 0.0
-399 794.0 0.0
-4 2.0 0.0
-401 798.0 0.0
-401 798.0 0.0
-402 400.0 0.0
-403 2005.0 0.0
-403 2005.0 0.0
-403 2005.0 0.0
-403 2005.0 0.0
-403 2005.0 0.0
-404 402.0 0.0
-405 1209.0 0.0
-405 1209.0 0.0
-405 1209.0 0.0
-406 808.0 0.0
-406 808.0 0.0
-408 1624.0 0.0
-408 1624.0 0.0
-408 1624.0 0.0
-408 1624.0 0.0
-409 407.0 0.0
-411 1227.0 0.0
-411 1227.0 0.0
-411 1227.0 0.0
-413 411.0 0.0
-415 826.0 0.0
-415 826.0 0.0
-416 828.0 0.0
-416 828.0 0.0
-419 1251.0 0.0
-419 1251.0 0.0
-419 1251.0 0.0
-420 418.0 0.0
-421 419.0 0.0
-423 421.0 0.0
-426 848.0 0.0
-426 848.0 0.0
-429 427.0 0.0
-43 41.0 0.0
-431 858.0 0.0
-431 858.0 0.0
-432 1290.0 0.0
-432 1290.0 0.0
-432 1290.0 0.0
-433 1293.0 0.0
-433 1293.0 0.0
-433 1293.0 0.0
-434 432.0 0.0
-437 435.0 0.0
-438 436.0 0.0
-439 437.0 0.0
-44 84.0 0.0
-44 84.0 0.0
-440 1314.0 0.0
-440 1314.0 0.0
-440 1314.0 0.0
-441 878.0 0.0
-441 878.0 0.0
-445 443.0 0.0
-446 444.0 0.0
-448 446.0 0.0
-45 43.0 0.0
-450 448.0 0.0
-451 449.0 0.0
-454 452.0 0.0
-455 453.0 0.0
-456 1362.0 0.0
-456 1362.0 0.0
-456 1362.0 0.0
-457 455.0 0.0
-459 457.0 0.0
-46 44.0 0.0
-460 916.0 0.0
-460 916.0 0.0
-461 918.0 0.0
-461 918.0 0.0
-462 460.0 0.0
-464 924.0 0.0
-464 924.0 0.0
-465 926.0 0.0
-465 926.0 0.0
-468 1398.0 0.0
-468 1398.0 0.0
-468 1398.0 0.0
-469 467.0 0.0
-470 1872.0 0.0
-470 1872.0 0.0
-470 1872.0 0.0
-470 1872.0 0.0
-471 2345.0 0.0
-471 2345.0 0.0
-471 2345.0 0.0
-471 2345.0 0.0
-471 2345.0 0.0
-472 470.0 0.0
-474 472.0 0.0
-477 475.0 0.0
-479 477.0 0.0
-480 956.0 0.0
-480 956.0 0.0
-481 479.0 0.0
-482 1440.0 0.0
-482 1440.0 0.0
-482 1440.0 0.0
-483 481.0 0.0
-484 482.0 0.0
-485 483.0 0.0
-486 484.0 0.0
-487 485.0 0.0
-489 487.0 0.0
-49 47.0 0.0
-491 1956.0 0.0
-491 1956.0 0.0
-491 1956.0 0.0
-491 1956.0 0.0
-492 490.0 0.0
-493 491.0 0.0
-494 984.0 0.0
-494 984.0 0.0
-495 493.0 0.0
-496 494.0 0.0
-497 495.0 0.0
-498 496.0 0.0
-499 497.0 0.0
-500 1494.0 0.0
-500 1494.0 0.0
-500 1494.0 0.0
-53 102.0 0.0
-53 102.0 0.0
-55 53.0 0.0
-56 54.0 0.0
-59 57.0 0.0
-6 4.0 0.0
-60 116.0 0.0
-60 116.0 0.0
-66 64.0 0.0
-67 65.0 0.0
-68 66.0 0.0
-69 134.0 0.0
-69 134.0 0.0
-7 15.0 0.0
-7 15.0 0.0
-7 15.0 0.0
-71 69.0 0.0
-72 210.0 0.0
-72 210.0 0.0
-72 210.0 0.0
-74 144.0 0.0
-74 144.0 0.0
-76 74.0 0.0
-78 152.0 0.0
-78 152.0 0.0
-79 77.0 0.0
-80 78.0 0.0
-82 80.0 0.0
-84 82.0 0.0
-85 166.0 0.0
-85 166.0 0.0
-86 168.0 0.0
-86 168.0 0.0
-87 85.0 0.0
-88 86.0 0.0
-89 87.0 0.0
-92 270.0 0.0
-92 270.0 0.0
-92 270.0 0.0
-94 92.0 0.0
-97 190.0 0.0
-97 190.0 0.0
-98 96.0 0.0
-99 194.0 0.0
-99 194.0 0.0
+10 8.0 NULL
+100 196.0 NULL
+100 196.0 NULL
+102 200.0 NULL
+102 200.0 NULL
+105 206.0 NULL
+105 206.0 NULL
+106 208.0 NULL
+106 208.0 NULL
+107 105.0 NULL
+11 9.0 NULL
+113 111.0 NULL
+115 226.0 NULL
+115 226.0 NULL
+116 114.0 NULL
+118 116.0 NULL
+12 10.0 NULL
+120 236.0 NULL
+120 236.0 NULL
+121 357.0 NULL
+121 357.0 NULL
+121 357.0 NULL
+122 240.0 NULL
+122 240.0 NULL
+127 250.0 NULL
+127 250.0 NULL
+128 126.0 NULL
+13 11.0 NULL
+130 384.0 NULL
+130 384.0 NULL
+130 384.0 NULL
+131 258.0 NULL
+131 258.0 NULL
+133 131.0 NULL
+135 133.0 NULL
+136 268.0 NULL
+136 268.0 NULL
+138 136.0 NULL
+139 274.0 NULL
+139 274.0 NULL
+14 24.0 NULL
+14 24.0 NULL
+140 552.0 NULL
+140 552.0 NULL
+140 552.0 NULL
+140 552.0 NULL
+145 143.0 NULL
+147 145.0 NULL
+148 292.0 NULL
+148 292.0 NULL
+151 298.0 NULL
+151 298.0 NULL
+152 150.0 NULL
+154 304.0 NULL
+154 304.0 NULL
+155 153.0 NULL
+157 155.0 NULL
+158 156.0 NULL
+159 157.0 NULL
+160 158.0 NULL
+162 160.0 NULL
+164 162.0 NULL
+165 163.0 NULL
+166 328.0 NULL
+166 328.0 NULL
+167 330.0 NULL
+167 330.0 NULL
+168 166.0 NULL
+169 501.0 NULL
+169 501.0 NULL
+169 501.0 NULL
+17 30.0 NULL
+17 30.0 NULL
+170 168.0 NULL
+171 676.0 NULL
+171 676.0 NULL
+171 676.0 NULL
+171 676.0 NULL
+172 170.0 NULL
+174 344.0 NULL
+174 344.0 NULL
+176 348.0 NULL
+176 348.0 NULL
+177 350.0 NULL
+177 350.0 NULL
+178 352.0 NULL
+178 352.0 NULL
+179 177.0 NULL
+180 178.0 NULL
+181 358.0 NULL
+181 358.0 NULL
+182 180.0 NULL
+183 181.0 NULL
+185 183.0 NULL
+188 186.0 NULL
+189 561.0 NULL
+189 561.0 NULL
+189 561.0 NULL
+19 17.0 NULL
+191 189.0 NULL
+192 190.0 NULL
+193 382.0 NULL
+193 382.0 NULL
+194 192.0 NULL
+195 579.0 NULL
+195 579.0 NULL
+195 579.0 NULL
+196 194.0 NULL
+197 390.0 NULL
+197 390.0 NULL
+198 196.0 NULL
+199 394.0 NULL
+199 394.0 NULL
+2 0.0 NULL
+2 0.0 NULL
+2 0.0 NULL
+20 36.0 NULL
+20 36.0 NULL
+201 597.0 NULL
+201 597.0 NULL
+201 597.0 NULL
+202 400.0 NULL
+202 400.0 NULL
+203 201.0 NULL
+204 202.0 NULL
+205 406.0 NULL
+205 406.0 NULL
+207 410.0 NULL
+207 410.0 NULL
+209 414.0 NULL
+209 414.0 NULL
+21 19.0 NULL
+210 624.0 NULL
+210 624.0 NULL
+210 624.0 NULL
+211 418.0 NULL
+211 418.0 NULL
+215 426.0 NULL
+215 426.0 NULL
+216 214.0 NULL
+218 432.0 NULL
+218 432.0 NULL
+219 434.0 NULL
+219 434.0 NULL
+22 20.0 NULL
+220 218.0 NULL
+221 438.0 NULL
+221 438.0 NULL
+223 442.0 NULL
+223 442.0 NULL
+224 222.0 NULL
+225 446.0 NULL
+225 446.0 NULL
+226 448.0 NULL
+226 448.0 NULL
+228 226.0 NULL
+230 228.0 NULL
+231 458.0 NULL
+231 458.0 NULL
+232 1150.0 NULL
+232 1150.0 NULL
+232 1150.0 NULL
+232 1150.0 NULL
+232 1150.0 NULL
+235 466.0 NULL
+235 466.0 NULL
+237 235.0 NULL
+239 474.0 NULL
+239 474.0 NULL
+240 476.0 NULL
+240 476.0 NULL
+241 478.0 NULL
+241 478.0 NULL
+243 241.0 NULL
+244 484.0 NULL
+244 484.0 NULL
+246 244.0 NULL
+249 247.0 NULL
+250 248.0 NULL
+251 249.0 NULL
+254 252.0 NULL
+257 510.0 NULL
+257 510.0 NULL
+258 512.0 NULL
+258 512.0 NULL
+259 257.0 NULL
+26 48.0 NULL
+26 48.0 NULL
+260 258.0 NULL
+262 260.0 NULL
+264 262.0 NULL
+265 263.0 NULL
+267 530.0 NULL
+267 530.0 NULL
+268 266.0 NULL
+274 544.0 NULL
+274 544.0 NULL
+275 819.0 NULL
+275 819.0 NULL
+275 819.0 NULL
+276 274.0 NULL
+277 275.0 NULL
+279 1108.0 NULL
+279 1108.0 NULL
+279 1108.0 NULL
+279 1108.0 NULL
+28 52.0 NULL
+28 52.0 NULL
+280 556.0 NULL
+280 556.0 NULL
+282 560.0 NULL
+282 560.0 NULL
+283 562.0 NULL
+283 562.0 NULL
+284 564.0 NULL
+284 564.0 NULL
+285 283.0 NULL
+286 284.0 NULL
+287 285.0 NULL
+288 286.0 NULL
+289 287.0 NULL
+29 27.0 NULL
+290 576.0 NULL
+290 576.0 NULL
+291 289.0 NULL
+293 291.0 NULL
+294 292.0 NULL
+298 296.0 NULL
+30 28.0 NULL
+300 894.0 NULL
+300 894.0 NULL
+300 894.0 NULL
+304 302.0 NULL
+307 305.0 NULL
+308 306.0 NULL
+309 614.0 NULL
+309 614.0 NULL
+310 308.0 NULL
+311 618.0 NULL
+311 618.0 NULL
+312 310.0 NULL
+313 933.0 NULL
+313 933.0 NULL
+313 933.0 NULL
+317 315.0 NULL
+318 948.0 NULL
+318 948.0 NULL
+318 948.0 NULL
+319 634.0 NULL
+319 634.0 NULL
+32 30.0 NULL
+320 954.0 NULL
+320 954.0 NULL
+320 954.0 NULL
+323 642.0 NULL
+323 642.0 NULL
+324 644.0 NULL
+324 644.0 NULL
+325 323.0 NULL
+327 650.0 NULL
+327 650.0 NULL
+329 981.0 NULL
+329 981.0 NULL
+329 981.0 NULL
+333 662.0 NULL
+333 662.0 NULL
+334 332.0 NULL
+335 666.0 NULL
+335 666.0 NULL
+337 335.0 NULL
+338 336.0 NULL
+340 338.0 NULL
+341 339.0 NULL
+343 341.0 NULL
+344 684.0 NULL
+344 684.0 NULL
+346 688.0 NULL
+346 688.0 NULL
+347 345.0 NULL
+35 33.0 NULL
+350 1740.0 NULL
+350 1740.0 NULL
+350 1740.0 NULL
+350 1740.0 NULL
+350 1740.0 NULL
+353 351.0 NULL
+355 706.0 NULL
+355 706.0 NULL
+358 356.0 NULL
+36 34.0 NULL
+362 360.0 NULL
+364 362.0 NULL
+366 364.0 NULL
+367 365.0 NULL
+368 366.0 NULL
+369 734.0 NULL
+369 734.0 NULL
+37 105.0 NULL
+37 105.0 NULL
+37 105.0 NULL
+370 368.0 NULL
+371 1107.0 NULL
+371 1107.0 NULL
+371 1107.0 NULL
+375 373.0 NULL
+376 374.0 NULL
+377 375.0 NULL
+379 377.0 NULL
+380 378.0 NULL
+381 379.0 NULL
+384 764.0 NULL
+384 764.0 NULL
+386 1152.0 NULL
+386 1152.0 NULL
+386 1152.0 NULL
+388 386.0 NULL
+39 74.0 NULL
+39 74.0 NULL
+391 389.0 NULL
+394 392.0 NULL
+395 393.0 NULL
+396 394.0 NULL
+397 790.0 NULL
+397 790.0 NULL
+398 1188.0 NULL
+398 1188.0 NULL
+398 1188.0 NULL
+399 794.0 NULL
+399 794.0 NULL
+4 2.0 NULL
+401 798.0 NULL
+401 798.0 NULL
+402 400.0 NULL
+403 2005.0 NULL
+403 2005.0 NULL
+403 2005.0 NULL
+403 2005.0 NULL
+403 2005.0 NULL
+404 402.0 NULL
+405 1209.0 NULL
+405 1209.0 NULL
+405 1209.0 NULL
+406 808.0 NULL
+406 808.0 NULL
+408 1624.0 NULL
+408 1624.0 NULL
+408 1624.0 NULL
+408 1624.0 NULL
+409 407.0 NULL
+411 1227.0 NULL
+411 1227.0 NULL
+411 1227.0 NULL
+413 411.0 NULL
+415 826.0 NULL
+415 826.0 NULL
+416 828.0 NULL
+416 828.0 NULL
+419 1251.0 NULL
+419 1251.0 NULL
+419 1251.0 NULL
+420 418.0 NULL
+421 419.0 NULL
+423 421.0 NULL
+426 848.0 NULL
+426 848.0 NULL
+429 427.0 NULL
+43 41.0 NULL
+431 858.0 NULL
+431 858.0 NULL
+432 1290.0 NULL
+432 1290.0 NULL
+432 1290.0 NULL
+433 1293.0 NULL
+433 1293.0 NULL
+433 1293.0 NULL
+434 432.0 NULL
+437 435.0 NULL
+438 436.0 NULL
+439 437.0 NULL
+44 84.0 NULL
+44 84.0 NULL
+440 1314.0 NULL
+440 1314.0 NULL
+440 1314.0 NULL
+441 878.0 NULL
+441 878.0 NULL
+445 443.0 NULL
+446 444.0 NULL
+448 446.0 NULL
+45 43.0 NULL
+450 448.0 NULL
+451 449.0 NULL
+454 452.0 NULL
+455 453.0 NULL
+456 1362.0 NULL
+456 1362.0 NULL
+456 1362.0 NULL
+457 455.0 NULL
+459 457.0 NULL
+46 44.0 NULL
+460 916.0 NULL
+460 916.0 NULL
+461 918.0 NULL
+461 918.0 NULL
+462 460.0 NULL
+464 924.0 NULL
+464 924.0 NULL
+465 926.0 NULL
+465 926.0 NULL
+468 1398.0 NULL
+468 1398.0 NULL
+468 1398.0 NULL
+469 467.0 NULL
+470 1872.0 NULL
+470 1872.0 NULL
+470 1872.0 NULL
+470 1872.0 NULL
+471 2345.0 NULL
+471 2345.0 NULL
+471 2345.0 NULL
+471 2345.0 NULL
+471 2345.0 NULL
+472 470.0 NULL
+474 472.0 NULL
+477 475.0 NULL
+479 477.0 NULL
+480 956.0 NULL
+480 956.0 NULL
+481 479.0 NULL
+482 1440.0 NULL
+482 1440.0 NULL
+482 1440.0 NULL
+483 481.0 NULL
+484 482.0 NULL
+485 483.0 NULL
+486 484.0 NULL
+487 485.0 NULL
+489 487.0 NULL
+49 47.0 NULL
+491 1956.0 NULL
+491 1956.0 NULL
+491 1956.0 NULL
+491 1956.0 NULL
+492 490.0 NULL
+493 491.0 NULL
+494 984.0 NULL
+494 984.0 NULL
+495 493.0 NULL
+496 494.0 NULL
+497 495.0 NULL
+498 496.0 NULL
+499 497.0 NULL
+500 1494.0 NULL
+500 1494.0 NULL
+500 1494.0 NULL
+53 102.0 NULL
+53 102.0 NULL
+55 53.0 NULL
+56 54.0 NULL
+59 57.0 NULL
+6 4.0 NULL
+60 116.0 NULL
+60 116.0 NULL
+66 64.0 NULL
+67 65.0 NULL
+68 66.0 NULL
+69 134.0 NULL
+69 134.0 NULL
+7 15.0 NULL
+7 15.0 NULL
+7 15.0 NULL
+71 69.0 NULL
+72 210.0 NULL
+72 210.0 NULL
+72 210.0 NULL
+74 144.0 NULL
+74 144.0 NULL
+76 74.0 NULL
+78 152.0 NULL
+78 152.0 NULL
+79 77.0 NULL
+80 78.0 NULL
+82 80.0 NULL
+84 82.0 NULL
+85 166.0 NULL
+85 166.0 NULL
+86 168.0 NULL
+86 168.0 NULL
+87 85.0 NULL
+88 86.0 NULL
+89 87.0 NULL
+92 270.0 NULL
+92 270.0 NULL
+92 270.0 NULL
+94 92.0 NULL
+97 190.0 NULL
+97 190.0 NULL
+98 96.0 NULL
+99 194.0 NULL
+99 194.0 NULL
PREHOOK: query: select * from (SELECT key, sum(key) over(partition by
key,value) as c1, avg(value) over(partition by value) as c2 from src)r1 where
key > '2'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
diff --git a/ql/src/test/results/clientpositive/llap/udaf_number_format.q.out
b/ql/src/test/results/clientpositive/llap/udaf_number_format.q.out
index 94f4c3e8791..794d9581db1 100644
--- a/ql/src/test/results/clientpositive/llap/udaf_number_format.q.out
+++ b/ql/src/test/results/clientpositive/llap/udaf_number_format.q.out
@@ -92,4 +92,4 @@ FROM src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0.0 NULL NULL NULL
+NULL NULL NULL NULL
diff --git a/ql/src/test/results/clientpositive/llap/windowing_distinct.q.out
b/ql/src/test/results/clientpositive/llap/windowing_distinct.q.out
index e3412c1212c..205a862555a 100644
--- a/ql/src/test/results/clientpositive/llap/windowing_distinct.q.out
+++ b/ql/src/test/results/clientpositive/llap/windowing_distinct.q.out
@@ -469,12 +469,12 @@ FROM windowing_distinct
POSTHOOK: type: QUERY
POSTHOOK: Input: default@windowing_distinct
#### A masked pattern was here ####
-54 56.63 0.0 0.0 2.724258237406296E9 57
-54 56.63 0.0 0.0 2.724258237406296E9 57
-54 56.63 0.0 0.0 2.724258237406296E9 57
-235 77.42 0.0 0.0 2.724258237406612E9 69
-235 77.42 0.0 0.0 2.724258237406612E9 69
-235 77.42 0.0 0.0 2.724258237406612E9 69
+54 56.63 NULL NULL 2.724258237406296E9 57
+54 56.63 NULL NULL 2.724258237406296E9 57
+54 56.63 NULL NULL 2.724258237406296E9 57
+235 77.42 NULL NULL 2.724258237406612E9 69
+235 77.42 NULL NULL 2.724258237406612E9 69
+235 77.42 NULL NULL 2.724258237406612E9 69
PREHOOK: query: EXPLAIN CBO
SELECT AVG(DISTINCT t) OVER (PARTITION BY index),
AVG(DISTINCT d) OVER (PARTITION BY index),