http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer11.q.out b/ql/src/test/results/clientpositive/correlationoptimizer11.q.out index 57db64a..f0ce411 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer11.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer11.q.out @@ -55,6 +55,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((partitionid = 1) and key is not null) (type: boolean) Statistics: Num rows: 100 Data size: 1070 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -70,6 +71,7 @@ STAGE PLANS: Statistics: Num rows: 100 Data size: 1070 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((partitionid = 2) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -184,6 +186,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((partitionid = 1) and key is not null) (type: boolean) Statistics: Num rows: 100 Data size: 1070 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -199,6 +202,7 @@ STAGE PLANS: Statistics: Num rows: 100 Data size: 1070 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((partitionid = 2) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -293,6 +297,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((partitionid = 2) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -308,6 +313,7 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((partitionid = 2) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -433,6 +439,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((partitionid = 2) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -448,6 +455,7 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((partitionid = 2) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer12.q.out b/ql/src/test/results/clientpositive/correlationoptimizer12.q.out index d62fae3..e63595d 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer12.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer12.q.out @@ -24,6 +24,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -110,6 +111,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer13.q.out b/ql/src/test/results/clientpositive/correlationoptimizer13.q.out index de456fe..ada7921 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer13.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer13.q.out @@ -47,6 +47,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((c1 < 120) and c3 is not null) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and c3 is not null) (type: boolean) @@ -65,6 +66,7 @@ STAGE PLANS: value expressions: _col2 (type: bigint) TableScan alias: x1 + filterExpr: ((c2 > 100) and (c1 < 120) and c3 is not null) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and (c2 > 100) and c3 is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer14.q.out b/ql/src/test/results/clientpositive/correlationoptimizer14.q.out index da30b48..cca6892 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer14.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer14.q.out @@ -26,6 +26,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -91,6 +92,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -151,6 +153,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -216,6 +219,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -276,6 +280,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -342,6 +347,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -458,6 +464,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -474,6 +481,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -625,6 +633,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -691,6 +700,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -752,6 +762,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -817,6 +828,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -877,6 +889,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -943,6 +956,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -1059,6 +1073,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -1075,6 +1090,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -1226,6 +1242,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -1292,6 +1309,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -1412,6 +1430,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -1428,6 +1447,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer15.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer15.q.out b/ql/src/test/results/clientpositive/correlationoptimizer15.q.out index ffa3a28..6e3ea64 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer15.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer15.q.out @@ -25,6 +25,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -40,6 +41,7 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -112,6 +114,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: yy + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -248,6 +251,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -263,6 +267,7 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -278,6 +283,7 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE TableScan alias: yy + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out index 5fb6c13..aab38e5 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out @@ -117,6 +117,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: n + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -133,6 +134,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: m + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -223,6 +225,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -238,6 +241,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -324,6 +328,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: n + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -340,6 +345,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: m + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -355,6 +361,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -370,6 +377,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -536,6 +544,7 @@ STAGE PLANS: $hdt$_0:$hdt$_1:m TableScan alias: m + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -554,6 +563,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: n + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -733,6 +743,7 @@ STAGE PLANS: $hdt$_1:$hdt$_2:y TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -751,6 +762,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer7.q.out b/ql/src/test/results/clientpositive/correlationoptimizer7.q.out index bfb31e0..e03e669 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer7.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer7.q.out @@ -32,6 +32,7 @@ STAGE PLANS: $hdt$_0:$hdt$_1:y TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -50,6 +51,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -105,6 +107,7 @@ STAGE PLANS: $hdt$_1:yy TableScan alias: yy + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -214,6 +217,7 @@ STAGE PLANS: $hdt$_0:$hdt$_1:y TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -232,6 +236,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: yy + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -248,6 +253,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -397,6 +403,7 @@ STAGE PLANS: $hdt$_0:$hdt$_1:y TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -415,6 +422,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -470,6 +478,7 @@ STAGE PLANS: $hdt$_1:yy TableScan alias: yy + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -579,6 +588,7 @@ STAGE PLANS: $hdt$_0:$hdt$_1:y TableScan alias: y + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -597,6 +607,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: yy + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -613,6 +624,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: x + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out index 9aba806..102cc01 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out @@ -28,6 +28,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 20.0D) (type: boolean) @@ -82,6 +83,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: x + filterExpr: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean) @@ -122,6 +124,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x1 + filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 100.0D) (type: boolean) @@ -222,6 +225,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 20.0D) (type: boolean) @@ -240,6 +244,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: x1 + filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 100.0D) (type: boolean) @@ -258,6 +263,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: x + filterExpr: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean) @@ -426,6 +432,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 20.0D) (type: boolean) @@ -513,6 +520,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x1 + filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 100.0D) (type: boolean) @@ -637,6 +645,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 20.0D) (type: boolean) @@ -655,6 +664,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: x1 + filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 100.0D) (type: boolean) @@ -850,6 +860,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 20.0D) (type: boolean) @@ -904,6 +915,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: x + filterExpr: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean) @@ -944,6 +956,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x1 + filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 100.0D) (type: boolean) @@ -1016,6 +1029,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 20.0D) (type: boolean) @@ -1107,6 +1121,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x1 + filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 100.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out index 69d30c1..f8e75c2 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out @@ -48,6 +48,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((c1 < 120) and (c1 > 100)) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and (c1 > 100)) (type: boolean) @@ -122,6 +123,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x1 + filterExpr: ((c2 > 100) and (c2 < 120)) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c2 < 120) and (c2 > 100)) (type: boolean) @@ -212,6 +214,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((c1 < 120) and (c1 > 100)) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and (c1 > 100)) (type: boolean) @@ -230,6 +233,7 @@ STAGE PLANS: value expressions: _col1 (type: bigint) TableScan alias: x1 + filterExpr: ((c2 > 100) and (c2 < 120)) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c2 < 120) and (c2 > 100)) (type: boolean) @@ -365,6 +369,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((c1 < 120) and c3 is not null) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and c3 is not null) (type: boolean) @@ -439,6 +444,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x1 + filterExpr: ((c2 > 100) and (c1 < 120) and c3 is not null) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and (c2 > 100) and c3 is not null) (type: boolean) @@ -533,6 +539,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((c1 < 120) and c3 is not null) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and c3 is not null) (type: boolean) @@ -551,6 +558,7 @@ STAGE PLANS: value expressions: _col2 (type: bigint) TableScan alias: x1 + filterExpr: ((c2 > 100) and (c1 < 120) and c3 is not null) (type: boolean) Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((c1 < 120) and (c2 > 100) and c3 is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cp_sel.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cp_sel.q.out b/ql/src/test/results/clientpositive/cp_sel.q.out index dfb1f3d..8222156 100644 --- a/ql/src/test/results/clientpositive/cp_sel.q.out +++ b/ql/src/test/results/clientpositive/cp_sel.q.out @@ -14,6 +14,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (11.0D = 11.0D) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) @@ -91,6 +92,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (11.0D = 11.0D) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), 'hello' (type: string), 'world' (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/create_view.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_view.q.out b/ql/src/test/results/clientpositive/create_view.q.out index c7f0145..fa3fb95 100644 --- a/ql/src/test/results/clientpositive/create_view.q.out +++ b/ql/src/test/results/clientpositive/create_view.q.out @@ -189,6 +189,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) = 18.0D) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cross_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_join.q.out b/ql/src/test/results/clientpositive/cross_join.q.out index 40fb2e1..b9daa35 100644 --- a/ql/src/test/results/clientpositive/cross_join.q.out +++ b/ql/src/test/results/clientpositive/cross_join.q.out @@ -122,6 +122,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -137,6 +138,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -321,6 +323,7 @@ STAGE PLANS: $hdt$_0:src TableScan alias: src + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -339,6 +342,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cross_join_merge.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_join_merge.q.out b/ql/src/test/results/clientpositive/cross_join_merge.q.out index 3389638..016acc6 100644 --- a/ql/src/test/results/clientpositive/cross_join_merge.q.out +++ b/ql/src/test/results/clientpositive/cross_join_merge.q.out @@ -81,6 +81,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -96,6 +97,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -111,6 +113,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src3 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -165,6 +168,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -180,6 +184,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -195,6 +200,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src3 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -251,6 +257,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -266,6 +273,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src3 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -305,6 +313,7 @@ STAGE PLANS: value expressions: _col0 (type: string) TableScan alias: src2 + filterExpr: (UDFToDouble(key) = 5.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 5.0D) (type: boolean) @@ -444,6 +453,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -459,6 +469,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -474,6 +485,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src3 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cross_product_check_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_product_check_1.q.out b/ql/src/test/results/clientpositive/cross_product_check_1.q.out index 7fbcbe4..2d1eb7e 100644 --- a/ql/src/test/results/clientpositive/cross_product_check_1.q.out +++ b/ql/src/test/results/clientpositive/cross_product_check_1.q.out @@ -102,6 +102,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -118,6 +119,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: d2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -213,6 +215,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -228,6 +231,7 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE TableScan alias: d2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -534,6 +538,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -549,6 +554,7 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE TableScan alias: d2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cross_product_check_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_product_check_2.q.out b/ql/src/test/results/clientpositive/cross_product_check_2.q.out index 6143431..61c4074 100644 --- a/ql/src/test/results/clientpositive/cross_product_check_2.q.out +++ b/ql/src/test/results/clientpositive/cross_product_check_2.q.out @@ -118,6 +118,7 @@ STAGE PLANS: $hdt$_0:d1 TableScan alias: d1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -148,6 +149,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -218,6 +220,7 @@ STAGE PLANS: $hdt$_1:$hdt$_1:d1 TableScan alias: d1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -236,6 +239,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -627,6 +631,7 @@ STAGE PLANS: $hdt$_1:$hdt$_1:d1 TableScan alias: d1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -645,6 +650,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/ctas_colname.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ctas_colname.q.out b/ql/src/test/results/clientpositive/ctas_colname.q.out index b3a4992..ff1fd8d 100644 --- a/ql/src/test/results/clientpositive/ctas_colname.q.out +++ b/ql/src/test/results/clientpositive/ctas_colname.q.out @@ -1132,6 +1132,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) < 9.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 9.0D) (type: boolean) @@ -1264,6 +1265,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) < 9.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 9.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_1.q.out b/ql/src/test/results/clientpositive/cte_1.q.out index ecace0f..0edfeb7 100644 --- a/ql/src/test/results/clientpositive/cte_1.q.out +++ b/ql/src/test/results/clientpositive/cte_1.q.out @@ -18,6 +18,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -74,6 +75,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -130,6 +132,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_3.q.out b/ql/src/test/results/clientpositive/cte_3.q.out index 9f5e0aa..d3884f1 100644 --- a/ql/src/test/results/clientpositive/cte_3.q.out +++ b/ql/src/test/results/clientpositive/cte_3.q.out @@ -24,6 +24,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -145,6 +146,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -273,6 +275,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -311,6 +314,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: q2 + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_5.q.out b/ql/src/test/results/clientpositive/cte_5.q.out index 2eb59ca..6789cd3 100644 --- a/ql/src/test/results/clientpositive/cte_5.q.out +++ b/ql/src/test/results/clientpositive/cte_5.q.out @@ -64,6 +64,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (UDFToDouble(colnum) = 5.0D) (type: boolean) Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(colnum) = 5.0D) (type: boolean) @@ -75,6 +76,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_6.q.out b/ql/src/test/results/clientpositive/cte_6.q.out index 629b8ba..2bf6589 100644 --- a/ql/src/test/results/clientpositive/cte_6.q.out +++ b/ql/src/test/results/clientpositive/cte_6.q.out @@ -16,6 +16,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -59,6 +60,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_mat_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_1.q.out b/ql/src/test/results/clientpositive/cte_mat_1.q.out index 6ac57fd..7e84cba 100644 --- a/ql/src/test/results/clientpositive/cte_mat_1.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_1.q.out @@ -21,6 +21,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -32,6 +33,7 @@ STAGE PLANS: Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_mat_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_2.q.out b/ql/src/test/results/clientpositive/cte_mat_2.q.out index 6ac57fd..7e84cba 100644 --- a/ql/src/test/results/clientpositive/cte_mat_2.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_2.q.out @@ -21,6 +21,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -32,6 +33,7 @@ STAGE PLANS: Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_mat_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_3.q.out b/ql/src/test/results/clientpositive/cte_mat_3.q.out index a075a95..3d597c0 100644 --- a/ql/src/test/results/clientpositive/cte_mat_3.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_3.q.out @@ -27,6 +27,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -65,6 +66,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -80,6 +82,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_mat_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_4.q.out b/ql/src/test/results/clientpositive/cte_mat_4.q.out index 63cb2ab..943ca59 100644 --- a/ql/src/test/results/clientpositive/cte_mat_4.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_4.q.out @@ -52,6 +52,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -90,6 +91,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -105,6 +107,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -259,6 +262,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -297,6 +301,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -312,6 +317,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cte_mat_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_5.q.out b/ql/src/test/results/clientpositive/cte_mat_5.q.out index 42590e0..1a6f086 100644 --- a/ql/src/test/results/clientpositive/cte_mat_5.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_5.q.out @@ -70,6 +70,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '5') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '5') (type: boolean) @@ -108,6 +109,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: colnum is not null (type: boolean) Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: colnum is not null (type: boolean) @@ -124,6 +126,7 @@ STAGE PLANS: value expressions: _col0 (type: int) TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/decimal_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_join2.q.out b/ql/src/test/results/clientpositive/decimal_join2.q.out index ce45274..43610ea 100644 --- a/ql/src/test/results/clientpositive/decimal_join2.q.out +++ b/ql/src/test/results/clientpositive/decimal_join2.q.out @@ -57,6 +57,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -73,6 +74,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -226,6 +228,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -244,6 +247,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/decimal_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_udf.q.out b/ql/src/test/results/clientpositive/decimal_udf.q.out index 044fede..78f4b7d 100644 --- a/ql/src/test/results/clientpositive/decimal_udf.q.out +++ b/ql/src/test/results/clientpositive/decimal_udf.q.out @@ -641,6 +641,7 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf + filterExpr: ((key * CAST( value AS decimal(10,0))) > 0) (type: boolean) Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key * CAST( value AS decimal(10,0))) > 0) (type: boolean) @@ -963,6 +964,7 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf + filterExpr: (key <> 0) (type: boolean) Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key <> 0) (type: boolean) @@ -1029,6 +1031,7 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf + filterExpr: (value <> 0) (type: boolean) Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value <> 0) (type: boolean) @@ -1085,6 +1088,7 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf + filterExpr: (value <> 0) (type: boolean) Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value <> 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/decimal_udf2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_udf2.q.out b/ql/src/test/results/clientpositive/decimal_udf2.q.out index 2006e48..b804530 100644 --- a/ql/src/test/results/clientpositive/decimal_udf2.q.out +++ b/ql/src/test/results/clientpositive/decimal_udf2.q.out @@ -42,6 +42,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf2 + filterExpr: (key = 10) (type: boolean) Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 10) (type: boolean) @@ -100,6 +101,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf2 + filterExpr: (key = 10) (type: boolean) Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 10) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/deleteAnalyze.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/deleteAnalyze.q.out b/ql/src/test/results/clientpositive/deleteAnalyze.q.out index 0661885..695a269 100644 --- a/ql/src/test/results/clientpositive/deleteAnalyze.q.out +++ b/ql/src/test/results/clientpositive/deleteAnalyze.q.out @@ -168,6 +168,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s + filterExpr: item is not null (type: boolean) Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: item is not null (type: boolean) @@ -184,6 +185,7 @@ STAGE PLANS: value expressions: _col0 (type: int) TableScan alias: d + filterExpr: ((id = 2) and item is not null) (type: boolean) Statistics: Num rows: 1 Data size: 312 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((id = 2) and item is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/druid/druidkafkamini_basic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/druid/druidkafkamini_basic.q.out b/ql/src/test/results/clientpositive/druid/druidkafkamini_basic.q.out index 0743974..774ed54 100644 --- a/ql/src/test/results/clientpositive/druid/druidkafkamini_basic.q.out +++ b/ql/src/test/results/clientpositive/druid/druidkafkamini_basic.q.out @@ -235,6 +235,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: languages + filterExpr: shortname is not null (type: boolean) Statistics: Num rows: 2 Data size: 354 Basic stats: COMPLETE Column stats: COMPLETE GatherStats: false Filter Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out b/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out index 28deb79..1278a57 100644 --- a/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out +++ b/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out @@ -118,6 +118,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc + filterExpr: ctimestamp1 is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2601650 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ctimestamp1 is not null (type: boolean) @@ -351,6 +352,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc + filterExpr: ctimestamp2 is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2601650 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ctimestamp2 is not null (type: boolean) @@ -488,6 +490,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc + filterExpr: ctimestamp1 is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2601650 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ctimestamp1 is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/druid/druidmini_mv.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/druid/druidmini_mv.q.out b/ql/src/test/results/clientpositive/druid/druidmini_mv.q.out index 7720db3..e5e1ea9 100644 --- a/ql/src/test/results/clientpositive/druid/druidmini_mv.q.out +++ b/ql/src/test/results/clientpositive/druid/druidmini_mv.q.out @@ -161,6 +161,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cmv_basetable_n2 + filterExpr: (a = 3) (type: boolean) Filter Operator predicate: (a = 3) (type: boolean) Select Operator @@ -214,6 +215,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n2 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 6 Data size: 72 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (a = 3) (type: boolean) @@ -230,6 +232,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n2 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 6 Data size: 96 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -337,6 +340,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n2 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 31 Data size: 372 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (a = 3) (type: boolean) @@ -353,6 +357,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n2 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 31 Data size: 496 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -454,6 +459,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n2 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 31 Data size: 22692 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (a = 3) (type: boolean) @@ -545,6 +551,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n2 + filterExpr: ((a = 3) and (d = 3)) (type: boolean) Statistics: Num rows: 31 Data size: 496 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out b/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out index ee9a4af..a79b8e7 100644 --- a/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out +++ b/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out @@ -104,6 +104,7 @@ STAGE PLANS: Processor Tree: TableScan alias: dynamic_part_table + filterExpr: ((partcol1 = '1') and (partcol2 = '1')) (type: boolean) Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator @@ -174,6 +175,7 @@ STAGE PLANS: Processor Tree: TableScan alias: dynamic_part_table + filterExpr: ((partcol1 = '1') and (partcol2 = '1')) (type: boolean) Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator @@ -291,6 +293,7 @@ STAGE PLANS: Processor Tree: TableScan alias: dynamic_part_table + filterExpr: ((partcol1 = '1') and ((partcol2 = '1') or (partcol2 = '__HIVE_DEFAULT_PARTITION__'))) (type: boolean) Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/empty_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/empty_join.q.out b/ql/src/test/results/clientpositive/empty_join.q.out index dc473e1..2c0c7d5 100644 --- a/ql/src/test/results/clientpositive/empty_join.q.out +++ b/ql/src/test/results/clientpositive/empty_join.q.out @@ -71,6 +71,7 @@ STAGE PLANS: $hdt$_1:t2 TableScan alias: t2 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -87,6 +88,7 @@ STAGE PLANS: $hdt$_2:t3 TableScan alias: t3 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -106,6 +108,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out index 80ffad6..b1942a1 100644 --- a/ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out +++ b/ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out @@ -546,6 +546,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -567,6 +568,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: t2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/encrypted/encryption_join_with_different_encryption_keys.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_join_with_different_encryption_keys.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_join_with_different_encryption_keys.q.out index c88a6f3..be3af8f 100644 --- a/ql/src/test/results/clientpositive/encrypted/encryption_join_with_different_encryption_keys.q.out +++ b/ql/src/test/results/clientpositive/encrypted/encryption_join_with_different_encryption_keys.q.out @@ -64,6 +64,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -85,6 +86,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: t2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/explain_logical.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_logical.q.out b/ql/src/test/results/clientpositive/explain_logical.q.out index 6b7e986..c7eb6e9 100644 --- a/ql/src/test/results/clientpositive/explain_logical.q.out +++ b/ql/src/test/results/clientpositive/explain_logical.q.out @@ -76,6 +76,7 @@ LOGICAL PLAN: srcpart TableScan (TS_0) alias: srcpart + filterExpr: ds is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Select Operator (SEL_2) expressions: key (type: string) @@ -179,6 +180,7 @@ $hdt$_0-subquery1:src $hdt$_0-subquery2:srcpart TableScan (TS_2) alias: srcpart + filterExpr: ds is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Select Operator (SEL_4) expressions: key (type: string), value (type: string) @@ -197,6 +199,7 @@ LOGICAL PLAN: $hdt$_0:s1 TableScan (TS_0) alias: s1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator (FIL_11) predicate: key is not null (type: boolean) @@ -232,6 +235,7 @@ $hdt$_0:s1 $hdt$_1:s2 TableScan (TS_3) alias: s2 + filterExpr: (key is not null and ds is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator (FIL_12) predicate: key is not null (type: boolean) @@ -280,6 +284,7 @@ LOGICAL PLAN: srcpart TableScan (TS_0) alias: srcpart + filterExpr: ds is not null (type: boolean) properties: insideView TRUE Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE @@ -297,6 +302,7 @@ LOGICAL PLAN: $hdt$_0:srcpart TableScan (TS_0) alias: srcpart + filterExpr: (ds is not null and key is not null) (type: boolean) properties: insideView TRUE Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE @@ -334,6 +340,7 @@ $hdt$_0:srcpart $hdt$_1:src2 TableScan (TS_3) alias: src2 + filterExpr: key is not null (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -367,6 +374,7 @@ LOGICAL PLAN: $hdt$_0:srcpart TableScan (TS_0) alias: srcpart + filterExpr: (ds is not null and key is not null) (type: boolean) properties: insideView TRUE Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE @@ -407,6 +415,7 @@ $hdt$_0:srcpart $hdt$_1:src TableScan (TS_3) alias: src + filterExpr: key is not null (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -435,6 +444,7 @@ $hdt$_1:src $hdt$_2:src3 TableScan (TS_6) alias: src3 + filterExpr: key is not null (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -484,6 +494,7 @@ LOGICAL PLAN: srcpart TableScan (TS_0) alias: srcpart + filterExpr: (ds = '10') (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE @@ -504,6 +515,7 @@ LOGICAL PLAN: $hdt$_0:src TableScan (TS_0) alias: src + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator (FIL_17) predicate: key is not null (type: boolean) @@ -563,6 +575,7 @@ $hdt$_0:src $hdt$_1:s2 TableScan (TS_7) alias: s2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator (FIL_18) predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/explain_outputs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_outputs.q.out b/ql/src/test/results/clientpositive/explain_outputs.q.out index 86ec9fa..d0fe893 100644 --- a/ql/src/test/results/clientpositive/explain_outputs.q.out +++ b/ql/src/test/results/clientpositive/explain_outputs.q.out @@ -49,6 +49,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n22 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -64,6 +65,7 @@ STAGE PLANS: Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: t2_n14 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 5 Data size: 5 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -154,6 +156,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n22 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2/2 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -169,6 +172,7 @@ STAGE PLANS: Statistics: Num rows: 2/2 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: t2_n14 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 5/5 Data size: 5 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -261,6 +265,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n22 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -276,6 +281,7 @@ STAGE PLANS: Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: t2_n14 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 5 Data size: 5 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean)
