You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/04/03 23:40:23 UTC

svn commit: r1584410 [6/6] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/conf/ conf/ ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out Thu Apr  3 21:40:21 2014
@@ -75,8 +75,9 @@ INSERT OVERWRITE TABLE dest_j1 SELECT sr
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-0
-  Stage-4
+  Stage-5 depends on stages: Stage-1 , consists of Stage-6, Stage-0
+  Stage-6
+  Stage-4 depends on stages: Stage-6
   Stage-0 depends on stages: Stage-4
   Stage-2 depends on stages: Stage-0
 
@@ -128,6 +129,23 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        1 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {0_VALUE_0}
+                1 {1_VALUE_0}
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -154,13 +172,6 @@ STAGE PLANS:
                       name: default.dest_j1
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            1 
-              TableScan
 
   Stage: Stage-0
     Move Operator
@@ -537,8 +548,9 @@ POSTHOOK: Lineage: dest_j1.key EXPRESSIO
 POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-2
-  Stage-4
+  Stage-5 depends on stages: Stage-1 , consists of Stage-6, Stage-2
+  Stage-6
+  Stage-4 depends on stages: Stage-6
   Stage-2 depends on stages: Stage-4
   Stage-0 is a root stage
 
@@ -600,6 +612,23 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        1 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 {1_VALUE_0} {1_VALUE_1}
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -629,13 +658,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            1 
-              TableScan
 
   Stage: Stage-2
     Map Reduce
@@ -706,8 +728,9 @@ POSTHOOK: Lineage: dest_j1.key EXPRESSIO
 POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-2
-  Stage-4
+  Stage-5 depends on stages: Stage-1 , consists of Stage-6, Stage-2
+  Stage-6
+  Stage-4 depends on stages: Stage-6
   Stage-2 depends on stages: Stage-4
   Stage-0 is a root stage
 
@@ -769,6 +792,23 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        1 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 
+                1 {1_VALUE_0} {1_VALUE_1}
+              keys:
+                0 joinkey0 (type: string), joinkey1 (type: double)
+                1 joinkey0 (type: string), joinkey1 (type: double)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -798,13 +838,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            1 
-              TableScan
 
   Stage: Stage-2
     Map Reduce
@@ -883,10 +916,12 @@ POSTHOOK: Lineage: dest_j1.key EXPRESSIO
 POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-7 depends on stages: Stage-1 , consists of Stage-5, Stage-6, Stage-2
-  Stage-5
+  Stage-7 depends on stages: Stage-1 , consists of Stage-8, Stage-9, Stage-2
+  Stage-8
+  Stage-5 depends on stages: Stage-8
   Stage-2 depends on stages: Stage-5, Stage-6
-  Stage-6
+  Stage-9
+  Stage-6 depends on stages: Stage-9
   Stage-0 is a root stage
 
 STAGE PLANS:
@@ -971,6 +1006,39 @@ STAGE PLANS:
   Stage: Stage-7
     Conditional Operator
 
+  Stage: Stage-8
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        1 
+          Fetch Operator
+            limit: -1
+        2 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {0_VALUE_0}
+                1 {1_VALUE_0}
+                2 
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+                2 joinkey0 (type: string)
+        2 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {0_VALUE_0}
+                1 {1_VALUE_0}
+                2 
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+                2 joinkey0 (type: string)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -1003,18 +1071,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            1 
-              Fetch Operator
-                limit: -1
-            2 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            1 
-              TableScan
-            2 
-              TableScan
 
   Stage: Stage-2
     Map Reduce
@@ -1042,6 +1098,39 @@ 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:
+        0 
+          Fetch Operator
+            limit: -1
+        2 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        0 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {0_VALUE_0}
+                1 {1_VALUE_0}
+                2 
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+                2 joinkey0 (type: string)
+        2 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {0_VALUE_0}
+                1 {1_VALUE_0}
+                2 
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+                2 joinkey0 (type: string)
+
   Stage: Stage-6
     Map Reduce
       Map Operator Tree:
@@ -1074,18 +1163,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            0 
-              Fetch Operator
-                limit: -1
-            2 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            0 
-              TableScan
-            2 
-              TableScan
 
   Stage: Stage-0
     Fetch Operator
@@ -1127,10 +1204,30 @@ POSTHOOK: type: QUERY
 POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
+  Stage-3 is a root stage
+  Stage-1 depends on stages: Stage-3
   Stage-0 is a root stage
 
 STAGE PLANS:
