http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mapjoin47.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin47.q.out b/ql/src/test/results/clientpositive/mapjoin47.q.out index cd61cee..cf29fa0 100644 --- a/ql/src/test/results/clientpositive/mapjoin47.q.out +++ b/ql/src/test/results/clientpositive/mapjoin47.q.out @@ -30,6 +30,7 @@ STAGE PLANS: $hdt$_0:src1 TableScan alias: src1 + filterExpr: (UDFToDouble(value) BETWEEN 100.0D AND 102.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(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean) @@ -48,6 +49,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean) @@ -132,6 +134,7 @@ STAGE PLANS: $hdt$_0:src1 TableScan alias: src1 + 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) @@ -150,6 +153,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) @@ -245,6 +249,7 @@ STAGE PLANS: $hdt$_0:src1 TableScan alias: src1 + filterExpr: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean) @@ -263,6 +268,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mapjoin_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_distinct.q.out b/ql/src/test/results/clientpositive/mapjoin_distinct.q.out index 0436e4a..19ab4e5 100644 --- a/ql/src/test/results/clientpositive/mapjoin_distinct.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_distinct.q.out @@ -27,6 +27,7 @@ STAGE PLANS: $hdt$_0:c TableScan alias: c + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -45,6 +46,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -173,6 +175,7 @@ STAGE PLANS: $hdt$_0:c TableScan alias: c + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -191,6 +194,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -297,6 +301,7 @@ STAGE PLANS: $hdt$_0:c TableScan alias: c + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -315,6 +320,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -438,6 +444,7 @@ STAGE PLANS: $hdt$_0:c TableScan alias: c + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -456,6 +463,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 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/mapjoin_filter_on_outerjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out b/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out index 89d8c86..9472b85 100644 --- a/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out @@ -67,6 +67,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: ((key < 300) and (key < 10)) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key < 300)) (type: boolean) @@ -83,6 +84,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key < 300) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 300) (type: boolean) @@ -102,6 +104,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src3 + filterExpr: (key < 300) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 300) (type: boolean) @@ -220,6 +223,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: ((key < 300) and (key < 10)) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key < 300)) (type: boolean) @@ -236,6 +240,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key < 300) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 300) (type: boolean) @@ -255,6 +260,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src3 + filterExpr: (key < 300) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 300) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out b/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out index ed92c17..a62c798 100644 --- a/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out @@ -21,6 +21,7 @@ STAGE PLANS: $hdt$_0:src TableScan alias: src + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -39,6 +40,7 @@ STAGE PLANS: $hdt$_2:src1 TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -60,6 +62,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (value is not null and key is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -445,6 +448,7 @@ STAGE PLANS: $hdt$_0:src TableScan alias: src + filterExpr: (value > 'val_450') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value > 'val_450') (type: boolean) @@ -460,6 +464,7 @@ STAGE PLANS: $hdt$_2:src1 TableScan alias: src1 + 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) @@ -478,6 +483,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: ((value > 'val_450') and key is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value > 'val_450') and key is not null) (type: boolean) @@ -544,6 +550,7 @@ STAGE PLANS: $hdt$_1:src1 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) @@ -559,6 +566,7 @@ STAGE PLANS: $hdt$_2:src TableScan alias: src + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) @@ -577,6 +585,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (value is not null and key is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out b/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out index 19a00e0..a805566 100644 --- a/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out @@ -40,6 +40,7 @@ STAGE PLANS: $hdt$_0:src1 TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -58,6 +59,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 70 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/mapjoin_subquery.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_subquery.q.out b/ql/src/test/results/clientpositive/mapjoin_subquery.q.out index 1f3f1bb..6116d38 100644 --- a/ql/src/test/results/clientpositive/mapjoin_subquery.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_subquery.q.out @@ -31,6 +31,7 @@ STAGE PLANS: $hdt$_0:z TableScan alias: z + filterExpr: ((ds = '2008-04-08') and (11.0D = 11.0D) and 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) @@ -46,6 +47,7 @@ STAGE PLANS: $hdt$_1:$hdt$_2:x 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) @@ -64,6 +66,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + 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) @@ -275,6 +278,7 @@ STAGE PLANS: $hdt$_0:z TableScan alias: z + filterExpr: ((ds = '2008-04-08') and (11.0D = 11.0D) and 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) @@ -290,6 +294,7 @@ STAGE PLANS: $hdt$_1:$hdt$_2:x 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) @@ -308,6 +313,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + 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/mapjoin_subquery2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out b/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out index 89f367c..50e7ce0 100644 --- a/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out @@ -97,6 +97,7 @@ STAGE PLANS: $hdt$_0:$hdt$_0:y TableScan alias: y + filterExpr: id is not null (type: boolean) Statistics: Num rows: 1 Data size: 60 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -112,6 +113,7 @@ STAGE PLANS: $hdt$_1:z TableScan alias: z + filterExpr: id is not null (type: boolean) Statistics: Num rows: 1 Data size: 60 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -130,6 +132,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: id is not null (type: boolean) Statistics: Num rows: 1 Data size: 130 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/masking_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_1.q.out b/ql/src/test/results/clientpositive/masking_1.q.out index bc0a42a..19d1fcc 100644 --- a/ql/src/test/results/clientpositive/masking_1.q.out +++ b/ql/src/test/results/clientpositive/masking_1.q.out @@ -553,6 +553,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n8 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -1095,6 +1096,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n8 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -1637,6 +1639,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n8 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -2179,6 +2182,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n8 + 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) @@ -2195,6 +2199,7 @@ STAGE PLANS: value expressions: _col0 (type: int), _col1 (type: string) TableScan alias: srcpart + filterExpr: key is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -6376,6 +6381,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n8 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -6918,6 +6924,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n8 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -7460,6 +7467,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((UDFToDouble(key) > 0.0D) and (UDFToDouble(key) < 10.0D) and ((UDFToDouble(key) % 2.0D) = 0.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) % 2.0D) = 0.0D) and (UDFToDouble(key) < 10.0D) and (UDFToDouble(key) > 0.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_10.q.out b/ql/src/test/results/clientpositive/masking_10.q.out index 712f07b..5d5e1fe 100644 --- a/ql/src/test/results/clientpositive/masking_10.q.out +++ b/ql/src/test/results/clientpositive/masking_10.q.out @@ -26,6 +26,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test + filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key % 2) = 0) and (key < 10)) (type: boolean) @@ -117,6 +118,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test + filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key % 2) = 0) and (key < 10)) (type: boolean) @@ -171,6 +173,7 @@ STAGE PLANS: value expressions: _col1 (type: string), _col2 (type: int), _col3 (type: string) TableScan alias: masking_test + filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key % 2) = 0) and (key < 10)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_12.q.out b/ql/src/test/results/clientpositive/masking_12.q.out index 32c420c..bd9e596 100644 --- a/ql/src/test/results/clientpositive/masking_12.q.out +++ b/ql/src/test/results/clientpositive/masking_12.q.out @@ -672,6 +672,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n5 + filterExpr: (key > 6) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1217,6 +1218,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n5 + filterExpr: key is not null (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1235,6 +1237,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: masking_test_n5 + filterExpr: (key > 6) (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/masking_1_newdb.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_1_newdb.q.out b/ql/src/test/results/clientpositive/masking_1_newdb.q.out index fa32212..4beefd9 100644 --- a/ql/src/test/results/clientpositive/masking_1_newdb.q.out +++ b/ql/src/test/results/clientpositive/masking_1_newdb.q.out @@ -571,6 +571,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n12 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_2.q.out b/ql/src/test/results/clientpositive/masking_2.q.out index 2d2e696..9a42211 100644 --- a/ql/src/test/results/clientpositive/masking_2.q.out +++ b/ql/src/test/results/clientpositive/masking_2.q.out @@ -570,6 +570,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToInteger(key) > 0) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1116,6 +1117,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + 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) @@ -1132,6 +1134,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: src + filterExpr: ((UDFToInteger(key) > 0) and value is not null) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1185,6 +1188,7 @@ STAGE PLANS: Map Operator Tree: TableScan 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 @@ -1203,6 +1207,7 @@ STAGE PLANS: value expressions: _col0 (type: int), _col1 (type: string) TableScan alias: src + filterExpr: ((UDFToInteger(key) > 0) and value is not null) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1277,6 +1282,7 @@ STAGE PLANS: Statistics: Num rows: 666 Data size: 7075 Basic stats: COMPLETE Column stats: NONE TableScan alias: src + filterExpr: (UDFToInteger(key) > 0) (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/masking_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_3.q.out b/ql/src/test/results/clientpositive/masking_3.q.out index 8553b08..20d9231 100644 --- a/ql/src/test/results/clientpositive/masking_3.q.out +++ b/ql/src/test/results/clientpositive/masking_3.q.out @@ -553,6 +553,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq_n3 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -1095,6 +1096,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq_n3 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -1637,6 +1639,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq_n3 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -2179,6 +2182,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq_n3 + 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) @@ -2195,6 +2199,7 @@ STAGE PLANS: value expressions: _col0 (type: int), _col1 (type: string) TableScan alias: srcpart + filterExpr: key is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -6376,6 +6381,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq_n3 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -6918,6 +6924,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq_n3 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -7460,6 +7467,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((UDFToDouble(key) > 0.0D) and (UDFToDouble(key) < 10.0D) and ((UDFToDouble(key) % 2.0D) = 0.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) % 2.0D) = 0.0D) and (UDFToDouble(key) < 10.0D) and (UDFToDouble(key) > 0.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_4.q.out b/ql/src/test/results/clientpositive/masking_4.q.out index 068c484..5f90f3e 100644 --- a/ql/src/test/results/clientpositive/masking_4.q.out +++ b/ql/src/test/results/clientpositive/masking_4.q.out @@ -42,6 +42,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) @@ -83,6 +84,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n11 + 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) @@ -124,6 +126,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n11 + 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/masking_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_6.q.out b/ql/src/test/results/clientpositive/masking_6.q.out index bee347f..a8fab44 100644 --- a/ql/src/test/results/clientpositive/masking_6.q.out +++ b/ql/src/test/results/clientpositive/masking_6.q.out @@ -575,6 +575,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToInteger(key) > 0) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1701,6 +1702,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToInteger(key) > 0) (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/masking_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_7.q.out b/ql/src/test/results/clientpositive/masking_7.q.out index 9fa62f9..9727f5e 100644 --- a/ql/src/test/results/clientpositive/masking_7.q.out +++ b/ql/src/test/results/clientpositive/masking_7.q.out @@ -576,6 +576,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToInteger(key) > 0) (type: boolean) properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE @@ -1703,6 +1704,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToInteger(key) > 0) (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/masking_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_9.q.out b/ql/src/test/results/clientpositive/masking_9.q.out index ae1a82b..c9c0ad7 100644 --- a/ql/src/test/results/clientpositive/masking_9.q.out +++ b/ql/src/test/results/clientpositive/masking_9.q.out @@ -26,6 +26,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test + filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key % 2) = 0) and (key < 10)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out index 0967fde..fa92660 100644 --- a/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out +++ b/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out @@ -553,6 +553,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n10 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -1095,6 +1096,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n10 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -1637,6 +1639,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n10 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -2179,6 +2182,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n10 + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -2191,6 +2195,7 @@ STAGE PLANS: value expressions: key (type: int), value (type: string) TableScan alias: srcpart + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -6372,6 +6377,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n10 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -6914,6 +6920,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n10 + filterExpr: (key > 0) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 0) (type: boolean) @@ -7456,6 +7463,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((key > 0) and (key < 10) and ((key % 2) = 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key % 2) = 0) and (key < 10) and (key > 0)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out index bb58b08..dc53112 100644 --- a/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out +++ b/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out @@ -1099,6 +1099,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) @@ -1118,6 +1119,7 @@ STAGE PLANS: value expressions: _col0 (type: int) TableScan alias: a + 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) @@ -1185,6 +1187,7 @@ STAGE PLANS: value expressions: _col0 (type: int), _col1 (type: string) TableScan alias: src + filterExpr: UDFToDouble(value) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(value) is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out index 9f4b149..df96b3d 100644 --- a/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out +++ b/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out @@ -24,6 +24,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -36,6 +37,7 @@ STAGE PLANS: value expressions: key (type: int), value (type: string) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -601,6 +603,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean) @@ -613,6 +616,7 @@ STAGE PLANS: value expressions: key (type: int), value (type: string) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -1175,6 +1179,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean) @@ -1187,6 +1192,7 @@ STAGE PLANS: value expressions: key (type: int) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -1749,6 +1755,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean) @@ -1761,6 +1768,7 @@ STAGE PLANS: value expressions: value (type: string) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -2328,6 +2336,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -2340,6 +2349,7 @@ STAGE PLANS: value expressions: key (type: int), value (type: string) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -2386,6 +2396,7 @@ STAGE PLANS: value expressions: _col0 (type: int), _col1 (type: string) TableScan alias: srcpart + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -6569,6 +6580,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean) @@ -6581,6 +6593,7 @@ STAGE PLANS: value expressions: key (type: int), value (type: string) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -7143,6 +7156,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_subq + filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean) @@ -7155,6 +7169,7 @@ STAGE PLANS: value expressions: key (type: int), value (type: string) TableScan alias: src + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: UDFToDouble(key) is not null (type: boolean) @@ -7717,6 +7732,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((key > 0) and (key < 10) and ((key % 2) = 0)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key % 2) = 0) and (key < 10) and (key > 0)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out index 087d093..55e2915 100644 --- a/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out +++ b/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out @@ -42,6 +42,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) @@ -83,6 +84,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n3 + 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) @@ -124,6 +126,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: masking_test_n3 + 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/merge3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge3.q.out b/ql/src/test/results/clientpositive/merge3.q.out index aaa7702..961fae3 100644 --- a/ql/src/test/results/clientpositive/merge3.q.out +++ b/ql/src/test/results/clientpositive/merge3.q.out @@ -2390,6 +2390,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: merge_src_part + filterExpr: ds is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator @@ -4872,6 +4873,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: merge_src_part + filterExpr: ds is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 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/merge4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge4.q.out b/ql/src/test/results/clientpositive/merge4.q.out index edaf416..1bbfd86 100644 --- a/ql/src/test/results/clientpositive/merge4.q.out +++ b/ql/src/test/results/clientpositive/merge4.q.out @@ -28,6 +28,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), hr (type: string) @@ -1187,6 +1188,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) @@ -2852,6 +2854,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), hr (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out index 45c3a93..068d589 100644 --- a/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out +++ b/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out @@ -64,6 +64,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_n1 + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), hr (type: string) @@ -694,6 +695,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_n1 + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) @@ -1363,6 +1365,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_n1 + filterExpr: ((ds = '2008-04-08') and (11.0D = 11.0D)) (type: boolean) Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), '2008-04-08' (type: string), hr (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out index aa87e3b..551581b 100644 --- a/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out +++ b/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out @@ -86,6 +86,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_n0 + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 297 Data size: 174150 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), hr (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out index 6ffcf4c..bd9beb8 100644 --- a/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out +++ b/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out @@ -146,6 +146,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_n2 + filterExpr: (ds >= '2008-04-08') (type: boolean) Statistics: Num rows: 594 Data size: 348300 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out index 4ede977..f5740cf 100644 --- a/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out +++ b/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out @@ -147,6 +147,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_rc_n1 + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), if(((UDFToDouble(key) % 2.0D) = 0.0D), 'a1', 'b1') (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out index bd151da..c3319b8 100644 --- a/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out +++ b/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out @@ -123,6 +123,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart_merge_dp_rc + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 618 Data size: 5934 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), if(((UDFToDouble(key) % 100.0D) = 0.0D), 'a1', 'b1') (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_join_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge_join_1.q.out b/ql/src/test/results/clientpositive/merge_join_1.q.out index 8a2dd1d..ccbae94 100644 --- a/ql/src/test/results/clientpositive/merge_join_1.q.out +++ b/ql/src/test/results/clientpositive/merge_join_1.q.out @@ -77,6 +77,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: test_join_1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: a is not null (type: boolean) @@ -93,6 +94,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: test_join_2 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: a is not null (type: boolean) @@ -134,6 +136,7 @@ STAGE PLANS: value expressions: _col1 (type: string), _col2 (type: string) TableScan alias: test_join_1 + filterExpr: (a is not null and b is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (a is not null and b is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mergejoins.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mergejoins.q.out b/ql/src/test/results/clientpositive/mergejoins.q.out index b34b388..58d1c1d 100644 --- a/ql/src/test/results/clientpositive/mergejoins.q.out +++ b/ql/src/test/results/clientpositive/mergejoins.q.out @@ -53,6 +53,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n0 + filterExpr: (val1 is not null and val2 is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (val1 is not null and val2 is not null) (type: boolean) @@ -69,6 +70,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: b_n0 + filterExpr: val1 is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: val1 is not null (type: boolean) @@ -85,6 +87,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: c_n0 + filterExpr: val1 is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: val1 is not null (type: boolean) @@ -101,6 +104,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: d_n0 + filterExpr: val1 is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: val1 is not null (type: boolean) @@ -147,6 +151,7 @@ STAGE PLANS: value expressions: _col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int) TableScan alias: e_n0 + filterExpr: val2 is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: val2 is not null (type: boolean) @@ -198,6 +203,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n0 + 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) @@ -214,6 +220,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b_n0 + 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) @@ -230,6 +237,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: c_n0 + 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/mergejoins_mixed.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mergejoins_mixed.q.out b/ql/src/test/results/clientpositive/mergejoins_mixed.q.out index ee3fa11..9ac6d59 100644 --- a/ql/src/test/results/clientpositive/mergejoins_mixed.q.out +++ b/ql/src/test/results/clientpositive/mergejoins_mixed.q.out @@ -22,6 +22,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -38,6 +39,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -54,6 +56,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: c + 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) @@ -70,6 +73,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: d + 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) @@ -127,6 +131,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -143,6 +148,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -159,6 +165,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: c + 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) @@ -229,6 +236,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -245,6 +253,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -328,6 +337,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -344,6 +354,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -429,6 +440,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -445,6 +457,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -526,6 +539,7 @@ STAGE PLANS: value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string) TableScan alias: d + 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) @@ -581,6 +595,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -597,6 +612,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -730,6 +746,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -746,6 +763,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -879,6 +897,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -895,6 +914,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -1028,6 +1048,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -1044,6 +1065,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -1177,6 +1199,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -1193,6 +1216,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -1326,6 +1350,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -1342,6 +1367,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -1474,6 +1500,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a_n5 + 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) @@ -1490,6 +1517,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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/multi_insert_gby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/multi_insert_gby.q.out b/ql/src/test/results/clientpositive/multi_insert_gby.q.out index 514e4538..9c7b61e 100644 --- a/ql/src/test/results/clientpositive/multi_insert_gby.q.out +++ b/ql/src/test/results/clientpositive/multi_insert_gby.q.out @@ -41,6 +41,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((key > 500) or (key > 450)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key > 450) or (key > 500)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out b/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out index fa32ee4..7e720b6 100644 --- a/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out +++ b/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out @@ -1068,6 +1068,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -1311,6 +1312,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -1622,6 +1624,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -1865,6 +1868,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -3900,6 +3904,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -4015,6 +4020,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -4130,6 +4136,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) @@ -4245,6 +4252,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/multi_insert_union_src.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/multi_insert_union_src.q.out b/ql/src/test/results/clientpositive/multi_insert_union_src.q.out index e8dabfd..a35c1e4 100644 --- a/ql/src/test/results/clientpositive/multi_insert_union_src.q.out +++ b/ql/src/test/results/clientpositive/multi_insert_union_src.q.out @@ -62,6 +62,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: (UDFToDouble(key) < 10.0D) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 10.0D) (type: boolean) @@ -91,6 +92,7 @@ STAGE PLANS: serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe TableScan alias: src2_n4 + 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/multi_insert_with_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out b/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out index 34b1d08..0e75384 100644 --- a/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out +++ b/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out @@ -79,6 +79,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (id = 'Id_1') (type: boolean) Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (id = 'Id_1') (type: boolean) @@ -93,6 +94,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b + filterExpr: ((id = 'Id_1') and (val = 'val_103')) (type: boolean) Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((id = 'Id_1') and (val = 'val_103')) (type: boolean) @@ -205,6 +207,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((id = 'Id_2') and (val <> 'val_104')) (type: boolean) Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((id = 'Id_2') and (val <> 'val_104')) (type: boolean) @@ -219,6 +222,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b + filterExpr: ((val = 'val_104') and (id = 'Id_2')) (type: boolean) Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((id = 'Id_2') and (val = 'val_104')) (type: boolean) @@ -741,6 +745,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: id is not null (type: boolean) Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -753,6 +758,7 @@ STAGE PLANS: value expressions: val (type: string) TableScan alias: b + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -948,6 +954,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: id is not null (type: boolean) Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -960,6 +967,7 @@ STAGE PLANS: value expressions: val (type: string) TableScan alias: b + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -1155,6 +1163,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: id is not null (type: boolean) Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -1171,6 +1180,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -1374,6 +1384,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: id is not null (type: boolean) Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -1390,6 +1401,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 24 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/multi_join_union.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/multi_join_union.q.out b/ql/src/test/results/clientpositive/multi_join_union.q.out index 5030103..991ffd5 100644 --- a/ql/src/test/results/clientpositive/multi_join_union.q.out +++ b/ql/src/test/results/clientpositive/multi_join_union.q.out @@ -78,6 +78,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + 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) @@ -93,6 +94,7 @@ STAGE PLANS: $hdt$_2:$hdt$_2-subquery1:src13 TableScan alias: src13 + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) @@ -110,6 +112,7 @@ STAGE PLANS: $hdt$_2:$hdt$_2-subquery2:src14 TableScan alias: src14 + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) @@ -130,6 +133,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: (key is not null and value 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 and value is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/named_column_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/named_column_join.q.out b/ql/src/test/results/clientpositive/named_column_join.q.out index b67b74a..362a6cb 100644 --- a/ql/src/test/results/clientpositive/named_column_join.q.out +++ b/ql/src/test/results/clientpositive/named_column_join.q.out @@ -30,6 +30,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: a is not null (type: boolean) @@ -46,6 +47,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: t2 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: a is not null (type: boolean)
