http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/bucketmapjoin5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin5.q.out b/ql/src/test/results/clientpositive/bucketmapjoin5.q.out index 33fac45..be35ade 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin5.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin5.q.out @@ -196,6 +196,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -220,6 +221,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 298 Data size: 116240 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -798,6 +800,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -822,6 +825,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 156 Data size: 61240 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/bucketmapjoin8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin8.q.out b/ql/src/test/results/clientpositive/bucketmapjoin8.q.out index 86495df..7a1949b 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin8.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin8.q.out @@ -134,6 +134,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -158,6 +159,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -378,6 +380,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -402,6 +405,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 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/bucketmapjoin9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin9.q.out b/ql/src/test/results/clientpositive/bucketmapjoin9.q.out index b6ad96a..11bcc59 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin9.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin9.q.out @@ -142,6 +142,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 145 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -159,6 +160,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -411,6 +413,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -428,6 +431,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((part = '1') and key is not null) (type: boolean) Statistics: Num rows: 95 Data size: 27500 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/bucketmapjoin_negative.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out index 8695e25..1062c53 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out @@ -145,6 +145,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: (key is not null and (ds = '2008-04-08')) (type: boolean) Statistics: Num rows: 140 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -162,6 +163,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 27500 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/bucketmapjoin_negative2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out index 4398379..8172e76 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out @@ -201,6 +201,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 156 Data size: 61240 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -225,6 +226,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 27500 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/bucketmapjoin_negative3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out index 7d3db6a..500a516 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out @@ -162,6 +162,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -186,6 +187,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -313,6 +315,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -337,6 +340,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -464,6 +468,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -481,6 +486,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key + key) is not null (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -607,6 +613,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -624,6 +631,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -750,6 +758,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -767,6 +776,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -893,6 +903,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -910,6 +921,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -1036,6 +1048,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -1053,6 +1066,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -1179,6 +1193,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -1196,6 +1211,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -1322,6 +1338,7 @@ STAGE PLANS: r TableScan alias: r + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -1339,6 +1356,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: l + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 42000 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/bucketsortoptimize_insert_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_1.q.out b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_1.q.out index fe2c7c2..910ba1f 100644 --- a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_1.q.out +++ b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_1.q.out @@ -55,6 +55,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) @@ -165,6 +166,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) @@ -275,6 +277,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), concat(value, value) (type: string) @@ -335,6 +338,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key + key) (type: int), value (type: string) @@ -450,6 +454,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), concat(value, value) (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/bucketsortoptimize_insert_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_3.q.out b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_3.q.out index 085f8f4..b798fa2 100644 --- a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_3.q.out +++ b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_3.q.out @@ -51,6 +51,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: value (type: string), key (type: int) @@ -164,6 +165,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out index cbcac68..6c45fcb 100644 --- a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out +++ b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out @@ -76,6 +76,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key is not null and (ds = '1')) (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -273,6 +274,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and 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/bucketsortoptimize_insert_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out index 97c4d96..aa3d451 100644 --- a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out +++ b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out @@ -76,6 +76,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and 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) @@ -264,6 +265,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: test_table1_n8 + filterExpr: ((ds = '1') and 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/bucketsortoptimize_insert_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out index 0b9485a..1d3a8ad 100644 --- a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out +++ b/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out @@ -76,6 +76,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and 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) @@ -259,6 +260,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and 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/case_sensitivity.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/case_sensitivity.q.out b/ql/src/test/results/clientpositive/case_sensitivity.q.out index a8d5d50..6382115 100644 --- a/ql/src/test/results/clientpositive/case_sensitivity.q.out +++ b/ql/src/test/results/clientpositive/case_sensitivity.q.out @@ -30,6 +30,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_thrift + filterExpr: (lint[0] > 0) (type: boolean) Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (lint[0] > 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cast1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cast1.q.out b/ql/src/test/results/clientpositive/cast1.q.out index e4e8dd6..d349132 100644 --- a/ql/src/test/results/clientpositive/cast1.q.out +++ b/ql/src/test/results/clientpositive/cast1.q.out @@ -28,6 +28,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) = 86.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 86.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cast_on_constant.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cast_on_constant.q.out b/ql/src/test/results/clientpositive/cast_on_constant.q.out index 5923209..465bd15 100644 --- a/ql/src/test/results/clientpositive/cast_on_constant.q.out +++ b/ql/src/test/results/clientpositive/cast_on_constant.q.out @@ -20,6 +20,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n138 + filterExpr: (ts_field = TIMESTAMP'2016-01-23 00:00:00.0') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (ts_field = TIMESTAMP'2016-01-23 00:00:00.0') (type: boolean) @@ -57,6 +58,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n138 + filterExpr: (date_field = DATE'2016-01-23') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (date_field = DATE'2016-01-23') (type: boolean) @@ -94,6 +96,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n138 + filterExpr: (ts_field = TIMESTAMP'2016-01-23 00:00:00.0') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (ts_field = TIMESTAMP'2016-01-23 00:00:00.0') (type: boolean) @@ -131,6 +134,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n138 + filterExpr: (date_field = DATE'2016-01-23') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (date_field = DATE'2016-01-23') (type: boolean) @@ -168,6 +172,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n138 + filterExpr: (CAST( date_field AS TIMESTAMP) = ts_field) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (CAST( date_field AS TIMESTAMP) = ts_field) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_const.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_const.q.out b/ql/src/test/results/clientpositive/cbo_const.q.out index 090fd1b..302c60d 100644 --- a/ql/src/test/results/clientpositive/cbo_const.q.out +++ b/ql/src/test/results/clientpositive/cbo_const.q.out @@ -157,6 +157,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) = 4.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 4.0D) (type: boolean) @@ -235,6 +236,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: y + filterExpr: (UDFToDouble(key) = 3.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 3.0D) (type: boolean) @@ -251,6 +253,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: x + filterExpr: ((UDFToDouble(key) = 3.0D) and value is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) = 3.0D) and value is not null) (type: boolean) @@ -293,6 +296,7 @@ STAGE PLANS: value expressions: _col1 (type: string), _col2 (type: string) TableScan alias: z + filterExpr: ((ds = '2008-04-08') and (UDFToDouble(hr) = 14.0D) and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((UDFToDouble(hr) = 14.0D) and (ds = '2008-04-08') and value is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_input26.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_input26.q.out b/ql/src/test/results/clientpositive/cbo_input26.q.out index 26a2310..9431cd8 100644 --- a/ql/src/test/results/clientpositive/cbo_input26.q.out +++ b/ql/src/test/results/clientpositive/cbo_input26.q.out @@ -24,6 +24,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '2008-04-08') and (hr = '11')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) @@ -92,6 +93,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) @@ -183,6 +185,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '2008-04-08') and (hr = '11')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string) @@ -250,6 +253,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) @@ -341,6 +345,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '2008-04-08') and (hr = '11')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string) @@ -408,6 +413,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) @@ -499,6 +505,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '2008-04-08') and (hr = '11')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) @@ -565,6 +572,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((ds = '2008-04-08') and (hr = '14')) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_ppd_non_deterministic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_ppd_non_deterministic.q.out b/ql/src/test/results/clientpositive/cbo_ppd_non_deterministic.q.out index 8f00aa8..bdcd208 100644 --- a/ql/src/test/results/clientpositive/cbo_ppd_non_deterministic.q.out +++ b/ql/src/test/results/clientpositive/cbo_ppd_non_deterministic.q.out @@ -114,6 +114,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: testa + filterExpr: ((part1 = 'CA') and (part2 = 'ABC')) (type: boolean) Statistics: Num rows: 2 Data size: 4580 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: rand() (type: double) @@ -163,6 +164,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: testa + filterExpr: ((part1 = 'CA') and (part2 = 'ABC')) (type: boolean) Statistics: Num rows: 2 Data size: 4580 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: rand() (type: double) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_rp_auto_join0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_auto_join0.q.out b/ql/src/test/results/clientpositive/cbo_rp_auto_join0.q.out index df19463..5d3fd9f 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_auto_join0.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_auto_join0.q.out @@ -37,6 +37,7 @@ STAGE PLANS: a:cbo_t1:cbo_t3 TableScan alias: cbo_t3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 20 Data size: 3230 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 10) (type: boolean) @@ -55,6 +56,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cbo_t3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 20 Data size: 3230 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 10) (type: boolean) @@ -150,6 +152,7 @@ STAGE PLANS: a:cbo_t1:cbo_t3 TableScan alias: cbo_t3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 20 Data size: 3230 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 10) (type: boolean) @@ -168,6 +171,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cbo_t3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 20 Data size: 3230 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 10) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_rp_auto_join1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_auto_join1.q.out b/ql/src/test/results/clientpositive/cbo_rp_auto_join1.q.out index 3016c26..f937834 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_auto_join1.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_auto_join1.q.out @@ -95,6 +95,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq1:a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -121,6 +122,7 @@ STAGE PLANS: value expressions: $f1 (type: bigint) TableScan alias: subq1:b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -245,6 +247,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq2:subq1:a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -269,6 +272,7 @@ STAGE PLANS: Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE TableScan alias: subq2:subq1:b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -401,6 +405,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1:subq1:a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -427,6 +432,7 @@ STAGE PLANS: value expressions: $f1 (type: bigint) TableScan alias: src1:subq1:b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -472,6 +478,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2:subq2:a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -498,6 +505,7 @@ STAGE PLANS: value expressions: $f1 (type: bigint) TableScan alias: src2:subq2:b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -626,6 +634,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq1:a + filterExpr: (key < 6) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 6) (type: boolean) @@ -719,6 +728,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq2:subq1:a + filterExpr: (key < 6) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 6) (type: boolean) @@ -836,6 +846,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq2:subq1:a + filterExpr: (key < 6) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 6) (type: boolean) @@ -941,6 +952,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq1:a + filterExpr: (key < 8) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 8) (type: boolean) @@ -1027,6 +1039,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq1:a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -1132,6 +1145,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq2:a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -1212,6 +1226,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq1:a + filterExpr: (key < 6) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 6) (type: boolean) @@ -1297,6 +1312,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: subq1:a + filterExpr: (key < 6) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 6) (type: boolean) @@ -1400,6 +1416,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a:subq2:subq1:a + filterExpr: (key < 6) (type: boolean) Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (key < 6) (type: boolean) @@ -1485,6 +1502,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -1562,6 +1580,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE 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/cbo_rp_auto_join17.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_auto_join17.q.out b/ql/src/test/results/clientpositive/cbo_rp_auto_join17.q.out index df1e4d4..74022ae 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_auto_join17.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_auto_join17.q.out @@ -32,6 +32,7 @@ STAGE PLANS: 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) @@ -50,6 +51,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/cbo_rp_cross_product_check_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out b/ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out index 10a8ae1..cbb1d05 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out @@ -130,6 +130,7 @@ STAGE PLANS: 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: od1:d1 TableScan alias: od1: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: od1: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) @@ -635,6 +639,7 @@ STAGE PLANS: od1:d1 TableScan alias: od1: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) @@ -653,6 +658,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: od1: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/cbo_rp_join0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_join0.q.out b/ql/src/test/results/clientpositive/cbo_rp_join0.q.out index 29499a1..f8709d3 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_join0.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_join0.q.out @@ -16,6 +16,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cbo_t1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 20 Data size: 1691 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -32,6 +33,7 @@ STAGE PLANS: value expressions: c_int (type: int) TableScan alias: cbo_t2:cbo_t2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 20 Data size: 1691 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -663,6 +665,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cbo_t1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 20 Data size: 1691 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key is not null (type: boolean) @@ -679,6 +682,7 @@ STAGE PLANS: value expressions: c_int (type: int) TableScan alias: cbo_t2:cbo_t2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 20 Data size: 1691 Basic stats: COMPLETE Column stats: COMPLETE 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/cbo_rp_outer_join_ppr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_outer_join_ppr.q.out b/ql/src/test/results/clientpositive/cbo_rp_outer_join_ppr.q.out index f7123b9..cfc2dfc 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_outer_join_ppr.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_outer_join_ppr.q.out @@ -26,6 +26,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -47,6 +48,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: b + filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -328,6 +330,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -349,6 +352,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: b + filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean) Statistics: Num rows: 1000 Data size: 10624 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/cbo_rp_simple_select.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out b/ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out index 469fbaa..d12b5f6 100644 --- a/ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out +++ b/ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out @@ -755,6 +755,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = c_int) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = c_int) (type: boolean) @@ -781,6 +782,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = (2 * c_int)) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = (2 * c_int)) (type: boolean) @@ -807,6 +809,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = c_int) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = c_int) (type: boolean) @@ -833,6 +836,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = null) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = null) (type: boolean) @@ -859,6 +863,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int) IN (c_int, (2 * c_int)) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int) IN (c_int, (2 * c_int)) (type: boolean) @@ -885,6 +890,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int) IN (c_int, 0) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int) IN (c_int, 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_simple_select.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_simple_select.q.out b/ql/src/test/results/clientpositive/cbo_simple_select.q.out index a44388c..588d924 100644 --- a/ql/src/test/results/clientpositive/cbo_simple_select.q.out +++ b/ql/src/test/results/clientpositive/cbo_simple_select.q.out @@ -755,6 +755,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = c_int) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = c_int) (type: boolean) @@ -781,6 +782,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = (2 * c_int)) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = (2 * c_int)) (type: boolean) @@ -807,6 +809,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = c_int) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = c_int) (type: boolean) @@ -833,6 +836,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int = null) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int = null) (type: boolean) @@ -859,6 +863,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int) IN (c_int, (2 * c_int)) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int) IN (c_int, (2 * c_int)) (type: boolean) @@ -885,6 +890,7 @@ STAGE PLANS: Processor Tree: TableScan alias: cbo_t2 + filterExpr: (c_int) IN (c_int, 0) (type: boolean) Statistics: Num rows: 20 Data size: 7138 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c_int) IN (c_int, 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/cbo_union_view.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_union_view.q.out b/ql/src/test/results/clientpositive/cbo_union_view.q.out index 5552cfe..ecd4ec7 100644 --- a/ql/src/test/results/clientpositive/cbo_union_view.q.out +++ b/ql/src/test/results/clientpositive/cbo_union_view.q.out @@ -66,6 +66,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_union_1 + filterExpr: (key = 86) (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE @@ -91,6 +92,7 @@ STAGE PLANS: serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe TableScan alias: src_union_2 + filterExpr: (key = 86) (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE @@ -116,6 +118,7 @@ STAGE PLANS: serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe TableScan alias: src_union_3 + filterExpr: (key = 86) (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE @@ -160,6 +163,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_union_1 + filterExpr: ((key = 86) and (ds = '1')) (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE @@ -185,6 +189,7 @@ STAGE PLANS: serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe TableScan alias: src_union_2 + filterExpr: ((key = 86) and (ds = '1')) (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE @@ -210,6 +215,7 @@ STAGE PLANS: serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe TableScan alias: src_union_3 + filterExpr: ((key = 86) and (ds = '1')) (type: boolean) properties: insideView TRUE Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/columnstats_partlvl.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_partlvl.q.out b/ql/src/test/results/clientpositive/columnstats_partlvl.q.out index ca07f61..841eed5 100644 --- a/ql/src/test/results/clientpositive/columnstats_partlvl.q.out +++ b/ql/src/test/results/clientpositive/columnstats_partlvl.q.out @@ -46,6 +46,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part + filterExpr: (employeesalary = 2000.0D) (type: boolean) Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: employeeid (type: int) @@ -106,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part + filterExpr: (employeesalary = 2000.0D) (type: boolean) Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE Statistics Aggregation Key Prefix: default.employee_part/ GatherStats: true @@ -295,6 +297,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part + filterExpr: (employeesalary = 4000.0D) (type: boolean) Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: employeeid (type: int) @@ -355,6 +358,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part + filterExpr: (employeesalary = 4000.0D) (type: boolean) Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE Statistics Aggregation Key Prefix: default.employee_part/ GatherStats: true @@ -506,6 +510,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part + filterExpr: (employeesalary = 2000.0D) (type: boolean) Statistics: Num rows: 13 Data size: 92 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: employeeid (type: int), employeename (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out b/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out index 25194d3..73fe460 100644 --- a/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out +++ b/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out @@ -82,6 +82,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n0 + filterExpr: (employeesalary = 4000.0D) (type: boolean) Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: employeeid (type: int), employeename (type: string), country (type: string) @@ -213,6 +214,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n0 + filterExpr: (employeesalary = 2000.0D) (type: boolean) Statistics: Num rows: 3 Data size: 1690 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: employeeid (type: int), country (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/combine2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/combine2.q.out b/ql/src/test/results/clientpositive/combine2.q.out index 383ef25..0ea3a21 100644 --- a/ql/src/test/results/clientpositive/combine2.q.out +++ b/ql/src/test/results/clientpositive/combine2.q.out @@ -77,6 +77,7 @@ STAGE PLANS: Processor Tree: TableScan alias: combine2_n0 + filterExpr: value is not null (type: boolean) Statistics: Num rows: 12 Data size: 14 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) @@ -161,6 +162,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: ds is not null (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ds (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/comments.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/comments.q.out b/ql/src/test/results/clientpositive/comments.q.out index 34fd1f6..5fd4696 100644 --- a/ql/src/test/results/clientpositive/comments.q.out +++ b/ql/src/test/results/clientpositive/comments.q.out @@ -91,6 +91,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: (UDFToDouble(key) > 0.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -112,6 +113,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: (UDFToDouble(key) > 0.0D) (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/complex_alias.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/complex_alias.q.out b/ql/src/test/results/clientpositive/complex_alias.q.out index e74132d..e81b3b5 100644 --- a/ql/src/test/results/clientpositive/complex_alias.q.out +++ b/ql/src/test/results/clientpositive/complex_alias.q.out @@ -143,6 +143,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: agg1 + filterExpr: (col0 = col0) (type: boolean) Statistics: Num rows: 1 Data size: 17 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (col0 = col0) (type: boolean) @@ -165,6 +166,7 @@ STAGE PLANS: Statistics: Num rows: 2 Data size: 34 Basic stats: COMPLETE Column stats: NONE TableScan alias: agg1 + filterExpr: (col0 = col0) (type: boolean) Statistics: Num rows: 1 Data size: 17 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (col0 = col0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out b/ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out index 5619f19..cb8185d 100644 --- a/ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out +++ b/ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out @@ -15,6 +15,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key = '429') (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/constant_prop_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constant_prop_1.q.out b/ql/src/test/results/clientpositive/constant_prop_1.q.out index fc0453f..e1e7cf5 100644 --- a/ql/src/test/results/clientpositive/constant_prop_1.q.out +++ b/ql/src/test/results/clientpositive/constant_prop_1.q.out @@ -143,6 +143,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE TableScan alias: b + filterExpr: (value = '12345') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value = '12345') (type: boolean) @@ -326,6 +327,7 @@ STAGE PLANS: value expressions: _col0 (type: int) TableScan alias: b + filterExpr: (value = '12345') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value = '12345') (type: boolean) @@ -378,6 +380,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key = '238') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '238') (type: boolean) @@ -387,6 +390,7 @@ STAGE PLANS: Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE TableScan alias: b + filterExpr: (value = '234') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value = '234') (type: boolean) @@ -436,6 +440,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) @@ -447,6 +452,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: b + filterExpr: (key is not null and (value = '234')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value = '234') and key is not null) (type: boolean) @@ -523,6 +529,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t_n26 + filterExpr: ((a = 1) and (b = 2) and (c = 3)) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((a = 1) and (b = 2) and (c = 3)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/constant_prop_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constant_prop_2.q.out b/ql/src/test/results/clientpositive/constant_prop_2.q.out index cdd3913..6fef7f9 100644 --- a/ql/src/test/results/clientpositive/constant_prop_2.q.out +++ b/ql/src/test/results/clientpositive/constant_prop_2.q.out @@ -37,6 +37,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: ((ds = '2008-04-08') and (hr = '11')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/constant_prop_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constant_prop_3.q.out b/ql/src/test/results/clientpositive/constant_prop_3.q.out index 3ac1991..2fbd2d4 100644 --- a/ql/src/test/results/clientpositive/constant_prop_3.q.out +++ b/ql/src/test/results/clientpositive/constant_prop_3.q.out @@ -173,6 +173,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: partsupp_hive + filterExpr: ps_partkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ps_partkey is not null (type: boolean) @@ -189,6 +190,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: part_hive + filterExpr: ((p_size) IN (22, 14, 27, 49, 21, 33, 35, 28) and (p_brand <> 'Brand#34') and p_partkey is not null and (not (p_type like 'ECONOMY BRUSHED%'))) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((not (p_type like 'ECONOMY BRUSHED%')) and (p_brand <> 'Brand#34') and (p_size) IN (22, 14, 27, 49, 21, 33, 35, 28) and p_partkey is not null) (type: boolean) @@ -345,6 +347,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: supplier_hive + filterExpr: (s_comment like '%Customer%Complaints%') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (s_comment like '%Customer%Complaints%') (type: boolean) @@ -381,6 +384,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: supplier_hive + filterExpr: (s_comment like '%Customer%Complaints%') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (s_comment like '%Customer%Complaints%') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/constprog2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constprog2.q.out b/ql/src/test/results/clientpositive/constprog2.q.out index c9e9d93..d5615d6 100644 --- a/ql/src/test/results/clientpositive/constprog2.q.out +++ b/ql/src/test/results/clientpositive/constprog2.q.out @@ -17,6 +17,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: (key = 86) (type: boolean) Statistics: Num rows: 1000 Data size: 10603 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) @@ -28,6 +29,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5301 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: (key = 86) (type: boolean) Statistics: Num rows: 1000 Data size: 10603 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) @@ -86,6 +88,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: (UDFToDouble(key) = 86.0D) (type: boolean) Statistics: Num rows: 1000 Data size: 10603 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 86.0D) (type: boolean) @@ -97,6 +100,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5301 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: (key = 86) (type: boolean) Statistics: Num rows: 1000 Data size: 10603 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/constprog_dp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constprog_dp.q.out b/ql/src/test/results/clientpositive/constprog_dp.q.out index b5143a7..67a9206 100644 --- a/ql/src/test/results/clientpositive/constprog_dp.q.out +++ b/ql/src/test/results/clientpositive/constprog_dp.q.out @@ -30,6 +30,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), '2008-04-08' (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/constprog_partitioner.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/constprog_partitioner.q.out b/ql/src/test/results/clientpositive/constprog_partitioner.q.out index f4f2e22..917382e 100644 --- a/ql/src/test/results/clientpositive/constprog_partitioner.q.out +++ b/ql/src/test/results/clientpositive/constprog_partitioner.q.out @@ -17,6 +17,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: (key = 100) (type: boolean) Statistics: Num rows: 1000 Data size: 10603 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) @@ -28,6 +29,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5301 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: (key = 100) (type: boolean) Statistics: Num rows: 1000 Data size: 10603 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) @@ -89,6 +91,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: li + filterExpr: ((l_linenumber = 1) and l_orderkey is not null) (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((l_linenumber = 1) and l_orderkey is not null) (type: boolean) @@ -105,6 +108,7 @@ STAGE PLANS: value expressions: _col1 (type: int), _col2 (type: int) TableScan alias: lineitem + filterExpr: ((l_shipmode = 'AIR') and (l_linenumber = 1) and l_orderkey is not null) (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((l_linenumber = 1) and (l_shipmode = 'AIR') and l_orderkey is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlated_join_keys.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlated_join_keys.q.out b/ql/src/test/results/clientpositive/correlated_join_keys.q.out index 3c0e6e8..1e4c67a 100644 --- a/ql/src/test/results/clientpositive/correlated_join_keys.q.out +++ b/ql/src/test/results/clientpositive/correlated_join_keys.q.out @@ -83,6 +83,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ca_zip is not null and ca_state is not null) (type: boolean) Statistics: Num rows: 20 Data size: 3500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (ca_state is not null and ca_zip is not null) (type: boolean) @@ -98,6 +99,7 @@ STAGE PLANS: Statistics: Num rows: 20 Data size: 3500 Basic stats: COMPLETE Column stats: COMPLETE TableScan alias: b + filterExpr: (ca_zip is not null and ca_state is not null) (type: boolean) Statistics: Num rows: 20 Data size: 3500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (ca_state is not null and ca_zip is not null) (type: boolean) @@ -175,6 +177,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (ca_zip is not null and ca_state is not null) (type: boolean) Statistics: Num rows: 20 Data size: 3500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (ca_state is not null and ca_zip is not null) (type: boolean) @@ -190,6 +193,7 @@ STAGE PLANS: Statistics: Num rows: 20 Data size: 3500 Basic stats: COMPLETE Column stats: COMPLETE TableScan alias: b + filterExpr: (ca_zip is not null and ca_state is not null) (type: boolean) Statistics: Num rows: 20 Data size: 3500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (ca_state is not null and ca_zip is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/correlationoptimizer10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer10.q.out b/ql/src/test/results/clientpositive/correlationoptimizer10.q.out index f8e07a6..4401220 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer10.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer10.q.out @@ -24,6 +24,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) @@ -39,6 +40,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) @@ -111,6 +113,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) @@ -210,6 +213,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) @@ -225,6 +229,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) @@ -240,6 +245,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) @@ -385,6 +391,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) @@ -400,6 +407,7 @@ STAGE PLANS: Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((UDFToDouble(key) > 20.0D) and (UDFToDouble(key) < 200.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) @@ -439,6 +447,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: xx + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) @@ -546,6 +555,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: xx + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) @@ -562,6 +572,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: x + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) @@ -577,6 +588,7 @@ STAGE PLANS: Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((UDFToDouble(key) > 20.0D) and (UDFToDouble(key) < 200.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) @@ -705,6 +717,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) @@ -720,6 +733,7 @@ STAGE PLANS: Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) @@ -759,6 +773,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: xx + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) @@ -878,6 +893,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: xx + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) @@ -894,6 +910,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: x + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) @@ -909,6 +926,7 @@ STAGE PLANS: Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE TableScan alias: y + filterExpr: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 200.0D) and (UDFToDouble(key) > 180.0D)) (type: boolean)
