FAQ
Author: brock
Date: Wed Dec 24 14:34:31 2014
New Revision: 1647796

URL: http://svn.apache.org/r1647796
Log:
HIVE-9181 - Fix SkewJoinOptimizer related Java 8 ordering differences (Mohit Sabharwal via Brock)

Modified:
     hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
     hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SkewJoinOptimizer.java
     hive/trunk/ql/src/test/results/clientpositive/describe_database.q.out
     hive/trunk/ql/src/test/results/clientpositive/quotedid_skew.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt1.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt10.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt11.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt12.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt14.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt15.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt16.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt17.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt19.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt20.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt3.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt4.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt5.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt6.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt7.q.out
     hive/trunk/ql/src/test/results/clientpositive/skewjoinopt8.q.out

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java Wed Dec 24 14:34:31 2014
@@ -2907,6 +2907,14 @@ public class DDLTask extends Task<DDLWor
        if (descDatabase.isExt()) {
          params = database.getParameters();
        }
+
+ // If this is a q-test, let's order the params map (lexicographically) by
+ // key. This is to get consistent param ordering between Java7 and Java8.
+ if (HiveConf.getBoolVar(conf, HiveConf.ConfVars.HIVE_IN_TEST) &&
+ params != null) {
+ params = new TreeMap<String, String>(params);
+ }
+
        String location = database.getLocationUri();
        if (HiveConf.getBoolVar(conf, HiveConf.ConfVars.HIVE_IN_TEST)) {
          location = "location/in/test";

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SkewJoinOptimizer.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SkewJoinOptimizer.java?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SkewJoinOptimizer.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SkewJoinOptimizer.java Wed Dec 24 14:34:31 2014
@@ -588,8 +588,10 @@ public class SkewJoinOptimizer implement

      private Map<String, Operator<? extends OperatorDesc>> getTopOps(
        Operator<? extends OperatorDesc> op) {
+ // Must be deterministic order map for consistent q-test output across
+ // Java versions
        Map<String, Operator<? extends OperatorDesc>> topOps =
- new HashMap<String, Operator<? extends OperatorDesc>>();
+ new LinkedHashMap<String, Operator<? extends OperatorDesc>>();
        if (op.getParentOperators() == null || op.getParentOperators().size() == 0) {
          topOps.put(((TableScanOperator)op).getConf().getAlias(), op);
        } else {

Modified: hive/trunk/ql/src/test/results/clientpositive/describe_database.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/describe_database.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/describe_database.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/describe_database.q.out Wed Dec 24 14:34:31 2014
@@ -8,12 +8,12 @@ PREHOOK: query: desc database extended t
  PREHOOK: type: DESCDATABASE
  POSTHOOK: query: desc database extended test_db
  POSTHOOK: type: DESCDATABASE
-test_db location/in/test hive_test_user USER {key2=value2, key1=value1}
+test_db location/in/test hive_test_user USER {key1=value1, key2=value2}
  PREHOOK: query: desc schema extended test_db
  PREHOOK: type: DESCDATABASE
  POSTHOOK: query: desc schema extended test_db
  POSTHOOK: type: DESCDATABASE
-test_db location/in/test hive_test_user USER {key2=value2, key1=value1}
+test_db location/in/test hive_test_user USER {key1=value1, key2=value2}
  PREHOOK: query: drop database test_db
  PREHOOK: type: DROPDATABASE
  PREHOOK: Input: database:test_db

Modified: hive/trunk/ql/src/test/results/clientpositive/quotedid_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quotedid_skew.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/quotedid_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/quotedid_skew.q.out Wed Dec 24 14:34:31 2014
@@ -128,7 +128,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (!@#$%^&*()_q is not null and (not (!@#$%^&*()_q = '2'))) (type: boolean)
@@ -140,7 +140,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: y&y (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (!@#$%^&*()_q is not null and (not (!@#$%^&*()_q = '2'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out Wed Dec 24 14:34:31 2014
@@ -269,7 +269,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not (((key = '2') or (key = '8')) or (key = '3'))) (type: boolean)
@@ -281,7 +281,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not (((key = '2') or (key = '8')) or (key = '3'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out Wed Dec 24 14:34:31 2014
@@ -118,7 +118,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -130,7 +130,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -251,7 +251,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)
@@ -263,7 +263,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)
@@ -403,7 +403,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -415,7 +415,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -554,7 +554,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)
@@ -566,7 +566,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out Wed Dec 24 14:34:31 2014
@@ -144,7 +144,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
@@ -156,8 +156,8 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: c
- Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
+ alias: b
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -168,8 +168,8 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ alias: c
+ Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt1.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt1.q.out Wed Dec 24 14:34:31 2014
@@ -128,7 +128,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -140,7 +140,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -284,7 +284,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)
@@ -296,7 +296,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)
@@ -456,7 +456,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -467,7 +467,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -608,7 +608,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)
@@ -619,7 +619,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((key = '2') or (key = '3'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt10.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt10.q.out Wed Dec 24 14:34:31 2014
@@ -199,28 +199,28 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
- Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ alias: a
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '8'))) (type: boolean)
- Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                Reduce Output Operator
                  key expressions: key (type: string)
                  sort order: +
                  Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: array<string>)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ alias: b
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '8'))) (type: boolean)
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: key (type: string)
                  sort order: +
                  Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: array<string>)
        Reduce Operator Tree:
          Join Operator
            condition map:

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt11.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt11.q.out Wed Dec 24 14:34:31 2014
@@ -243,7 +243,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -255,7 +255,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -287,7 +287,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -299,7 +299,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt12.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt12.q.out Wed Dec 24 14:34:31 2014
@@ -128,7 +128,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not ((((key = '2') and (val = '12')) or ((key = '8') and (val = '18'))) or ((key = '3') and (val = '13'))))) (type: boolean)
@@ -139,7 +139,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not ((((key = '2') and (val = '12')) or ((key = '8') and (val = '18'))) or ((key = '3') and (val = '13'))))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt14.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt14.q.out Wed Dec 24 14:34:31 2014
@@ -186,10 +186,10 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
- predicate: (key is not null and (not (key = '2'))) (type: boolean)
+ predicate: ((key is not null and val is not null) and (not (key = '2'))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                Reduce Output Operator
                  key expressions: key (type: string)
@@ -198,10 +198,10 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
- predicate: ((key is not null and val is not null) and (not (key = '2'))) (type: boolean)
+ predicate: (key is not null and (not (key = '2'))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                Reduce Output Operator
                  key expressions: key (type: string)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt15.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt15.q.out Wed Dec 24 14:34:31 2014
@@ -168,7 +168,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = 2) or (key = 3)))) (type: boolean)
@@ -180,7 +180,7 @@ STAGE PLANS:
                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = 2) or (key = 3)))) (type: boolean)
