http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join28.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join28.q.out b/ql/src/test/results/clientpositive/auto_join28.q.out index d93f397..c6233e7 100644 --- a/ql/src/test/results/clientpositive/auto_join28.q.out +++ b/ql/src/test/results/clientpositive/auto_join28.q.out @@ -36,6 +36,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key > 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 10) (type: boolean) @@ -125,6 +126,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key > 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 10) (type: boolean) @@ -141,6 +143,7 @@ STAGE PLANS: src3 TableScan alias: src3 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -230,6 +233,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -246,6 +250,7 @@ STAGE PLANS: src3 TableScan alias: src3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -335,6 +340,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join29.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join29.q.out b/ql/src/test/results/clientpositive/auto_join29.q.out index a784add..ab1047e 100644 --- a/ql/src/test/results/clientpositive/auto_join29.q.out +++ b/ql/src/test/results/clientpositive/auto_join29.q.out @@ -36,6 +36,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key > 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 10) (type: boolean) @@ -633,6 +634,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key > 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > 10) (type: boolean) @@ -649,6 +651,7 @@ STAGE PLANS: src3 TableScan alias: src3 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -1246,6 +1249,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -1262,6 +1266,7 @@ STAGE PLANS: src3 TableScan alias: src3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -1871,6 +1876,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -2493,6 +2499,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -2505,6 +2512,7 @@ STAGE PLANS: src3 TableScan alias: src3 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -2520,6 +2528,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 + filterExpr: ((key < 10) and (key > 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -2597,6 +2606,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -2613,6 +2623,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: ((key < 10) and (key > 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -3210,6 +3221,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: ((key < 10) and (key > 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -3226,6 +3238,7 @@ STAGE PLANS: src3 TableScan alias: src3 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -3323,6 +3336,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -3339,6 +3353,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -3358,6 +3373,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src3 + filterExpr: (key < 10) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key < 10) (type: boolean) @@ -3461,6 +3477,7 @@ STAGE PLANS: src1 TableScan alias: src1 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -3473,6 +3490,7 @@ STAGE PLANS: src2 TableScan alias: src2 + filterExpr: ((key < 10) and (key > 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) @@ -3488,6 +3506,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src3 + filterExpr: ((key > 10) and (key < 10)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key < 10) and (key > 10)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join3.q.out b/ql/src/test/results/clientpositive/auto_join3.q.out index 68aa4c2..2bffe6e 100644 --- a/ql/src/test/results/clientpositive/auto_join3.q.out +++ b/ql/src/test/results/clientpositive/auto_join3.q.out @@ -35,6 +35,7 @@ STAGE PLANS: $hdt$_0: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) @@ -51,6 +52,7 @@ STAGE PLANS: $hdt$_1:src2 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) @@ -70,6 +72,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src3 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join32.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join32.q.out b/ql/src/test/results/clientpositive/auto_join32.q.out index 0e1d3c6..09fcd7d 100644 --- a/ql/src/test/results/clientpositive/auto_join32.q.out +++ b/ql/src/test/results/clientpositive/auto_join32.q.out @@ -40,6 +40,7 @@ STAGE PLANS: $hdt$_0:s TableScan alias: s + filterExpr: name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: name is not null (type: boolean) @@ -58,6 +59,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: v + filterExpr: name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: name is not null (type: boolean) @@ -160,6 +162,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s + filterExpr: name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: name is not null (type: boolean) @@ -271,6 +274,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s + filterExpr: name is not null (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: name is not null (type: boolean) @@ -404,6 +408,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s + filterExpr: ((p = 'bar') and name is not null) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: ((p = 'bar') and name is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join33.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join33.q.out b/ql/src/test/results/clientpositive/auto_join33.q.out index ec6018d..9c9c898 100644 --- a/ql/src/test/results/clientpositive/auto_join33.q.out +++ b/ql/src/test/results/clientpositive/auto_join33.q.out @@ -28,6 +28,7 @@ STAGE PLANS: $hdt$_0:src TableScan alias: src + filterExpr: (((UDFToDouble(key) + 1.0D) < 10.0D) and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) + 1.0D) < 10.0D) and key is not null) (type: boolean) @@ -46,6 +47,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (((UDFToDouble(key) + 2.0D) < 10.0D) and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(key) + 2.0D) < 10.0D) and key is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join4.q.out b/ql/src/test/results/clientpositive/auto_join4.q.out index c8b778c..0d92656 100644 --- a/ql/src/test/results/clientpositive/auto_join4.q.out +++ b/ql/src/test/results/clientpositive/auto_join4.q.out @@ -54,6 +54,7 @@ STAGE PLANS: $hdt$_1:src2 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) @@ -72,6 +73,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: ((UDFToDouble(key) > 10.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) > 10.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join5.q.out b/ql/src/test/results/clientpositive/auto_join5.q.out index 79b4dec..b3c1c25 100644 --- a/ql/src/test/results/clientpositive/auto_join5.q.out +++ b/ql/src/test/results/clientpositive/auto_join5.q.out @@ -54,6 +54,7 @@ STAGE PLANS: $hdt$_0:src1 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) @@ -72,6 +73,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 + filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join6.q.out b/ql/src/test/results/clientpositive/auto_join6.q.out index 1f652fc..a3e829f 100644 --- a/ql/src/test/results/clientpositive/auto_join6.q.out +++ b/ql/src/test/results/clientpositive/auto_join6.q.out @@ -48,6 +48,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: ((UDFToDouble(key) > 10.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) > 10.0D)) (type: boolean) @@ -64,6 +65,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: src2 + filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join7.q.out b/ql/src/test/results/clientpositive/auto_join7.q.out index 7ca170a..1f2616e 100644 --- a/ql/src/test/results/clientpositive/auto_join7.q.out +++ b/ql/src/test/results/clientpositive/auto_join7.q.out @@ -58,6 +58,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: ((UDFToDouble(key) > 10.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) > 10.0D)) (type: boolean) @@ -74,6 +75,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: src2 + filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean) @@ -90,6 +92,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: src3 + filterExpr: ((UDFToDouble(key) > 20.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join8.q.out b/ql/src/test/results/clientpositive/auto_join8.q.out index b959822..e550810 100644 --- a/ql/src/test/results/clientpositive/auto_join8.q.out +++ b/ql/src/test/results/clientpositive/auto_join8.q.out @@ -54,6 +54,7 @@ STAGE PLANS: $hdt$_1:src2 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) @@ -72,6 +73,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: ((UDFToDouble(key) > 10.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) > 10.0D)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join9.q.out b/ql/src/test/results/clientpositive/auto_join9.q.out index 80c1649..fb09841 100644 --- a/ql/src/test/results/clientpositive/auto_join9.q.out +++ b/ql/src/test/results/clientpositive/auto_join9.q.out @@ -32,6 +32,7 @@ STAGE PLANS: $hdt$_0:src1 TableScan alias: src1 + filterExpr: ((ds = '2008-04-08') and (hr = '12') and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -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/auto_join_reordering_values.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out b/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out index e66e402..259142d 100644 --- a/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out +++ b/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out @@ -93,6 +93,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: orderpayment + filterExpr: (date is not null and dealid is not null and cityid is not null and userid is not null) (type: boolean) Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -114,6 +115,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: dim_pay_date + filterExpr: date is not null (type: boolean) Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -230,6 +232,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: deal + filterExpr: dealid is not null (type: boolean) Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -369,6 +372,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: order_city + filterExpr: cityid is not null (type: boolean) Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -508,6 +512,7 @@ STAGE PLANS: auto parallelism: false TableScan alias: user + filterExpr: userid is not null (type: boolean) Statistics: Num rows: 100 Data size: 288 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/auto_join_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join_stats.q.out b/ql/src/test/results/clientpositive/auto_join_stats.q.out index 321c977..346c9c2 100644 --- a/ql/src/test/results/clientpositive/auto_join_stats.q.out +++ b/ql/src/test/results/clientpositive/auto_join_stats.q.out @@ -51,6 +51,7 @@ STAGE PLANS: $hdt$_1:src2 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) @@ -69,6 +70,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) @@ -105,6 +107,7 @@ STAGE PLANS: $hdt$_2:smalltable_n0 TableScan alias: smalltable_n0 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -151,6 +154,7 @@ STAGE PLANS: $hdt$_0: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) @@ -169,6 +173,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) @@ -200,6 +205,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) @@ -215,6 +221,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) @@ -315,6 +322,7 @@ STAGE PLANS: $hdt$_2:src2 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) @@ -333,6 +341,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) @@ -372,6 +381,7 @@ STAGE PLANS: $hdt$_0:smalltable_n0 TableScan alias: smalltable_n0 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -388,6 +398,7 @@ STAGE PLANS: $hdt$_3:smalltable2_n0 TableScan alias: smalltable2_n0 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -441,6 +452,7 @@ STAGE PLANS: $hdt$_1:src1 TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -459,6 +471,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) @@ -490,6 +503,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) @@ -505,6 +519,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/auto_join_stats2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join_stats2.q.out b/ql/src/test/results/clientpositive/auto_join_stats2.q.out index 1b274a1..6eab581 100644 --- a/ql/src/test/results/clientpositive/auto_join_stats2.q.out +++ b/ql/src/test/results/clientpositive/auto_join_stats2.q.out @@ -38,6 +38,7 @@ STAGE PLANS: $hdt$_0: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) @@ -53,6 +54,7 @@ STAGE PLANS: $hdt$_2:smalltable TableScan alias: smalltable + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -71,6 +73,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) @@ -182,6 +185,7 @@ STAGE PLANS: $hdt$_0:smalltable TableScan alias: smalltable + filterExpr: key is not null (type: boolean) Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -198,6 +202,7 @@ STAGE PLANS: $hdt$_1:src1 TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -213,6 +218,7 @@ STAGE PLANS: $hdt$_3:smalltable2 TableScan alias: smalltable2 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -232,6 +238,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/auto_join_without_localtask.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out b/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out index ad5e187..2f32cf2 100644 --- a/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out +++ b/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out @@ -28,6 +28,7 @@ STAGE PLANS: $hdt$_1:b 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) @@ -46,6 +47,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) @@ -106,6 +108,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -124,6 +127,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) @@ -154,6 +158,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) @@ -170,6 +175,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -292,6 +298,7 @@ STAGE PLANS: $hdt$_1:b 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) @@ -310,6 +317,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) @@ -348,6 +356,7 @@ STAGE PLANS: $hdt$_2:c TableScan alias: c + 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) @@ -412,6 +421,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c + 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) @@ -456,6 +466,7 @@ STAGE PLANS: value expressions: _col0 (type: string) TableScan alias: c + 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) @@ -495,6 +506,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) @@ -513,6 +525,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) @@ -543,6 +556,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) @@ -559,6 +573,7 @@ STAGE PLANS: value expressions: _col1 (type: string) 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) @@ -684,6 +699,7 @@ STAGE PLANS: $hdt$_2:b TableScan alias: b + 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) @@ -702,6 +718,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean) @@ -740,6 +757,7 @@ STAGE PLANS: $hdt$_0:c TableScan alias: c + 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) @@ -804,6 +822,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c + 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) @@ -848,6 +867,7 @@ STAGE PLANS: value expressions: _col0 (type: string) TableScan alias: c + 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) @@ -887,6 +907,7 @@ STAGE PLANS: $hdt$_1:a TableScan alias: a + filterExpr: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean) @@ -905,6 +926,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + 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) @@ -935,6 +957,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean) @@ -951,6 +974,7 @@ STAGE PLANS: value expressions: _col1 (type: string) TableScan alias: b + 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/avro_schema_evolution_native.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out b/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out index 6860b47..6b3920c 100644 --- a/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out +++ b/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out @@ -250,6 +250,7 @@ STAGE PLANS: Processor Tree: TableScan alias: episodes_partitioned_n0 + filterExpr: (doctor_pt > 6) (type: boolean) Statistics: Num rows: 3 Data size: 8950 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: title (type: string), air_date (type: string), doctor (type: int), value (type: int), doctor_pt (type: int) @@ -339,6 +340,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: episodes_partitioned_n0 + filterExpr: (doctor_pt > 6) (type: boolean) Statistics: Num rows: 3 Data size: 8950 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: title (type: string), air_date (type: string), doctor (type: int), value (type: int), doctor_pt (type: int) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out b/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out index 1837756..1d4c7ad 100644 --- a/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out +++ b/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out @@ -49,6 +49,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n22 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -64,6 +65,7 @@ STAGE PLANS: Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: t2_n14 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 5 Data size: 5 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -148,6 +150,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n22 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2/2 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -163,6 +166,7 @@ STAGE PLANS: Statistics: Num rows: 2/2 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: t2_n14 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 5/5 Data size: 5 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -255,6 +259,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n22 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) @@ -270,6 +275,7 @@ STAGE PLANS: Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE TableScan alias: t2_n14 + filterExpr: id is not null (type: boolean) Statistics: Num rows: 5 Data size: 5 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: id is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out index a0f916b..ff02643 100644 --- a/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out +++ b/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out @@ -172,6 +172,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (a = 3) (type: boolean) @@ -186,6 +187,7 @@ STAGE PLANS: value expressions: _col0 (type: decimal(10,2)) TableScan alias: cmv_basetable_n10 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -293,6 +295,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: ((a = 3) and (d = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -393,6 +396,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (a = 3) (type: boolean) @@ -407,6 +411,7 @@ STAGE PLANS: value expressions: _col0 (type: decimal(10,2)) TableScan alias: cmv_basetable_n10 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out index fa834ac..733a3f5 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out @@ -108,6 +108,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -329,6 +330,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2080 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/beeline/smb_mapjoin_10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out index 25e5eac..6938b0e 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out @@ -78,6 +78,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: (userid is not null and pageid is not null and postid is not null and type is not null) (type: boolean) Statistics: Num rows: 13 Data size: 4140 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (pageid is not null and postid is not null and type is not null and userid is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out index afc7e95..9f946e0 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out @@ -58,6 +58,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out index c635658..c626c7e 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out @@ -69,6 +69,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -271,6 +272,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((ds = '1') and key is not null) (type: boolean) Statistics: Num rows: 3084 Data size: 32904 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/beeline/smb_mapjoin_13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out index 2dd921f..123e844 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out @@ -76,6 +76,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 GatherStats: false Filter Operator @@ -237,6 +238,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: UDFToDouble(value) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -254,6 +256,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: UDFToDouble(key) is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out index 4f6406b..3fb1769 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out @@ -48,6 +48,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) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out index 3353eb5..e39edcc 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out @@ -62,6 +62,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -287,6 +288,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2080 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/beeline/smb_mapjoin_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out index e116fa7..fa7968d 100644 --- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out +++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out @@ -62,6 +62,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -285,6 +286,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 2060 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/bucket3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket3.q.out b/ql/src/test/results/clientpositive/bucket3.q.out index 0ad6d04..d9ee0dc 100644 --- a/ql/src/test/results/clientpositive/bucket3.q.out +++ b/ql/src/test/results/clientpositive/bucket3.q.out @@ -317,6 +317,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s + filterExpr: (ds = '1') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/bucket_map_join_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket_map_join_1.q.out b/ql/src/test/results/clientpositive/bucket_map_join_1.q.out index 6d837a3..fb99ead 100644 --- a/ql/src/test/results/clientpositive/bucket_map_join_1.q.out +++ b/ql/src/test/results/clientpositive/bucket_map_join_1.q.out @@ -64,6 +64,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -81,6 +82,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 200 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/bucket_map_join_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket_map_join_2.q.out b/ql/src/test/results/clientpositive/bucket_map_join_2.q.out index 0761f2f..3377621 100644 --- a/ql/src/test/results/clientpositive/bucket_map_join_2.q.out +++ b/ql/src/test/results/clientpositive/bucket_map_join_2.q.out @@ -64,6 +64,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -81,6 +82,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 1 Data size: 200 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/bucket_map_join_spark1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out index e4c7c64..4650034 100644 --- a/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out +++ b/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out @@ -183,6 +183,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -204,6 +205,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -625,6 +627,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -646,6 +649,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 149 Data size: 58120 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/bucket_map_join_spark2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out index eed3365..64c5bf4 100644 --- a/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out +++ b/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out @@ -167,6 +167,7 @@ STAGE PLANS: $hdt$_1:b TableScan alias: b + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -188,6 +189,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -609,6 +611,7 @@ STAGE PLANS: $hdt$_1:b TableScan alias: b + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -630,6 +633,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 149 Data size: 58120 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/bucket_map_join_spark3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out index 4841f6d..e7a9263 100644 --- a/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out +++ b/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out @@ -167,6 +167,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -188,6 +189,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -609,6 +611,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -630,6 +633,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean) Statistics: Num rows: 149 Data size: 58120 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/bucket_map_join_spark4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out index 96a0593..31d7870 100644 --- a/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out +++ b/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out @@ -85,6 +85,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -103,6 +104,7 @@ STAGE PLANS: $hdt$_2:c TableScan alias: c + filterExpr: value is not null (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -124,6 +126,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -447,6 +450,7 @@ STAGE PLANS: $hdt$_0:a TableScan alias: a + filterExpr: (key is not null and value is not null) (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -465,6 +469,7 @@ STAGE PLANS: $hdt$_2:c TableScan alias: c + filterExpr: value is not null (type: boolean) Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -486,6 +491,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 10 Data size: 70 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/bucketcontext_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_1.q.out b/ql/src/test/results/clientpositive/bucketcontext_1.q.out index 6060fe7..42c6301 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_1.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_1.q.out @@ -166,6 +166,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 56 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -190,6 +191,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -393,6 +395,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 240 Data size: 116240 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/bucketcontext_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_2.q.out b/ql/src/test/results/clientpositive/bucketcontext_2.q.out index f998650..f9b0201 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_2.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_2.q.out @@ -150,6 +150,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 120 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -174,6 +175,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -377,6 +379,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 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/bucketcontext_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_3.q.out b/ql/src/test/results/clientpositive/bucketcontext_3.q.out index 15b3d14..520dad8 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_3.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_3.q.out @@ -198,6 +198,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -222,6 +223,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 120 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -374,6 +376,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 120 Data size: 58120 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/bucketcontext_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_4.q.out b/ql/src/test/results/clientpositive/bucketcontext_4.q.out index f448796..486a8e7 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_4.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_4.q.out @@ -214,6 +214,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -238,6 +239,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 56 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -390,6 +392,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 56 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/bucketcontext_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_5.q.out b/ql/src/test/results/clientpositive/bucketcontext_5.q.out index 629c364..e14c61b 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_5.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_5.q.out @@ -82,6 +82,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -106,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -252,6 +254,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + 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/bucketcontext_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_6.q.out b/ql/src/test/results/clientpositive/bucketcontext_6.q.out index c6e940c..548a34d 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_6.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_6.q.out @@ -100,6 +100,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -124,6 +125,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -325,6 +327,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 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/bucketcontext_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_7.q.out b/ql/src/test/results/clientpositive/bucketcontext_7.q.out index ec8806f..970917e 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_7.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_7.q.out @@ -231,6 +231,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -255,6 +256,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -460,6 +462,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 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/bucketcontext_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketcontext_8.q.out b/ql/src/test/results/clientpositive/bucketcontext_8.q.out index 2eda939..d46d623 100644 --- a/ql/src/test/results/clientpositive/bucketcontext_8.q.out +++ b/ql/src/test/results/clientpositive/bucketcontext_8.q.out @@ -231,6 +231,7 @@ STAGE PLANS: a TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -255,6 +256,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -460,6 +462,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 240 Data size: 116240 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/bucketmapjoin10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin10.q.out b/ql/src/test/results/clientpositive/bucketmapjoin10.q.out index a8951d1..d9a8414 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin10.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin10.q.out @@ -247,6 +247,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: (part is not null and key is not null) (type: boolean) Statistics: Num rows: 178 Data size: 69500 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -264,6 +265,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (part is not null and key is not null) (type: boolean) Statistics: Num rows: 178 Data size: 69500 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/bucketmapjoin11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin11.q.out b/ql/src/test/results/clientpositive/bucketmapjoin11.q.out index e54a8c3..7fbde83 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin11.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin11.q.out @@ -255,6 +255,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: (part is not null and key is not null) (type: boolean) Statistics: Num rows: 219 Data size: 85620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -279,6 +280,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (part is not null and key is not null) (type: boolean) Statistics: Num rows: 219 Data size: 85620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -592,6 +594,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: (part is not null and key is not null) (type: boolean) Statistics: Num rows: 219 Data size: 85620 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -616,6 +619,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (part is not null and key is not null) (type: boolean) Statistics: Num rows: 219 Data size: 85620 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/bucketmapjoin12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin12.q.out b/ql/src/test/results/clientpositive/bucketmapjoin12.q.out index f892b8e..ede40f0 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin12.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin12.q.out @@ -168,6 +168,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 @@ -192,6 +193,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 @@ -403,6 +405,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 @@ -420,6 +423,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/bucketmapjoin13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin13.q.out b/ql/src/test/results/clientpositive/bucketmapjoin13.q.out index 2f9b3ca..8aa75e7 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin13.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin13.q.out @@ -137,6 +137,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -154,6 +155,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: key is not null (type: boolean) Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -420,6 +422,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -444,6 +447,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: ((part = '2') and key is not null) (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -666,6 +670,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -690,6 +695,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 GatherStats: false Filter Operator @@ -912,6 +918,7 @@ STAGE PLANS: b TableScan alias: b + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -936,6 +943,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 GatherStats: false Filter Operator
