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),

Reply via email to