@@ -324,7 +324,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (not ((key = 2) or (key = 3))) (type: boolean)
@@ -336,7 +336,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (not ((key = 2) or (key = 3))) (type: boolean)
@@ -496,7 +496,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = 2) or (key = 3)))) (type: boolean)
@@ -507,7 +507,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: int)
                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = 2) or (key = 3)))) (type: boolean)
@@ -648,7 +648,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (not ((key = 2) or (key = 3))) (type: boolean)
@@ -659,7 +659,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: int)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (not ((key = 2) or (key = 3))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt16.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt16.q.out Wed Dec 24 14:34:31 2014
@@ -128,7 +128,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not (((key = '2') and (val = '12')) or (key = '3')))) (type: boolean)
@@ -139,7 +139,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not (((key = '2') and (val = '12')) or (key = '3')))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt17.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt17.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt17.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt17.q.out Wed Dec 24 14:34:31 2014
@@ -134,7 +134,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -146,7 +146,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -344,7 +344,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not (((key = '2') and (val = '12')) or (key = '2')))) (type: boolean)
@@ -355,7 +355,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not (((key = '2') and (val = '12')) or (key = '2')))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt19.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt19.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt19.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt19.q.out Wed Dec 24 14:34:31 2014
@@ -132,7 +132,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -144,7 +144,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out Wed Dec 24 14:34:31 2014
@@ -136,7 +136,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8')))) (type: boolean)
@@ -147,7 +147,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8')))) (type: boolean)
@@ -285,7 +285,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8'))) (type: boolean)
@@ -296,7 +296,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8'))) (type: boolean)
@@ -462,7 +462,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8')))) (type: boolean)
@@ -473,7 +473,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: ((key is not null and val is not null) and (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8')))) (type: boolean)
@@ -624,7 +624,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8'))) (type: boolean)
@@ -635,7 +635,7 @@ STAGE PLANS:
                  Map-reduce partition columns: key (type: string), val (type: string)
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not ((((key = '2') or (key = '7')) or (key = '3')) or (key = '8'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt20.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt20.q.out Wed Dec 24 14:34:31 2014
@@ -132,7 +132,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -144,7 +144,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt3.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt3.q.out Wed Dec 24 14:34:31 2014
@@ -132,7 +132,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
@@ -144,7 +144,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
@@ -288,7 +288,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not (((key = '2') or (key = '8')) or (key = '3'))) (type: boolean)
@@ -300,7 +300,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (not (((key = '2') or (key = '8')) or (key = '3'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt4.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt4.q.out Wed Dec 24 14:34:31 2014
@@ -128,7 +128,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -140,7 +140,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -282,7 +282,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)
@@ -294,7 +294,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (key = '2'))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt5.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt5.q.out Wed Dec 24 14:34:31 2014
@@ -130,7 +130,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)
@@ -142,7 +142,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '2') or (key = '3')))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt6.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt6.q.out Wed Dec 24 14:34:31 2014
@@ -132,7 +132,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
@@ -144,7 +144,7 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
+ alias: b
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt7.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt7.q.out Wed Dec 24 14:34:31 2014
@@ -162,7 +162,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
@@ -174,8 +174,8 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: c
- Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
+ alias: b
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -186,8 +186,8 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ alias: c
+ Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not (((key = '2') or (key = '8')) or (key = '3')))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoinopt8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt8.q.out?rev=1647796&r1=1647795&r2=1647796&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt8.q.out Wed Dec 24 14:34:31 2014
@@ -160,7 +160,7 @@ STAGE PLANS:
      Map Reduce
        Map Operator Tree:
            TableScan
- alias: b
+ alias: a
              Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '3') or (key = '8')))) (type: boolean)
@@ -172,8 +172,8 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: c
- Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
+ alias: b
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '3') or (key = '8')))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -184,8 +184,8 @@ STAGE PLANS:
                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                  value expressions: val (type: string)
            TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ alias: c
+ Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
              Filter Operator
                predicate: (key is not null and (not ((key = '3') or (key = '8')))) (type: boolean)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedDec 24, '14 at 2:34p
activeDec 24, '14 at 2:34p
posts1
users1
websitehive.apache.org

1 user in discussion

Brock: 1 post

People

Translate

site design / logo © 2021 Grokbase