hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1584410 [2/6] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/conf/ conf/ ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
Date Thu, 03 Apr 2014 21:40:23 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out Thu Apr  3 21:40:21 2014
@@ -45,8 +45,9 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-4 is a root stage , consists of Stage-3, Stage-1
-  Stage-3 has a backup stage: Stage-1
+  Stage-4 is a root stage , consists of Stage-5, Stage-1
+  Stage-5 has a backup stage: Stage-1
+  Stage-3 depends on stages: Stage-5
   Stage-1
   Stage-0 is a root stage
 
@@ -54,6 +55,24 @@ STAGE PLANS:
   Stage: Stage-4
     Conditional Operator
 
+  Stage: Stage-5
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-3
     Map Reduce
       Map Operator Tree:
@@ -78,14 +97,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -154,8 +165,9 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-4 is a root stage , consists of Stage-3, Stage-1
-  Stage-3 has a backup stage: Stage-1
+  Stage-4 is a root stage , consists of Stage-5, Stage-1
+  Stage-5 has a backup stage: Stage-1
+  Stage-3 depends on stages: Stage-5
   Stage-1
   Stage-0 is a root stage
 
@@ -163,6 +175,24 @@ STAGE PLANS:
   Stage: Stage-4
     Conditional Operator
 
+  Stage: Stage-5
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-3
     Map Reduce
       Map Operator Tree:
@@ -187,14 +217,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out Thu Apr  3 21:40:21 2014
@@ -455,11 +455,14 @@ POSTHOOK: Lineage: tbl3.value SIMPLE [(s
 POSTHOOK: Lineage: tbl4.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl4.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-8 is a root stage , consists of Stage-5, Stage-6, Stage-7, Stage-1
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 is a root stage , consists of Stage-9, Stage-10, Stage-11, Stage-1
+  Stage-9 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-9
   Stage-2 depends on stages: Stage-1, Stage-5, Stage-6, Stage-7
-  Stage-6 has a backup stage: Stage-1
-  Stage-7 has a backup stage: Stage-1
+  Stage-10 has a backup stage: Stage-1
+  Stage-6 depends on stages: Stage-10
+  Stage-11 has a backup stage: Stage-1
+  Stage-7 depends on stages: Stage-11
   Stage-1
   Stage-0 is a root stage
 
@@ -467,6 +470,41 @@ STAGE PLANS:
   Stage: Stage-8
     Conditional Operator
 
+  Stage: Stage-9
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+        c 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+        c 
+          TableScan
+            alias: c
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -497,20 +535,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-            c 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
-            c 
-              TableScan
-                alias: c
 
   Stage: Stage-2
     Map Reduce
@@ -538,6 +562,41 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-10
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+        c 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+        c 
+          TableScan
+            alias: c
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+
   Stage: Stage-6
     Map Reduce
       Map Operator Tree:
@@ -568,20 +627,41 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-            c 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-            c 
-              TableScan
-                alias: c
+
+  Stage: Stage-11
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
 
   Stage: Stage-7
     Map Reduce
@@ -613,20 +693,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-            b 
-              TableScan
-                alias: b
 
   Stage: Stage-1
     Map Reduce
@@ -1032,11 +1098,14 @@ POSTHOOK: Lineage: tbl3.value SIMPLE [(s
 POSTHOOK: Lineage: tbl4.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl4.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-8 is a root stage , consists of Stage-5, Stage-6, Stage-7, Stage-1
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 is a root stage , consists of Stage-9, Stage-10, Stage-11, Stage-1
+  Stage-9 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-9
   Stage-2 depends on stages: Stage-1, Stage-5, Stage-6, Stage-7
-  Stage-6 has a backup stage: Stage-1
-  Stage-7 has a backup stage: Stage-1
+  Stage-10 has a backup stage: Stage-1
+  Stage-6 depends on stages: Stage-10
+  Stage-11 has a backup stage: Stage-1
+  Stage-7 depends on stages: Stage-11
   Stage-1
   Stage-0 is a root stage
 
@@ -1044,6 +1113,41 @@ STAGE PLANS:
   Stage: Stage-8
     Conditional Operator
 
+  Stage: Stage-9
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+        c 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+        c 
+          TableScan
+            alias: c
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -1074,20 +1178,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-            c 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
-            c 
-              TableScan
-                alias: c
 
   Stage: Stage-2
     Map Reduce
@@ -1115,6 +1205,41 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-10
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+        c 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+        c 
+          TableScan
+            alias: c
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+
   Stage: Stage-6
     Map Reduce
       Map Operator Tree:
@@ -1145,20 +1270,41 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-            c 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-            c 
-              TableScan
-                alias: c
+
+  Stage: Stage-11
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 UDFToDouble(key) (type: double)
+                1 UDFToDouble(key) (type: double)
+                2 UDFToDouble(key) (type: double)
 
   Stage: Stage-7
     Map Reduce
@@ -1190,20 +1336,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-            b 
-              TableScan
-                alias: b
 
   Stage: Stage-1
     Map Reduce
@@ -1296,10 +1428,13 @@ POSTHOOK: Lineage: tbl3.value SIMPLE [(s
 POSTHOOK: Lineage: tbl4.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl4.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-7 is a root stage , consists of Stage-4, Stage-5, Stage-6, Stage-1
-  Stage-4 has a backup stage: Stage-1
-  Stage-5 has a backup stage: Stage-1
-  Stage-6 has a backup stage: Stage-1
+  Stage-7 is a root stage , consists of Stage-8, Stage-9, Stage-10, Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-8
+  Stage-9 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-9
+  Stage-10 has a backup stage: Stage-1
+  Stage-6 depends on stages: Stage-10
   Stage-1
   Stage-0 is a root stage
 
@@ -1307,6 +1442,41 @@ STAGE PLANS:
   Stage: Stage-7
     Conditional Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+        c 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+                2 key (type: int)
+        c 
+          TableScan
+            alias: c
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+                2 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -1334,20 +1504,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-            c 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
-            c 
-              TableScan
-                alias: c
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -1363,6 +1519,41 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-9
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+        c 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+                2 key (type: int)
+        c 
+          TableScan
+            alias: c
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+                2 key (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -1390,20 +1581,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-            c 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-            c 
-              TableScan
-                alias: c
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -1419,6 +1596,41 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-10
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+                2 key (type: int)
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+                2 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+                2 key (type: int)
+
   Stage: Stage-6
     Map Reduce
       Map Operator Tree:
@@ -1446,20 +1658,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out Thu Apr  3 21:40:21 2014
@@ -426,10 +426,12 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-9 depends on stages: Stage-1, Stage-5 , consists of Stage-7, Stage-8, Stage-3
-  Stage-7 has a backup stage: Stage-3
+  Stage-9 depends on stages: Stage-1, Stage-5 , consists of Stage-10, Stage-11, Stage-3
+  Stage-10 has a backup stage: Stage-3
+  Stage-7 depends on stages: Stage-10
   Stage-4 depends on stages: Stage-3, Stage-7, Stage-8
-  Stage-8 has a backup stage: Stage-3
+  Stage-11 has a backup stage: Stage-3
+  Stage-8 depends on stages: Stage-11
   Stage-3
   Stage-5 is a root stage
   Stage-0 is a root stage
@@ -483,6 +485,23 @@ STAGE PLANS:
   Stage: Stage-9
     Conditional Operator
 
+  Stage: Stage-10
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        $INTNAME1 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        $INTNAME1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {_col0} {_col1}
+                1 {_col1}
+              keys:
+                0 _col0 (type: int)
+                1 _col0 (type: int)
+
   Stage: Stage-7
     Map Reduce
       Map Operator Tree:
@@ -508,13 +527,6 @@ STAGE PLANS:
                       serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME1 
-              TableScan
 
   Stage: Stage-4
     Map Reduce
@@ -533,6 +545,23 @@ STAGE PLANS:
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-11
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        $INTNAME 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        $INTNAME 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {_col0} {_col1}
+                1 {_col1}
+              keys:
+                0 _col0 (type: int)
+                1 _col0 (type: int)
+
   Stage: Stage-8
     Map Reduce
       Map Operator Tree:
@@ -558,13 +587,6 @@ STAGE PLANS:
                       serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME 
-              TableScan
 
   Stage: Stage-3
     Map Reduce
@@ -1724,9 +1746,11 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-5 is a root stage , consists of Stage-3, Stage-4, Stage-1
-  Stage-3 has a backup stage: Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-5 is a root stage , consists of Stage-6, Stage-7, Stage-1
+  Stage-6 has a backup stage: Stage-1
+  Stage-3 depends on stages: Stage-6
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-1
   Stage-0 is a root stage
 
@@ -1734,6 +1758,24 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq1:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq1:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-3
     Map Reduce
       Map Operator Tree:
@@ -1758,14 +1800,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq1:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq1:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -1781,6 +1815,24 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq1:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq1:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -1805,14 +1857,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq1:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq1:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -1914,10 +1958,12 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-2 depends on stages: Stage-1, Stage-4, Stage-5
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
   Stage-0 is a root stage
 
@@ -1925,6 +1971,24 @@ STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq1:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq1:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -1955,14 +2019,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq1:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq1:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -1996,6 +2052,24 @@ STAGE PLANS:
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq1:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq1:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -2026,14 +2100,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq1:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq1:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -2156,10 +2222,12 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-3 depends on stages: Stage-1, Stage-4, Stage-5
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
   Stage-0 is a root stage
 
@@ -2167,6 +2235,24 @@ STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq2:subq1:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq2:subq1:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -2197,14 +2283,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq2:subq1:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq2:subq1:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -2245,6 +2323,24 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq2:subq1:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq2:subq1:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -2275,14 +2371,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq2:subq1:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq2:subq1:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -2426,18 +2514,24 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-12 is a root stage , consists of Stage-10, Stage-11, Stage-1
-  Stage-10 has a backup stage: Stage-1
-  Stage-9 depends on stages: Stage-1, Stage-5, Stage-10, Stage-11, Stage-13, Stage-14 , consists of Stage-7, Stage-8, Stage-3
-  Stage-7 has a backup stage: Stage-3
+  Stage-12 is a root stage , consists of Stage-18, Stage-19, Stage-1
+  Stage-18 has a backup stage: Stage-1
+  Stage-10 depends on stages: Stage-18
+  Stage-9 depends on stages: Stage-1, Stage-5, Stage-10, Stage-11, Stage-13, Stage-14 , consists of Stage-16, Stage-17, Stage-3
+  Stage-16 has a backup stage: Stage-3
+  Stage-7 depends on stages: Stage-16
   Stage-4 depends on stages: Stage-3, Stage-7, Stage-8
-  Stage-8 has a backup stage: Stage-3
+  Stage-17 has a backup stage: Stage-3
+  Stage-8 depends on stages: Stage-17
   Stage-3
-  Stage-11 has a backup stage: Stage-1
+  Stage-19 has a backup stage: Stage-1
+  Stage-11 depends on stages: Stage-19
   Stage-1
-  Stage-15 is a root stage , consists of Stage-13, Stage-14, Stage-5
-  Stage-13 has a backup stage: Stage-5
-  Stage-14 has a backup stage: Stage-5
+  Stage-15 is a root stage , consists of Stage-20, Stage-21, Stage-5
+  Stage-20 has a backup stage: Stage-5
+  Stage-13 depends on stages: Stage-20
+  Stage-21 has a backup stage: Stage-5
+  Stage-14 depends on stages: Stage-21
   Stage-5
   Stage-0 is a root stage
 
@@ -2445,6 +2539,24 @@ STAGE PLANS:
   Stage: Stage-12
     Conditional Operator
 
+  Stage: Stage-18
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        src1:subq1:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        src1:subq1:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-10
     Map Reduce
       Map Operator Tree:
@@ -2475,14 +2587,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            src1:subq1:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            src1:subq1:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -2502,6 +2606,23 @@ STAGE PLANS:
   Stage: Stage-9
     Conditional Operator
 
+  Stage: Stage-16
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        $INTNAME1 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        $INTNAME1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {_col0} {_col1}
+                1 {_col1}
+              keys:
+                0 _col0 (type: int)
+                1 _col0 (type: int)
+
   Stage: Stage-7
     Map Reduce
       Map Operator Tree:
@@ -2527,13 +2648,6 @@ STAGE PLANS:
                       serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME1 
-              TableScan
 
   Stage: Stage-4
     Map Reduce
@@ -2552,6 +2666,23 @@ STAGE PLANS:
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-17
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        $INTNAME 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        $INTNAME 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {_col0} {_col1}
+                1 {_col1}
+              keys:
+                0 _col0 (type: int)
+                1 _col0 (type: int)
+
   Stage: Stage-8
     Map Reduce
       Map Operator Tree:
@@ -2577,13 +2708,6 @@ STAGE PLANS:
                       serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME 
-              TableScan
 
   Stage: Stage-3
     Map Reduce
@@ -2618,6 +2742,24 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
+  Stage: Stage-19
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        src1:subq1:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        src1:subq1:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-11
     Map Reduce
       Map Operator Tree:
@@ -2648,14 +2790,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            src1:subq1:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            src1:subq1:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -2720,6 +2854,24 @@ STAGE PLANS:
   Stage: Stage-15
     Conditional Operator
 
+  Stage: Stage-20
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        src2:subq2:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        src2:subq2:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-13
     Map Reduce
       Map Operator Tree:
@@ -2750,14 +2902,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            src2:subq2:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            src2:subq2:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -2774,6 +2918,24 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
+  Stage: Stage-21
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        src2:subq2:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        src2:subq2:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-14
     Map Reduce
       Map Operator Tree:
@@ -2804,14 +2966,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            src2:subq2:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            src2:subq2:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -3201,8 +3355,9 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-5 is a root stage , consists of Stage-3, Stage-7, Stage-1
-  Stage-3 has a backup stage: Stage-1
+  Stage-5 is a root stage , consists of Stage-6, Stage-7, Stage-1
+  Stage-6 has a backup stage: Stage-1
+  Stage-3 depends on stages: Stage-6
   Stage-7 has a backup stage: Stage-1
   Stage-4 depends on stages: Stage-7
   Stage-1
@@ -3212,6 +3367,24 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 _col0 (type: int)
+                1 key (type: int)
+
   Stage: Stage-3
     Map Reduce
       Map Operator Tree:
@@ -3241,14 +3414,6 @@ STAGE PLANS:
                         value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -3957,8 +4122,9 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-5 is a root stage , consists of Stage-3, Stage-7, Stage-1
-  Stage-3 has a backup stage: Stage-1
+  Stage-5 is a root stage , consists of Stage-6, Stage-7, Stage-1
+  Stage-6 has a backup stage: Stage-1
+  Stage-3 depends on stages: Stage-6
   Stage-7 has a backup stage: Stage-1
   Stage-4 depends on stages: Stage-7
   Stage-1
@@ -3968,6 +4134,24 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 _col0 (type: int)
+                1 key (type: int)
+
   Stage: Stage-3
     Map Reduce
       Map Operator Tree:
@@ -3997,14 +4181,6 @@ STAGE PLANS:
                         value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -4171,10 +4347,11 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-5 is a root stage , consists of Stage-6, Stage-4, Stage-1
+  Stage-5 is a root stage , consists of Stage-6, Stage-7, Stage-1
   Stage-6 has a backup stage: Stage-1
   Stage-3 depends on stages: Stage-6
-  Stage-4 has a backup stage: Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-1
   Stage-0 is a root stage
 
@@ -4244,6 +4421,24 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 key (type: int)
+                1 _col0 (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -4273,14 +4468,6 @@ STAGE PLANS:
                         value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
@@ -4794,8 +4981,9 @@ POSTHOOK: Lineage: tbl1.value SIMPLE [(s
 POSTHOOK: Lineage: tbl2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-5 is a root stage , consists of Stage-3, Stage-7, Stage-1
-  Stage-3 has a backup stage: Stage-1
+  Stage-5 is a root stage , consists of Stage-6, Stage-7, Stage-1
+  Stage-6 has a backup stage: Stage-1
+  Stage-3 depends on stages: Stage-6
   Stage-7 has a backup stage: Stage-1
   Stage-4 depends on stages: Stage-7
   Stage-1
@@ -4805,6 +4993,24 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 
+              keys:
+                0 _col0 (type: int)
+                1 key (type: int)
+
   Stage: Stage-3
     Map Reduce
       Map Operator Tree:
@@ -4834,14 +5040,6 @@ STAGE PLANS:
                         value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)

Modified: hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_1.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_1.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_2.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_1.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_1.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_2.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_3.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_3.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_4.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_4.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_4.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_5.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_5.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_5.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_6.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_6.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_6.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_7.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_7.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_7.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketcontext_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketcontext_8.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketcontext_8.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketcontext_8.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin10.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin10.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin10.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin11.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin11.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin11.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin12.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin12.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin12.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin13.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin13.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin13.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin5.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin5.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin5.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin7.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin7.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin7.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin8.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin8.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin8.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin9.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin9.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin9.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out Thu Apr  3 21:40:21 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out Thu Apr  3 21:40:21 2014
@@ -278,17 +278,37 @@ POSTHOOK: Lineage: test_table2 PARTITION
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key SIMPLE [(test_table1)a.FieldSchema(name:key, type:int, comment:null), ]
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value EXPRESSION [(test_table1)a.FieldSchema(name:value, type:string, comment:null), (test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
   Stage-3 depends on stages: Stage-0
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
 
 STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 {value}
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -314,14 +334,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -347,6 +359,24 @@ STAGE PLANS:
   Stage: Stage-3
     Stats-Aggr Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 {value}
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -372,14 +402,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Extract
           File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out Thu Apr  3 21:40:21 2014
@@ -259,17 +259,37 @@ POSTHOOK: Lineage: test_table3 PARTITION
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key2 SIMPLE [(test_table1)a.FieldSchema(name:key, type:int, comment:null), ]
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value EXPRESSION [(test_table1)a.FieldSchema(name:value, type:string, comment:null), (test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
   Stage-3 depends on stages: Stage-0
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
 
 STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -295,14 +315,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -328,6 +340,24 @@ STAGE PLANS:
   Stage: Stage-3
     Stats-Aggr Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -353,14 +383,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Extract
           File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out Thu Apr  3 21:40:21 2014
@@ -74,17 +74,37 @@ POSTHOOK: Lineage: test_table1 PARTITION
 POSTHOOK: Lineage: test_table2 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: test_table2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
   Stage-3 depends on stages: Stage-0
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
 
 STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 {value}
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -110,14 +130,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -143,6 +155,24 @@ STAGE PLANS:
   Stage: Stage-3
     Stats-Aggr Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 {value}
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -168,14 +198,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Extract
           File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out Thu Apr  3 21:40:21 2014
@@ -427,17 +427,37 @@ POSTHOOK: Lineage: test_table3 PARTITION
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key2 SIMPLE [(test_table1)a.FieldSchema(name:key2, type:int, comment:null), ]
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value EXPRESSION [(test_table1)a.FieldSchema(name:value, type:string, comment:null), (test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
   Stage-3 depends on stages: Stage-0
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
 
 STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {key2} {value}
+                1 {value}
+              keys:
+                0 key (type: int), key2 (type: int)
+                1 key (type: int), key2 (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -463,14 +483,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -496,6 +508,24 @@ STAGE PLANS:
   Stage: Stage-3
     Stats-Aggr Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {key2} {value}
+                1 {value}
+              keys:
+                0 key (type: int), key2 (type: int)
+                1 key (type: int), key2 (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -521,14 +551,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -608,17 +630,37 @@ POSTHOOK: Lineage: test_table3 PARTITION
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key2 SIMPLE [(test_table1)a.FieldSchema(name:key2, type:int, comment:null), ]
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value EXPRESSION [(test_table1)a.FieldSchema(name:value, type:string, comment:null), (test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
   Stage-2 depends on stages: Stage-0
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
 
 STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq1:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq1:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {key2} {value}
+                1 {value}
+              keys:
+                0 key (type: int), key2 (type: int)
+                1 key (type: int), key2 (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -644,14 +686,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq1:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq1:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -677,6 +711,24 @@ STAGE PLANS:
   Stage: Stage-2
     Stats-Aggr Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq1:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq1:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {key2} {value}
+                1 {value}
+              keys:
+                0 key (type: int), key2 (type: int)
+                1 key (type: int), key2 (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -702,14 +754,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq1:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq1:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -1254,17 +1298,37 @@ POSTHOOK: Lineage: test_table3 PARTITION
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key2 SIMPLE [(test_table1)a.FieldSchema(name:key2, type:int, comment:null), ]
 POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value EXPRESSION [(test_table1)a.FieldSchema(name:value, type:string, comment:null), (test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
 STAGE DEPENDENCIES:
-  Stage-6 is a root stage , consists of Stage-4, Stage-5, Stage-1
-  Stage-4 has a backup stage: Stage-1
+  Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
+  Stage-7 has a backup stage: Stage-1
+  Stage-4 depends on stages: Stage-7
   Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
   Stage-3 depends on stages: Stage-0
-  Stage-5 has a backup stage: Stage-1
+  Stage-8 has a backup stage: Stage-1
+  Stage-5 depends on stages: Stage-8
   Stage-1
 
 STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq2:subq1:b 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq2:subq1:b 
+          TableScan
+            alias: b
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {key2} {value}
+                1 {value}
+              keys:
+                0 key (type: int), key2 (type: int)
+                1 key (type: int), key2 (type: int)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -1290,14 +1354,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq2:subq1:b 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq2:subq1:b 
-              TableScan
-                alias: b
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -1323,6 +1379,24 @@ STAGE PLANS:
   Stage: Stage-3
     Stats-Aggr Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        subq2:subq1:a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        subq2:subq1:a 
+          TableScan
+            alias: a
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {key2} {value}
+                1 {value}
+              keys:
+                0 key (type: int), key2 (type: int)
+                1 key (type: int), key2 (type: int)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -1348,14 +1422,6 @@ STAGE PLANS:
                   value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            subq2:subq1:a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            subq2:subq1:a 
-              TableScan
-                alias: a
       Reduce Operator Tree:
         Extract
           File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out Thu Apr  3 21:40:21 2014
@@ -298,11 +298,31 @@ FROM (SELECT x.key AS key, count(1) AS c
       GROUP BY x.key) tmp
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
-  Stage-2 is a root stage
+  Stage-6 is a root stage
+  Stage-2 depends on stages: Stage-6
   Stage-3 depends on stages: Stage-2
   Stage-0 is a root stage
 
 STAGE PLANS:
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        tmp:x 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        tmp:x 
+          TableScan
+            alias: x
+            Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 
+              keys:
+                0 key (type: string)
+                1 key (type: string)
+
   Stage: Stage-2
     Map Reduce
       Map Operator Tree:
@@ -338,15 +358,6 @@ STAGE PLANS:
                     value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            tmp:x 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            tmp:x 
-              TableScan
-                alias: x
-                Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)



Mime
View raw message