+  Stage: Stage-3
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        v 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        v 
+          TableScan
+            alias: v
+            Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+            HashTable Sink Operator
+              condition expressions:
+                0 {key}
+                1 {val}
+              keys:
+                0 (key + 1) (type: double)
+                1 UDFToDouble(key) (type: double)
+
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
@@ -1163,15 +1260,6 @@ STAGE PLANS:
                     value expressions: _col0 (type: bigint), _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            v 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            v 
-              TableScan
-                alias: v
-                Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
       Reduce Operator Tree:
         Group By Operator
           aggregations: sum(VALUE._col0), sum(VALUE._col1)

Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out Thu Apr  3 21:40:21 2014
@@ -6,8 +6,9 @@ create table noskew as select a.* from s
 POSTHOOK: type: CREATETABLE_AS_SELECT
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-6 depends on stages: Stage-1 , consists of Stage-5, Stage-2
-  Stage-5
+  Stage-6 depends on stages: Stage-1 , consists of Stage-7, Stage-2
+  Stage-7
+  Stage-5 depends on stages: Stage-7
   Stage-2 depends on stages: Stage-5
   Stage-0 depends on stages: Stage-2
   Stage-8 depends on stages: Stage-0
@@ -58,6 +59,23 @@ STAGE PLANS:
   Stage: Stage-6
     Conditional Operator
 
+  Stage: Stage-7
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        1 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        1 
+          TableScan
+            HashTable Sink Operator
+              condition expressions:
+                0 {0_VALUE_0} {0_VALUE_1}
+                1 
+              keys:
+                0 joinkey0 (type: string)
+                1 joinkey0 (type: string)
+
   Stage: Stage-5
     Map Reduce
       Map Operator Tree:
@@ -83,13 +101,6 @@ STAGE PLANS:
                       serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            1 
-              TableScan
 
   Stage: Stage-2
     Map Reduce

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

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

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

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

Modified: hive/trunk/ql/src/test/results/clientpositive/stats11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats11.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats11.q.out Thu Apr  3 21:40:21 2014
@@ -358,7 +358,8 @@ TOK_QUERY
 
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
+  Stage-9 is a root stage
+  Stage-1 depends on stages: Stage-9
   Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
   Stage-5
   Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
@@ -368,6 +369,80 @@ STAGE DEPENDENCIES:
   Stage-7 depends on stages: Stage-6
 
 STAGE PLANS:
+  Stage: Stage-9
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        b 
+          Fetch Operator
+            limit: -1
+            Partition Description:
+                Partition
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  partition values:
+                    ds 2008-04-08
+                  properties:
+                    COLUMN_STATS_ACCURATE true
+                    bucket_count 4
+                    bucket_field_name key
+                    columns key,value
+                    columns.comments 
+                    columns.types int:string
+#### A masked pattern was here ####
+                    name default.srcbucket_mapjoin_part
+                    numFiles 4
+                    numRows 0
+                    partition_columns ds
+                    partition_columns.types string
+                    rawDataSize 0
+                    serialization.ddl struct srcbucket_mapjoin_part { i32 key, string value}
+                    serialization.format 1
+                    serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                    totalSize 5812
+#### A masked pattern was here ####
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                    properties:
+                      bucket_count 4
+                      bucket_field_name key
+                      columns key,value
+                      columns.comments 
+                      columns.types int:string
+#### A masked pattern was here ####
+                      name default.srcbucket_mapjoin_part
+                      partition_columns ds
+                      partition_columns.types string
+                      serialization.ddl struct srcbucket_mapjoin_part { i32 key, string value}
+                      serialization.format 1
+                      serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+#### A masked pattern was here ####
+                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                    name: default.srcbucket_mapjoin_part
+                  name: default.srcbucket_mapjoin_part
+      Alias -> Map Local Operator Tree:
+        b 
+          TableScan
+            alias: b
+            Statistics: Num rows: 55 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            GatherStats: false
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 {value}
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+              Position of Big Table: 0
+      Bucket Mapjoin Context:
+          Alias Bucket Base File Name Mapping:
+            b {srcbucket20.txt=[ds=2008-04-08/srcbucket20.txt, ds=2008-04-08/srcbucket22.txt], srcbucket21.txt=[ds=2008-04-08/srcbucket21.txt, ds=2008-04-08/srcbucket23.txt]}
+          Alias Bucket File Name Mapping:
+#### A masked pattern was here ####
+          Alias Bucket Output File Name Mapping:
+#### A masked pattern was here ####
+
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
@@ -420,69 +495,6 @@ STAGE PLANS:
                   MultiFileSpray: false
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            b 
-              Fetch Operator
-                limit: -1
-                Partition Description:
-                    Partition
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      partition values:
-                        ds 2008-04-08
-                      properties:
-                        COLUMN_STATS_ACCURATE true
-                        bucket_count 4
-                        bucket_field_name key
-                        columns key,value
-                        columns.comments 
-                        columns.types int:string
-#### A masked pattern was here ####
-                        name default.srcbucket_mapjoin_part
-                        numFiles 4
-                        numRows 0
-                        partition_columns ds
-                        partition_columns.types string
-                        rawDataSize 0
-                        serialization.ddl struct srcbucket_mapjoin_part { i32 key, string value}
-                        serialization.format 1
-                        serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-                        totalSize 5812
-#### A masked pattern was here ####
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-                    
-                        input format: org.apache.hadoop.mapred.TextInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                        properties:
-                          bucket_count 4
-                          bucket_field_name key
-                          columns key,value
-                          columns.comments 
-                          columns.types int:string
-#### A masked pattern was here ####
-                          name default.srcbucket_mapjoin_part
-                          partition_columns ds
-                          partition_columns.types string
-                          serialization.ddl struct srcbucket_mapjoin_part { i32 key, string value}
-                          serialization.format 1
-                          serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-#### A masked pattern was here ####
-                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-                        name: default.srcbucket_mapjoin_part
-                      name: default.srcbucket_mapjoin_part
-          Alias -> Map Local Operator Tree:
-            b 
-              TableScan
-                alias: b
-                Statistics: Num rows: 55 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-                GatherStats: false
-          Bucket Mapjoin Context:
-              Alias Bucket Base File Name Mapping:
-                b {srcbucket20.txt=[ds=2008-04-08/srcbucket20.txt, ds=2008-04-08/srcbucket22.txt], srcbucket21.txt=[ds=2008-04-08/srcbucket21.txt, ds=2008-04-08/srcbucket23.txt]}
-              Alias Bucket File Name Mapping:
-#### A masked pattern was here ####
-              Alias Bucket Output File Name Mapping:
-#### A masked pattern was here ####
       Path -> Alias:
 #### A masked pattern was here ####
       Path -> Partition:
