http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/explain_rearrange.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_rearrange.q.out b/ql/src/test/results/clientpositive/explain_rearrange.q.out index be1b8ed..6ff089f 100644 --- a/ql/src/test/results/clientpositive/explain_rearrange.q.out +++ b/ql/src/test/results/clientpositive/explain_rearrange.q.out @@ -68,6 +68,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -242,6 +243,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -340,6 +342,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -514,6 +517,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -612,6 +616,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -655,6 +660,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -884,6 +890,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -927,6 +934,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: key is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out b/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out index 48a0951..68abf2b 100644 --- a/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out +++ b/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out @@ -69,6 +69,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim_n1 + filterExpr: ((d_date > DATE'1900-01-02') and (d_date_sk = 2416945L)) (type: boolean) Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (d_date > DATE'1900-01-02') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out b/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out index 6ab11b1..b84a2d4 100644 --- a/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out +++ b/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out @@ -19,6 +19,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: m + filterExpr: ((value <> '') and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value <> '') and key is not null) (type: boolean) @@ -35,6 +36,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: f + filterExpr: (((value = '2008-04-08') or (value = '2008-04-09')) and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((value = '2008-04-08') or (value = '2008-04-09')) and key is not null) (type: boolean) @@ -80,6 +82,7 @@ STAGE PLANS: value expressions: _col2 (type: string) TableScan alias: g + filterExpr: (value <> '') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value <> '') (type: boolean) @@ -141,6 +144,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: m + filterExpr: ((value <> '') and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value <> '') and key is not null) (type: boolean) @@ -157,6 +161,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: f + filterExpr: (((value) IN ('2008-04-08', '2008-04-10') or (value = '2008-04-09')) and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((value) IN ('2008-04-08', '2008-04-10') or (value = '2008-04-09')) and key is not null) (type: boolean) @@ -202,6 +207,7 @@ STAGE PLANS: value expressions: _col2 (type: string) TableScan alias: g + filterExpr: (value <> '') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value <> '') (type: boolean) @@ -273,6 +279,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t2 + filterExpr: (UDFToDouble(key) = 1.0D) (type: boolean) Statistics: Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 1.0D) (type: boolean) @@ -289,6 +296,7 @@ STAGE PLANS: value expressions: _col1 (type: int), _col2 (type: float) TableScan alias: t3 + filterExpr: ((c_int = 1) and (UDFToDouble(key) = 1.0D)) (type: boolean) Statistics: Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) = 1.0D) and (c_int = 1)) (type: boolean) @@ -331,6 +339,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1 + filterExpr: (UDFToDouble(key) = 1.0D) (type: boolean) Statistics: Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 1.0D) (type: boolean) @@ -393,6 +402,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + 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) @@ -409,6 +419,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: m + filterExpr: ((value <> '') and ((value = '2008-04-10') or (value = '2008-04-08')) and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((value = '2008-04-10') or (value = '2008-04-08')) and (value <> '') and key is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out b/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out index ec07bed..db4aee7 100644 --- a/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out +++ b/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out @@ -35,6 +35,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: sales + filterExpr: ((store_number = customer_id) and store_id is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((store_number = customer_id) and store_id is not null) (type: boolean) @@ -46,6 +47,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: store + filterExpr: (store_id is not null and salad_bar) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (salad_bar and store_id is not null) (type: boolean) @@ -125,6 +127,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: sales + filterExpr: ((store_number = customer_id) and store_id is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((store_number = customer_id) and store_id is not null) (type: boolean) @@ -136,6 +139,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: store + filterExpr: (store_id is not null and salad_bar) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (salad_bar and store_id is not null) (type: boolean) @@ -215,6 +219,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: sales + filterExpr: ((store_number = customer_id) and store_id is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((store_number = customer_id) and store_id is not null) (type: boolean) @@ -226,6 +231,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: store + filterExpr: (store_id is not null and (salad_bar = true)) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((salad_bar = true) and store_id is not null) (type: boolean) @@ -305,6 +311,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: sales + filterExpr: (store_id is not null and (store_number > customer_id)) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((store_number > customer_id) and store_id is not null) (type: boolean) @@ -316,6 +323,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: store + filterExpr: (store_id is not null and (salad_bar = false)) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((salad_bar = false) and store_id is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/filter_in_or_dup.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_in_or_dup.q.out b/ql/src/test/results/clientpositive/filter_in_or_dup.q.out index f863ac3..b821717 100644 --- a/ql/src/test/results/clientpositive/filter_in_or_dup.q.out +++ b/ql/src/test/results/clientpositive/filter_in_or_dup.q.out @@ -20,6 +20,7 @@ STAGE PLANS: Processor Tree: TableScan alias: f + filterExpr: (key) IN ('1', '2') (type: boolean) Statistics: Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key) IN ('1', '2') (type: boolean) @@ -52,6 +53,7 @@ STAGE PLANS: Processor Tree: TableScan alias: f + filterExpr: (key) IN ('1', '2') (type: boolean) Statistics: Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key) IN ('1', '2') (type: boolean) @@ -84,6 +86,7 @@ STAGE PLANS: Processor Tree: TableScan alias: f + filterExpr: (key) IN ('1', '2') (type: boolean) Statistics: Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key) IN ('1', '2') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/filter_join_breaktask.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_join_breaktask.q.out b/ql/src/test/results/clientpositive/filter_join_breaktask.q.out index a2624ef..a86997b 100644 --- a/ql/src/test/results/clientpositive/filter_join_breaktask.q.out +++ b/ql/src/test/results/clientpositive/filter_join_breaktask.q.out @@ -39,6 +39,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 211 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -59,6 +60,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: m + filterExpr: ((value <> '') and key is not null) (type: boolean) Statistics: Num rows: 25 Data size: 211 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -176,6 +178,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: g + filterExpr: ((ds = '2008-04-08') and (value <> '')) (type: boolean) Statistics: Num rows: 25 Data size: 211 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/filter_numeric.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_numeric.q.out b/ql/src/test/results/clientpositive/filter_numeric.q.out index f2a9b5e..6c7cc50 100644 --- a/ql/src/test/results/clientpositive/filter_numeric.q.out +++ b/ql/src/test/results/clientpositive/filter_numeric.q.out @@ -38,6 +38,7 @@ STAGE PLANS: Processor Tree: TableScan alias: partint + filterExpr: (hr < 11) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (hr < 11) (type: boolean) @@ -71,6 +72,7 @@ STAGE PLANS: Processor Tree: TableScan alias: partint + filterExpr: ((hr <= 12) 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), hr (type: int) @@ -603,6 +605,7 @@ STAGE PLANS: Processor Tree: TableScan alias: partint + filterExpr: hr BETWEEN 11 AND 12 (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: int) @@ -1637,6 +1640,7 @@ STAGE PLANS: Processor Tree: TableScan alias: partint + filterExpr: (not hr BETWEEN 12 AND 14) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), hr (type: int) @@ -2169,6 +2173,7 @@ STAGE PLANS: Processor Tree: TableScan alias: partint + filterExpr: (hr < 13) (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: int) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/flatten_and_or.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/flatten_and_or.q.out b/ql/src/test/results/clientpositive/flatten_and_or.q.out index a25cf1b..04b4a1d 100644 --- a/ql/src/test/results/clientpositive/flatten_and_or.q.out +++ b/ql/src/test/results/clientpositive/flatten_and_or.q.out @@ -42,6 +42,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((key = '0') and (value = '8')) or ((key = '1') and (value = '5')) or ((key = '2') and (value = '6')) or ((key = '3') and (value = '8')) or ((key = '4') and (value = '1')) or ((key = '5') and (value = '6')) or ((key = '6') and (value = '1')) or ((key = '7') and (value = '1')) or ((key = '8') and (value = '1')) or ((key = '9') and (value = '1')) or ((key = '10') and (value = '3'))) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((key = '0') and (value = '8')) or ((key = '1') and (value = '5')) or ((key = '10') and (value = '3')) or ((key = '2') and (value = '6')) or ((key = '3') and (value = '8')) or ((key = '4') and (value = '1')) or ((key = '5') and (value = '6')) or ((key = '6') and (value = '1')) or ((key = '7') and (value = '1')) or ((key = '8') and (value = '1')) or ((key = '9') and (value = '1'))) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/fold_case.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fold_case.q.out b/ql/src/test/results/clientpositive/fold_case.q.out index a99f6f7..320752b 100644 --- a/ql/src/test/results/clientpositive/fold_case.q.out +++ b/ql/src/test/results/clientpositive/fold_case.q.out @@ -14,6 +14,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -66,6 +67,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (not NVL((key = '238'),false)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (not NVL((key = '238'),false)) (type: boolean) @@ -186,6 +188,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -290,6 +293,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -342,6 +346,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (not NVL((key = '238'),false)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (not NVL((key = '238'),false)) (type: boolean) @@ -422,6 +427,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: CASE WHEN ((key = '238')) THEN (null) ELSE (true) END (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: CASE WHEN ((key = '238')) THEN (null) ELSE (true) END (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out b/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out index 763c390..d06fb60 100644 --- a/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out +++ b/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out @@ -40,6 +40,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: lineitem + filterExpr: ((DATE'1996-03-30' = to_date(l_shipdate)) and (l_shipmode = 'RAIL')) (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((DATE'1996-03-30' = to_date(l_shipdate)) and (l_shipmode = 'RAIL')) (type: boolean) @@ -100,6 +101,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -137,6 +139,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((key = '238') or (key = '94')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key = '238') or (key = '94')) (type: boolean) @@ -174,6 +177,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -211,6 +215,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: CASE WHEN ((key <> '238')) THEN ((key = '238')) WHEN ((key = '23')) THEN ((key = '238')) ELSE (null) END (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: CASE WHEN ((key <> '238')) THEN ((key = '238')) WHEN ((key = '23')) THEN ((key = '238')) ELSE (null) END (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/fold_when.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fold_when.q.out b/ql/src/test/results/clientpositive/fold_when.q.out index 08d885d..dfc49ef 100644 --- a/ql/src/test/results/clientpositive/fold_when.q.out +++ b/ql/src/test/results/clientpositive/fold_when.q.out @@ -154,6 +154,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -193,6 +194,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -294,6 +296,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -333,6 +336,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (not NVL((key = '238'),false)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (not NVL((key = '238'),false)) (type: boolean) @@ -441,6 +445,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (not NVL((key = '11'),false)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (not NVL((key = '11'),false)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/folder_predicate.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/folder_predicate.q.out b/ql/src/test/results/clientpositive/folder_predicate.q.out index 2f73f18..64d2693 100644 --- a/ql/src/test/results/clientpositive/folder_predicate.q.out +++ b/ql/src/test/results/clientpositive/folder_predicate.q.out @@ -35,6 +35,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value <> 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value <> 3) or value is null) (type: boolean) @@ -87,6 +88,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value < 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value < 3) or value is null) (type: boolean) @@ -137,6 +139,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value > 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value > 3) or value is null) (type: boolean) @@ -187,6 +190,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value <= 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value <= 3) or value is null) (type: boolean) @@ -238,6 +242,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value >= 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value >= 3) or value is null) (type: boolean) @@ -289,6 +294,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value = 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value = 3) or value is null) (type: boolean) @@ -338,6 +344,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: predicate_fold_tb + filterExpr: (value is null or (value <= 1) or (value > 3)) (type: boolean) Statistics: Num rows: 6 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value <= 1) or (value > 3) or value is null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out b/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out index 84991d7..a6be904 100644 --- a/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out +++ b/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out @@ -16,6 +16,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: q0 + filterExpr: l_discount BETWEEN 0.05D AND 0.07D (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: l_discount BETWEEN 0.05D AND 0.07D (type: boolean) @@ -83,6 +84,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: q1 + filterExpr: l_discount BETWEEN 0.05D AND 0.07D (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: l_discount BETWEEN 0.05D AND 0.07D (type: boolean) @@ -187,6 +189,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: q10 + filterExpr: l_discount BETWEEN CAST( '0.05' AS decimal(3,2)) AND CAST( '0.07' AS decimal(3,2)) (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: l_discount BETWEEN CAST( '0.05' AS decimal(3,2)) AND CAST( '0.07' AS decimal(3,2)) (type: boolean) @@ -254,6 +257,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: q11 + filterExpr: l_discount BETWEEN (0.06 - 0.01) AND (0.06 + 0.01) (type: boolean) Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: l_discount BETWEEN (0.06 - 0.01) AND (0.06 + 0.01) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/gby_star.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/gby_star.q.out b/ql/src/test/results/clientpositive/gby_star.q.out index 1227348..fe2cb82 100644 --- a/ql/src/test/results/clientpositive/gby_star.q.out +++ b/ql/src/test/results/clientpositive/gby_star.q.out @@ -90,6 +90,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -165,6 +166,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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) @@ -243,6 +245,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) < 100.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 100.0D) (type: boolean) @@ -258,6 +261,7 @@ STAGE PLANS: Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE TableScan alias: src + 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/groupby_grouping_sets4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out b/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out index fd1163d..02da8fc 100644 --- a/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out +++ b/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out @@ -40,6 +40,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n143 + filterExpr: (UDFToDouble(a) < 3.0D) (type: boolean) Statistics: Num rows: 1 Data size: 360 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(a) < 3.0D) (type: boolean) @@ -117,6 +118,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n143 + filterExpr: (UDFToDouble(a) < 3.0D) (type: boolean) Statistics: Num rows: 1 Data size: 360 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(a) < 3.0D) (type: boolean) @@ -187,6 +189,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n143 + filterExpr: (UDFToDouble(a) < 3.0D) (type: boolean) Statistics: Num rows: 1 Data size: 360 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(a) < 3.0D) (type: boolean) @@ -264,6 +267,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n143 + filterExpr: (UDFToDouble(a) < 3.0D) (type: boolean) Statistics: Num rows: 1 Data size: 360 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(a) < 3.0D) (type: boolean) @@ -365,6 +369,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n143 + filterExpr: (UDFToDouble(a) < 3.0D) (type: boolean) Statistics: Num rows: 1 Data size: 360 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(a) < 3.0D) (type: boolean) @@ -466,6 +471,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n143 + filterExpr: (UDFToDouble(a) < 3.0D) (type: boolean) Statistics: Num rows: 1 Data size: 360 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(a) < 3.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_join_pushdown.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_join_pushdown.q.out b/ql/src/test/results/clientpositive/groupby_join_pushdown.q.out index e7d958a..d99657b 100644 --- a/ql/src/test/results/clientpositive/groupby_join_pushdown.q.out +++ b/ql/src/test/results/clientpositive/groupby_join_pushdown.q.out @@ -20,6 +20,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + 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) @@ -98,6 +99,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + 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) @@ -161,6 +163,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + 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 +233,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + 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) @@ -288,6 +292,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + 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) @@ -357,6 +362,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + 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) @@ -417,6 +423,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + 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) @@ -495,6 +502,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + 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) @@ -557,6 +565,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: cint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cint is not null (type: boolean) @@ -573,6 +582,7 @@ STAGE PLANS: value expressions: _col0 (type: tinyint), _col2 (type: bigint) TableScan alias: g + filterExpr: cint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cint is not null (type: boolean) @@ -663,6 +673,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: cbigint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cbigint is not null (type: boolean) @@ -740,6 +751,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + filterExpr: cbigint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cbigint is not null (type: boolean) @@ -800,6 +812,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -877,6 +890,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -937,6 +951,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1014,6 +1029,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1074,6 +1090,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1152,6 +1169,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1215,6 +1233,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1293,6 +1312,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1356,6 +1376,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1434,6 +1455,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: g + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1610,6 +1632,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: f + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) @@ -1626,6 +1649,7 @@ STAGE PLANS: value expressions: _col1 (type: int) TableScan alias: g + filterExpr: ctinyint is not null (type: boolean) Statistics: Num rows: 12288 Data size: 2907994 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ctinyint is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_map_ppr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_map_ppr.q.out b/ql/src/test/results/clientpositive/groupby_map_ppr.q.out index 8072273..fd4fd47 100644 --- a/ql/src/test/results/clientpositive/groupby_map_ppr.q.out +++ b/ql/src/test/results/clientpositive/groupby_map_ppr.q.out @@ -32,6 +32,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 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/groupby_map_ppr_multi_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out b/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out index 961be5d..cd5d590 100644 --- a/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out +++ b/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out @@ -32,6 +32,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 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/groupby_multi_single_reducer2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out b/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out index 65540a6..cb74a38 100644 --- a/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out +++ b/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out @@ -39,6 +39,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((substr(key, 1, 1) < 5) or (substr(key, 1, 1) >= 5)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((substr(key, 1, 1) < 5) or (substr(key, 1, 1) >= 5)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out b/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out index aa76313..7ec51ff 100644 --- a/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out +++ b/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out @@ -51,6 +51,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((value) IN ('val_400', 'val_500') and (key) IN (400, 450)) or ((value) IN ('val_100', 'val_200', 'val_300') and (key) IN (100, 150, 200))) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((value) IN ('val_100', 'val_200', 'val_300') and (key) IN (100, 150, 200)) or ((value) IN ('val_400', 'val_500') and (key) IN (400, 450))) (type: boolean) @@ -305,6 +306,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: ((((key + key) = 400) or (((key - 100) = 500) and value is not null)) or (((key + key) = 200) or ((key - 100) = 100) or ((key = 300) and value is not null))) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((((key + key) = 200) or ((key - 100) = 100) or ((key = 300) and value is not null)) or (((key + key) = 400) or (((key - 100) = 500) and value is not null))) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_position.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_position.q.out b/ql/src/test/results/clientpositive/groupby_position.q.out index 81e6976..5678bd5 100644 --- a/ql/src/test/results/clientpositive/groupby_position.q.out +++ b/ql/src/test/results/clientpositive/groupby_position.q.out @@ -593,6 +593,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: (UDFToDouble(key) <= 20.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) <= 20.0D) (type: boolean) @@ -723,6 +724,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + 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 Filter Operator predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) @@ -811,6 +813,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 + filterExpr: ((UDFToDouble(key) > 15.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) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_ppd.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_ppd.q.out b/ql/src/test/results/clientpositive/groupby_ppd.q.out index a2292bd..daebac4 100644 --- a/ql/src/test/results/clientpositive/groupby_ppd.q.out +++ b/ql/src/test/results/clientpositive/groupby_ppd.q.out @@ -20,6 +20,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c + filterExpr: (bar = 1) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (bar = 1) (type: boolean) @@ -42,6 +43,7 @@ STAGE PLANS: Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: d + filterExpr: (bar = 1) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (bar = 1) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_ppr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_ppr.q.out b/ql/src/test/results/clientpositive/groupby_ppr.q.out index d11aa89..d3484eb 100644 --- a/ql/src/test/results/clientpositive/groupby_ppr.q.out +++ b/ql/src/test/results/clientpositive/groupby_ppr.q.out @@ -32,6 +32,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 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/groupby_ppr_multi_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out b/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out index a7c209d..530e797 100644 --- a/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out +++ b/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out @@ -32,6 +32,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator @@ -397,6 +398,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (ds = '2008-04-08') (type: boolean) Statistics: Num rows: 1000 Data size: 10624 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/groupby_rollup_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_rollup_empty.q.out b/ql/src/test/results/clientpositive/groupby_rollup_empty.q.out index be068d1..06dc2b3 100644 --- a/ql/src/test/results/clientpositive/groupby_rollup_empty.q.out +++ b/ql/src/test/results/clientpositive/groupby_rollup_empty.q.out @@ -159,6 +159,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: tx2_n1 + filterExpr: (a < 0) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (a < 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out b/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out index e0f7f5d..210dae7 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out @@ -4256,6 +4256,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n80 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -4279,6 +4280,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: t1_n80 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -4599,6 +4601,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n80 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -4710,6 +4713,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n80 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -7263,6 +7267,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t2_n49 + filterExpr: (UDFToDouble(key) = 8.0D) (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 8.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_sort_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_6.q.out b/ql/src/test/results/clientpositive/groupby_sort_6.q.out index 001fbf5..2bc7e41 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_6.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_6.q.out @@ -34,6 +34,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n61 + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator @@ -291,6 +292,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n61 + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator @@ -539,6 +541,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n61 + filterExpr: (ds = '2') (type: boolean) Statistics: Num rows: 1 Data size: 300 Basic stats: PARTIAL Column stats: NONE GatherStats: false Select Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_sort_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_7.q.out b/ql/src/test/results/clientpositive/groupby_sort_7.q.out index 4170788..7c407db 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_7.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_7.q.out @@ -61,6 +61,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n104 + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), val (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out b/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out index 335ee16..940ede8 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out @@ -4606,6 +4606,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n56 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -4629,6 +4630,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: t1_n56 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -4950,6 +4952,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n56 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -5130,6 +5133,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n56 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -7780,6 +7784,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t2_n34 + filterExpr: (UDFToDouble(key) = 8.0D) (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) = 8.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/having.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/having.q.out b/ql/src/test/results/clientpositive/having.q.out index 4526944..baaca58 100644 --- a/ql/src/test/results/clientpositive/having.q.out +++ b/ql/src/test/results/clientpositive/having.q.out @@ -94,6 +94,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) <> 302.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) <> 302.0D) (type: boolean) @@ -729,6 +730,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (UDFToDouble(key) > 300.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) > 300.0D) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/having2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/having2.q.out b/ql/src/test/results/clientpositive/having2.q.out index 9c11cee..a63c659 100644 --- a/ql/src/test/results/clientpositive/having2.q.out +++ b/ql/src/test/results/clientpositive/having2.q.out @@ -273,6 +273,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: customer_name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: customer_name is not null (type: boolean) @@ -289,6 +290,7 @@ STAGE PLANS: value expressions: _col0 (type: double), _col2 (type: double) TableScan alias: s2 + 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) @@ -393,6 +395,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: customer_name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: customer_name is not null (type: boolean) @@ -409,6 +412,7 @@ STAGE PLANS: value expressions: _col0 (type: double), _col2 (type: double) TableScan alias: s2 + 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) @@ -517,6 +521,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: customer_name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: customer_name is not null (type: boolean) @@ -533,6 +538,7 @@ STAGE PLANS: value expressions: _col0 (type: double), _col2 (type: double) TableScan alias: s2 + 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/identity_project_remove_skip.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out b/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out index 73760d3..a4908fc 100644 --- a/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out +++ b/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out @@ -32,6 +32,7 @@ STAGE PLANS: t2:t1:src TableScan alias: src + filterExpr: ((value = 'val_105') and (key = '105')) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key = '105') and (value = 'val_105')) (type: boolean) @@ -48,6 +49,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key = '105') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '105') (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/implicit_cast1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/implicit_cast1.q.out b/ql/src/test/results/clientpositive/implicit_cast1.q.out index 2d0c4e1..d7d7b8c 100644 --- a/ql/src/test/results/clientpositive/implicit_cast1.q.out +++ b/ql/src/test/results/clientpositive/implicit_cast1.q.out @@ -26,6 +26,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: implicit_test1 + filterExpr: (a <> 0L) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: (a <> 0L) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/implicit_cast_during_insert.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/implicit_cast_during_insert.q.out b/ql/src/test/results/clientpositive/implicit_cast_during_insert.q.out index a515847..5e974bf 100644 --- a/ql/src/test/results/clientpositive/implicit_cast_during_insert.q.out +++ b/ql/src/test/results/clientpositive/implicit_cast_during_insert.q.out @@ -29,6 +29,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (key) IN (0, 1) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key) IN (0, 1) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/implicit_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/implicit_decimal.q.out b/ql/src/test/results/clientpositive/implicit_decimal.q.out index f2b2412..5628249 100644 --- a/ql/src/test/results/clientpositive/implicit_decimal.q.out +++ b/ql/src/test/results/clientpositive/implicit_decimal.q.out @@ -35,6 +35,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_test + filterExpr: (dc = 4327269606205.029297) (type: boolean) Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (dc = 4327269606205.029297) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out b/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out index 8d813a4..fd9e553 100644 --- a/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out +++ b/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out @@ -427,6 +427,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) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out b/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out index 7b790cc..254ac14 100644 --- a/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out +++ b/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out @@ -285,6 +285,7 @@ STAGE PLANS: value expressions: _col0 (type: string), _col1 (type: bigint) 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) @@ -469,6 +470,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + 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) @@ -649,6 +651,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + 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/infer_bucket_sort_num_buckets.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out b/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out index 854ca46..f8445e6 100644 --- a/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out +++ b/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out @@ -34,6 +34,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: if(((key % 3) < 2), 0, 1) (type: int), value (type: string), UDFToInteger((key % 2)) (type: int) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/infer_const_type.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_const_type.q.out b/ql/src/test/results/clientpositive/infer_const_type.q.out index 33f5405..4129bd0 100644 --- a/ql/src/test/results/clientpositive/infer_const_type.q.out +++ b/ql/src/test/results/clientpositive/infer_const_type.q.out @@ -57,6 +57,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: infertypes + filterExpr: ((ti = 127Y) and (si = 32767S) and (i = 12345) and (bi = -12345L) and (fl = 906) and (db = -307.0D) and (UDFToDouble(str) = 1234.0D)) (type: boolean) Statistics: Num rows: 1 Data size: 1170 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(str) = 1234.0D) and (bi = -12345L) and (db = -307.0D) and (fl = 906) and (i = 12345) and (si = 32767S) and (ti = 127Y)) (type: boolean) @@ -130,6 +131,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: infertypes + filterExpr: ((UDFToDouble(ti) = 128.0D) or (UDFToInteger(si) = 32768) or (UDFToDouble(i) = 2.147483648E9D) or (UDFToDouble(bi) = 9.223372036854776E18D)) (type: boolean) Statistics: Num rows: 1 Data size: 1170 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(bi) = 9.223372036854776E18D) or (UDFToDouble(i) = 2.147483648E9D) or (UDFToDouble(ti) = 128.0D) or (UDFToInteger(si) = 32768)) (type: boolean) @@ -194,6 +196,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: infertypes + filterExpr: ((UDFToDouble(ti) = 127.0D) or (CAST( si AS decimal(5,0)) = 327) or (UDFToDouble(i) = -100.0D)) (type: boolean) Statistics: Num rows: 1 Data size: 1170 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((CAST( si AS decimal(5,0)) = 327) or (UDFToDouble(i) = -100.0D) or (UDFToDouble(ti) = 127.0D)) (type: boolean) @@ -252,6 +255,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: infertypes + filterExpr: ((UDFToDouble(ti) < 127.0D) and (UDFToDouble(i) > 100.0D) and (UDFToDouble(str) = 1.57D)) (type: boolean) Statistics: Num rows: 1 Data size: 1170 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(i) > 100.0D) and (UDFToDouble(str) = 1.57D) and (UDFToDouble(ti) < 127.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/infer_join_preds.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_join_preds.q.out b/ql/src/test/results/clientpositive/infer_join_preds.q.out index d8163aa..b26a907 100644 --- a/ql/src/test/results/clientpositive/infer_join_preds.q.out +++ b/ql/src/test/results/clientpositive/infer_join_preds.q.out @@ -14,6 +14,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) @@ -30,6 +31,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b + 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) @@ -623,6 +625,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (4.0D BETWEEN UDFToDouble(key) AND UDFToDouble(value) and 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: (4.0D BETWEEN UDFToDouble(key) AND UDFToDouble(value) and key is not null and value is not null) (type: boolean) @@ -638,6 +641,7 @@ STAGE PLANS: Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE TableScan alias: src1 + filterExpr: (4.0D BETWEEN UDFToDouble(key) AND UDFToDouble(value) and key is not null and value is not null) (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (4.0D BETWEEN UDFToDouble(key) AND UDFToDouble(value) and key is not null and value is not null) (type: boolean) @@ -1120,6 +1124,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s + filterExpr: prid is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: prid is not null (type: boolean) @@ -1136,6 +1141,7 @@ STAGE PLANS: value expressions: _col0 (type: bigint), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6 (type: bigint), _col7 (type: varchar(96)), _col8 (type: timestamp), _col9 (type: bigint), _col10 (type: bigint), _col11 (type: int), _col12 (type: bigint), _col13 (type: varchar(30)), _col14 (type: varchar(30)), _col15 (type: bigint), _col16 (type: bigint), _col17 (type: bigint), _col18 (type: decimal(38,20)) TableScan alias: e + filterExpr: prid is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: prid is not null (type: boolean) @@ -1151,6 +1157,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE TableScan alias: d + filterExpr: prid is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: prid is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/innerjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/innerjoin.q.out b/ql/src/test/results/clientpositive/innerjoin.q.out index 779b074..6dab117 100644 --- a/ql/src/test/results/clientpositive/innerjoin.q.out +++ b/ql/src/test/results/clientpositive/innerjoin.q.out @@ -26,6 +26,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -41,6 +42,7 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE TableScan alias: src2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/innerjoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/innerjoin1.q.out b/ql/src/test/results/clientpositive/innerjoin1.q.out index 291ba55..d17ed26 100644 --- a/ql/src/test/results/clientpositive/innerjoin1.q.out +++ b/ql/src/test/results/clientpositive/innerjoin1.q.out @@ -76,6 +76,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c1 + filterExpr: COALESCE(a1,a2) is not null (type: boolean) Statistics: Num rows: 2 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: COALESCE(a1,a2) is not null (type: boolean) @@ -92,6 +93,7 @@ STAGE PLANS: value expressions: _col0 (type: string), _col1 (type: string) TableScan alias: c2 + filterExpr: COALESCE(b1,b2) is not null (type: boolean) Statistics: Num rows: 2 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: COALESCE(b1,b2) is not null (type: boolean) @@ -155,6 +157,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c1 + filterExpr: COALESCE(a1,a2) is not null (type: boolean) Statistics: Num rows: 2 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: COALESCE(a1,a2) is not null (type: boolean) @@ -171,6 +174,7 @@ STAGE PLANS: value expressions: _col0 (type: string), _col1 (type: string) TableScan alias: c2 + filterExpr: COALESCE(b1,b2) is not null (type: boolean) Statistics: Num rows: 2 Data size: 7 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: COALESCE(b1,b2) is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/input11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input11.q.out b/ql/src/test/results/clientpositive/input11.q.out index c1c185f..e103787 100644 --- a/ql/src/test/results/clientpositive/input11.q.out +++ b/ql/src/test/results/clientpositive/input11.q.out @@ -30,6 +30,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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/input11_limit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input11_limit.q.out b/ql/src/test/results/clientpositive/input11_limit.q.out index b31a3de..ee09d80 100644 --- a/ql/src/test/results/clientpositive/input11_limit.q.out +++ b/ql/src/test/results/clientpositive/input11_limit.q.out @@ -25,6 +25,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + 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/input23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input23.q.out b/ql/src/test/results/clientpositive/input23.q.out index e931c8b..caf02ee 100644 --- a/ql/src/test/results/clientpositive/input23.q.out +++ b/ql/src/test/results/clientpositive/input23.q.out @@ -15,6 +15,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 GatherStats: false Select Operator @@ -30,6 +31,7 @@ STAGE PLANS: auto parallelism: false 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 GatherStats: false Filter Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/input25.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input25.q.out b/ql/src/test/results/clientpositive/input25.q.out index c573a12..16354eb 100644 --- a/ql/src/test/results/clientpositive/input25.q.out +++ b/ql/src/test/results/clientpositive/input25.q.out @@ -46,6 +46,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (d = '2009-01-01') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: a (type: int), b (type: int) @@ -108,6 +109,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (d = '2009-02-02') (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: a (type: int), b (type: int) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/input26.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input26.q.out b/ql/src/test/results/clientpositive/input26.q.out index 93898b6..6b4a711 100644 --- a/ql/src/test/results/clientpositive/input26.q.out +++ b/ql/src/test/results/clientpositive/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) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/input2_limit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input2_limit.q.out b/ql/src/test/results/clientpositive/input2_limit.q.out index bcf713d..6cb4480 100644 --- a/ql/src/test/results/clientpositive/input2_limit.q.out +++ b/ql/src/test/results/clientpositive/input2_limit.q.out @@ -14,6 +14,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x + filterExpr: (UDFToDouble(key) < 300.0D) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (UDFToDouble(key) < 300.0D) (type: boolean)
