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