@@ -939,7 +951,8 @@ TOK_QUERY
 
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
+  Stage-9 is a root stage
+  Stage-1 depends on stages: Stage-9
   Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
   Stage-4
   Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
@@ -949,6 +962,34 @@ STAGE DEPENDENCIES:
   Stage-6 depends on stages: Stage-5
 
 STAGE PLANS:
+  Stage: Stage-9
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        a 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        a 
+          TableScan
+            alias: a
+            Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+            GatherStats: false
+            HashTable Sink Operator
+              condition expressions:
+                0 {key} {value}
+                1 {value}
+              keys:
+                0 key (type: int)
+                1 key (type: int)
+              Position of Big Table: 1
+      Bucket Mapjoin Context:
+          Alias Bucket Base File Name Mapping:
+            a {ds=2008-04-08/srcbucket20.txt=[srcbucket20.txt], ds=2008-04-08/srcbucket21.txt=[srcbucket21.txt], ds=2008-04-08/srcbucket22.txt=[srcbucket20.txt], ds=2008-04-08/srcbucket23.txt=[srcbucket21.txt]}
+          Alias Bucket File Name Mapping:
+#### A masked pattern was here ####
+          Alias Bucket Output File Name Mapping:
+#### A masked pattern was here ####
+
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
@@ -1006,23 +1047,6 @@ STAGE PLANS:
                   MultiFileSpray: false
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            a 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            a 
-              TableScan
-                alias: a
-                Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
-                GatherStats: false
-          Bucket Mapjoin Context:
-              Alias Bucket Base File Name Mapping:
-                a {ds=2008-04-08/srcbucket20.txt=[srcbucket20.txt], ds=2008-04-08/srcbucket21.txt=[srcbucket21.txt], ds=2008-04-08/srcbucket22.txt=[srcbucket20.txt], ds=2008-04-08/srcbucket23.txt=[srcbucket21.txt]}
-              Alias Bucket File Name Mapping:
-#### A masked pattern was here ####
-              Alias Bucket Output File Name Mapping:
-#### A masked pattern was here ####
       Path -> Alias:
 #### A masked pattern was here ####
       Path -> Partition:

