Modified: hive/trunk/ql/src/test/results/clientpositive/union6.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union6.q.out?rev=1202405&r1=1202404&r2=1202405&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/union6.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/union6.q.out Tue Nov 15 20:12:54 2011 @@ -26,13 +26,12 @@ ABSTRACT SYNTAX TREE: STAGE DEPENDENCIES: Stage-1 is a root stage - Stage-2 depends on stages: Stage-1, Stage-7 + Stage-2 depends on stages: Stage-1 Stage-6 depends on stages: Stage-2 , consists of Stage-5, Stage-4 Stage-5 Stage-0 depends on stages: Stage-5, Stage-4 Stage-3 depends on stages: Stage-0 Stage-4 - Stage-7 is a root stage STAGE PLANS: Stage: Stage-1 @@ -78,40 +77,50 @@ STAGE PLANS: Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/tmp/sdong/hive_2011-02-10_17-52-46_559_910674796929230613/-mr-10002 - Union - Select Operator - expressions: - expr: _col0 - type: string - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.tmptable - file:/tmp/sdong/hive_2011-02-10_17-52-46_559_910674796929230613/-mr-10004 - Union + file:/tmp/njain/hive_2011-11-11_18-47-53_815_8491202798848345222/-mr-10002 + TableScan + Union + Select Operator + expressions: + expr: _col0 + type: string + expr: _col1 + type: string + outputColumnNames: _col0, _col1 + File Output Operator + compressed: false + GlobalTableId: 1 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.tmptable + null-subquery2:unionsrc-subquery2:s2 + TableScan + alias: s2 Select Operator expressions: - expr: _col0 + expr: key type: string - expr: _col1 + expr: value type: string outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.tmptable + Union + Select Operator + expressions: + expr: _col0 + type: string + expr: _col1 + type: string + outputColumnNames: _col0, _col1 + File Output Operator + compressed: false + GlobalTableId: 1 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.tmptable Stage: Stage-6 Conditional Operator @@ -120,7 +129,7 @@ STAGE PLANS: Move Operator files: hdfs directory: true - destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-52-46_559_910674796929230613/-ext-10000 + destination: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-11-11_18-47-53_815_8491202798848345222/-ext-10000 Stage: Stage-0 Move Operator @@ -138,7 +147,7 @@ STAGE PLANS: Stage: Stage-4 Map Reduce Alias -> Map Operator Tree: - pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-52-46_559_910674796929230613/-ext-10003 + pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-11-11_18-47-53_815_8491202798848345222/-ext-10003 File Output Operator compressed: false GlobalTableId: 0 @@ -148,26 +157,6 @@ STAGE PLANS: serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.tmptable - Stage: Stage-7 - Map Reduce - Alias -> Map Operator Tree: - null-subquery2:unionsrc-subquery2:s2 - TableScan - alias: s2 - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - PREHOOK: query: insert overwrite table tmptable select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 @@ -190,11 +179,11 @@ POSTHOOK: Lineage: tmptable.value EXPRES PREHOOK: query: select * from tmptable x sort by x.key, x.value PREHOOK: type: QUERY PREHOOK: Input: default@tmptable -PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-52-58_699_4520080058177751609/-mr-10000 +PREHOOK: Output: file:/tmp/njain/hive_2011-11-11_18-48-05_864_4380576443171262357/-mr-10000 POSTHOOK: query: select * from tmptable x sort by x.key, x.value POSTHOOK: type: QUERY POSTHOOK: Input: default@tmptable -POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-52-58_699_4520080058177751609/-mr-10000 +POSTHOOK: Output: file:/tmp/njain/hive_2011-11-11_18-48-05_864_4380576443171262357/-mr-10000 POSTHOOK: Lineage: tmptable.key EXPRESSION [(src1)s2.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: tmptable.value EXPRESSION [(src)s1.null, (src1)s2.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/union7.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union7.q.out?rev=1202405&r1=1202404&r2=1202405&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/union7.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/union7.q.out Tue Nov 15 20:12:54 2011 @@ -17,8 +17,7 @@ ABSTRACT SYNTAX TREE: STAGE DEPENDENCIES: Stage-1 is a root stage - Stage-2 depends on stages: Stage-1, Stage-3 - Stage-3 is a root stage + Stage-2 depends on stages: Stage-1 Stage-0 is a root stage STAGE PLANS: @@ -65,62 +64,72 @@ STAGE PLANS: Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/tmp/sdong/hive_2011-02-10_17-53-02_429_1226872131608807757/-mr-10002 - Union - Select Operator - expressions: - expr: _col0 - type: string - outputColumnNames: _col0 - Group By Operator - aggregations: - expr: count(1) - bucketGroup: false - keys: + file:/tmp/njain/hive_2011-11-11_18-48-09_210_8425017124003834085/-mr-10002 + TableScan + Union + Select Operator + expressions: expr: _col0 type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: + outputColumnNames: _col0 + Group By Operator + aggregations: + expr: count(1) + bucketGroup: false + keys: expr: _col0 type: string - tag: -1 - value expressions: - expr: _col1 - type: bigint - file:/tmp/sdong/hive_2011-02-10_17-53-02_429_1226872131608807757/-mr-10003 - Union + mode: hash + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: + expr: _col0 + type: string + tag: -1 + value expressions: + expr: _col1 + type: bigint + null-subquery2:unionsrc-subquery2:s2 + TableScan + alias: s2 Select Operator expressions: - expr: _col0 + expr: key type: string - outputColumnNames: _col0 - Group By Operator - aggregations: - expr: count(1) - bucketGroup: false - keys: - expr: _col0 - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: + expr: value + type: string + outputColumnNames: _col0, _col1 + Union + Select Operator + expressions: expr: _col0 type: string - tag: -1 - value expressions: - expr: _col1 - type: bigint + outputColumnNames: _col0 + Group By Operator + aggregations: + expr: count(1) + bucketGroup: false + keys: + expr: _col0 + type: string + mode: hash + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: + expr: _col0 + type: string + tag: -1 + value expressions: + expr: _col1 + type: bigint Reduce Operator Tree: Group By Operator aggregations: @@ -145,26 +154,6 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - Stage: Stage-3 - Map Reduce - Alias -> Map Operator Tree: - null-subquery2:unionsrc-subquery2:s2 - TableScan - alias: s2 - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - Stage: Stage-0 Fetch Operator limit: -1 @@ -176,14 +165,14 @@ PREHOOK: query: select unionsrc.key, cou PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Input: default@src1 -PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-53-02_548_1106278616475122301/-mr-10000 +PREHOOK: Output: file:/tmp/njain/hive_2011-11-11_18-48-09_302_258460663317337490/-mr-10000 POSTHOOK: query: select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION ALL select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Input: default@src1 -POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-53-02_548_1106278616475122301/-mr-10000 +POSTHOOK: Output: file:/tmp/njain/hive_2011-11-11_18-48-09_302_258460663317337490/-mr-10000 10 128 1 146 1