Modified: hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out Thu Apr  3 21:40:21 2014
@@ -4,8 +4,9 @@ POSTHOOK: query: explain select src.key 
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-2
-  Stage-4 has a backup stage: Stage-2
+  Stage-5 depends on stages: Stage-1 , consists of Stage-6, Stage-2
+  Stage-6 has a backup stage: Stage-2
+  Stage-4 depends on stages: Stage-6
   Stage-2
   Stage-0 is a root stage
 
@@ -55,6 +56,23 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    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 {key}
+                1 
+              keys:
+                0 key (type: string)
+                1 _col0 (type: string)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -83,13 +101,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME 
-              TableScan
 
   Stage: Stage-2
     Map Reduce

Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out Thu Apr  3 21:40:21 2014
@@ -820,8 +820,9 @@ having count(*) in (select count(*) from
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
   Stage-5 is a root stage
-  Stage-7 depends on stages: Stage-2, Stage-5 , consists of Stage-6, Stage-3
-  Stage-6 has a backup stage: Stage-3
+  Stage-7 depends on stages: Stage-2, Stage-5 , consists of Stage-9, Stage-3
+  Stage-9 has a backup stage: Stage-3
+  Stage-6 depends on stages: Stage-9
   Stage-3
   Stage-10 is a root stage
   Stage-2 depends on stages: Stage-10
@@ -879,6 +880,23 @@ STAGE PLANS:
   Stage: Stage-7
     Conditional Operator
 
+  Stage: Stage-9
+    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} {_col2}
+                1 
+              keys:
+                0 _col2 (type: bigint)
+                1 _col0 (type: bigint)
+
   Stage: Stage-6
     Map Reduce
       Map Operator Tree:
@@ -906,13 +924,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME1 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME1 
-              TableScan
 
   Stage: Stage-3
     Map Reduce
@@ -1059,8 +1070,9 @@ having p_name in 
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-5 depends on stages: Stage-1, Stage-3 , consists of Stage-4, Stage-2
-  Stage-4 has a backup stage: Stage-2
+  Stage-5 depends on stages: Stage-1, Stage-3 , consists of Stage-6, Stage-2
+  Stage-6 has a backup stage: Stage-2
+  Stage-4 depends on stages: Stage-6
   Stage-2
   Stage-3 is a root stage
   Stage-0 is a root stage
@@ -1102,6 +1114,23 @@ STAGE PLANS:
   Stage: Stage-5
     Conditional Operator
 
+  Stage: Stage-6
+    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} {_col2}
+                1 
+              keys:
+                0 _col1 (type: string)
+                1 _col0 (type: string)
+
   Stage: Stage-4
     Map Reduce
       Map Operator Tree:
@@ -1129,13 +1158,6 @@ STAGE PLANS:
                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Local Work:
         Map Reduce Local Work
-          Alias -> Map Local Tables:
-            $INTNAME 
-              Fetch Operator
-                limit: -1
-          Alias -> Map Local Operator Tree:
-            $INTNAME 
-              TableScan
 
   Stage: Stage-2
     Map Reduce

Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_multiinsert.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_multiinsert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_multiinsert.q.out Thu Apr  3 21:40:21 2014
@@ -535,8 +535,9 @@ POSTHOOK: Lineage: src_5.key EXPRESSION 
 POSTHOOK: Lineage: src_5.value EXPRESSION [(src)b.FieldSchema(name:value, type:string, comment:default), ]
 STAGE DEPENDENCIES:
   Stage-10 is a root stage
-  Stage-13 depends on stages: Stage-10, Stage-14 , consists of Stage-12, Stage-4
-  Stage-12 has a backup stage: Stage-4
+  Stage-13 depends on stages: Stage-10, Stage-14 , consists of Stage-16, Stage-4
+  Stage-16 has a backup stage: Stage-4
+  Stage-12 depends on stages: Stage-16
   Stage-15 depends on stages: Stage-4, Stage-12
   Stage-6 depends on stages: Stage-15
   Stage-1 depends on stages: Stage-6
@@ -596,6 +597,23 @@ STAGE PLANS:
   Stage: Stage-13
     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 {key} {value}
+                1 
+              keys:
+                0 
+                1 
+
   Stage: Stage-12
     Map Reduce
       Map Operator Tree:
@@ -618,13 +636,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-15
     Map Reduce Local Work
@@ -867,6 +878,7 @@ RUN: Stage-14:MAPRED
 RUN: Stage-0:MOVE
 RUN: Stage-13:CONDITIONAL
 RUN: Stage-3:STATS
+RUN: Stage-16:MAPREDLOCAL
 RUN: Stage-12:MAPRED
 RUN: Stage-15:MAPREDLOCAL
 RUN: Stage-6:MAPRED