You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by he...@apache.org on 2010/10/26 20:28:25 UTC
svn commit: r1027672 [11/13] - in /hadoop/hive/trunk: ./
ql/src/gen-javabean/org/apache/hadoop/hive/ql/plan/api/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/
ql/src/java/org/apache/hadoop/hive/ql/i...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out?rev=1027672&r1=1027671&r2=1027672&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out Tue Oct 26 18:28:23 2010
@@ -6,11 +6,36 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF srcpart) (TOK_TABREF src) (= (. (TOK_TABLE_OR_COL srcpart) value) (. (TOK_TABLE_OR_COL src) value))) (TOK_TABREF src1) (= (. (TOK_TABLE_OR_COL srcpart) key) (. (TOK_TABLE_OR_COL src1) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST src src1))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) key)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
+ Stage-6 is a root stage
+ Stage-1 depends on stages: Stage-6
+ Stage-5 depends on stages: Stage-1
+ Stage-2 depends on stages: Stage-5
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-6
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src
+ TableScan
+ alias: src
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[value]]
+ 1 [Column[value]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -37,37 +62,34 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src
- TableScan
- alias: src
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[value]]
- 1 [Column[value]]
- outputColumnNames: _col0
- Position of Big Table: 0
- 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-5
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src1
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[_col0]]
+ 1 [Column[key]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/amarsri/hive_2010-10-03_23-32-11_193_4494089607373072455/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-17_18-28-58_205_3059857123809567795/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -103,42 +125,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src1
- TableScan
- alias: src1
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- outputColumnNames: _col0
- Position of Big Table: 0
- Select Operator
- expressions:
- expr: _col0
- type: string
- outputColumnNames: _col0
- Select Operator
- expressions:
- expr: _col0
- type: string
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -153,12 +139,37 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF srcpart) (TOK_TABREF src) (= (. (TOK_TABLE_OR_COL srcpart) value) (. (TOK_TABLE_OR_COL src) value))) (TOK_TABREF src1) (= (. (TOK_TABLE_OR_COL srcpart) key) (. (TOK_TABLE_OR_COL src1) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST src src1))) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_GROUPBY (TOK_TABLE_OR_COL ds))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
+ Stage-7 is a root stage
+ Stage-1 depends on stages: Stage-7
+ Stage-6 depends on stages: Stage-1
+ Stage-2 depends on stages: Stage-6
Stage-3 depends on stages: Stage-2
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-7
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src
+ TableScan
+ alias: src
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {ds}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[value]]
+ 1 [Column[value]]
+ outputColumnNames: _col0, _col2
+ Position of Big Table: 0
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -185,37 +196,34 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src
- TableScan
- alias: src
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key} {ds}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[value]]
- 1 [Column[value]]
- outputColumnNames: _col0, _col2
- Position of Big Table: 0
- 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-6
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src1
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col2}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[_col0]]
+ 1 [Column[key]]
+ outputColumnNames: _col2
+ Position of Big Table: 0
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/amarsri/hive_2010-10-03_23-32-11_566_3712502381018295609/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-17_18-28-58_559_4154233080683989694/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -243,37 +251,11 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src1
- TableScan
- alias: src1
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col2}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- outputColumnNames: _col2
- Position of Big Table: 0
- 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-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/amarsri/hive_2010-10-03_23-32-11_566_3712502381018295609/-mr-10003
+ file:/tmp/liyintang/hive_2010-10-17_18-28-58_559_4154233080683989694/-mr-10003
Select Operator
expressions:
expr: _col2
@@ -339,7 +321,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-10-03_23-32-11_744_4150005716053861543/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-17_18-28-58_899_5613342207704467139/-mr-10000
POSTHOOK: query: select /*+MAPJOIN(src, src1) */ count(*) from srcpart join src src on (srcpart.value=src.value) join src src1 on (srcpart.key=src1.key) group by ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -347,6 +329,6 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-10-03_23-32-11_744_4150005716053861543/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-17_18-28-58_899_5613342207704467139/-mr-10000
5308
5308
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out?rev=1027672&r1=1027671&r2=1027672&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out Tue Oct 26 18:28:23 2010
@@ -16,10 +16,64 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src1 x) (TOK_TABREF src y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key) key1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) value1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key) key2) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value) value2)))) subq) (TOK_TABREF srcpart z) (and (and (= (. (TOK_TABLE_OR_COL subq) key1) (. (TOK_TABLE_OR_COL z) key)) (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL z) hr) 11)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST z))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL subq) key1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-4 is a root stage
+ Stage-1 depends on stages: Stage-4
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-4
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ subq:x
+ Fetch Operator
+ limit: -1
+ z
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ subq:x
+ TableScan
+ alias: x
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
+ outputColumnNames: _col0
+ Position of Big Table: 1
+ z
+ TableScan
+ alias: z
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (hr = 11))
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (hr = 11)
+ type: boolean
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0}
+ 1 {value}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[_col0]]
+ 1 [Column[key]]
+ outputColumnNames: _col0, _col5
+ Position of Big Table: 0
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -82,118 +136,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- subq:x
- Fetch Operator
- limit: -1
- z
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- subq:x
- TableScan
- alias: x
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- outputColumnNames: _col0
- Position of Big Table: 1
- Select Operator
- expressions:
- expr: _col0
- type: string
- outputColumnNames: _col0
- Select Operator
- expressions:
- expr: _col0
- type: string
- outputColumnNames: _col0
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col5
- Position of Big Table: 0
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col5
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- z
- TableScan
- alias: z
- Filter Operator
- predicate:
- expr: ((ds = '2008-04-08') and (hr = 11))
- type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Filter Operator
- predicate:
- expr: (hr = 11)
- type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col5
- Position of Big Table: 0
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col5
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -209,7 +151,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-14-14_212_7052833350565905154/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-47_409_128786361280541785/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
FROM
(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2
@@ -219,7 +161,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-14-14_212_7052833350565905154/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-47_409_128786361280541785/-mr-10000
238 val_238
238 val_238
311 val_311
@@ -347,11 +289,65 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src1 x) (TOK_TABREF src y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key) key1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) value1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key) key2) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value) value2)))) subq) (TOK_TABREF srcpart z) (and (and (= (. (TOK_TABLE_OR_COL subq) key1) (. (TOK_TABLE_OR_COL z) key)) (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL z) hr) 11)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST z))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL subq) key1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq) key1)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-5 is a root stage
+ Stage-1 depends on stages: Stage-5
Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-5
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ subq:x
+ Fetch Operator
+ limit: -1
+ z
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ subq:x
+ TableScan
+ alias: x
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
+ outputColumnNames: _col0
+ Position of Big Table: 1
+ z
+ TableScan
+ alias: z
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (hr = 11))
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (hr = 11)
+ type: boolean
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0}
+ 1 {value}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[_col0]]
+ 1 [Column[key]]
+ outputColumnNames: _col0, _col5
+ Position of Big Table: 0
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -400,95 +396,11 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- subq:x
- Fetch Operator
- limit: -1
- z
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- subq:x
- TableScan
- alias: x
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- outputColumnNames: _col0
- Position of Big Table: 1
- Select Operator
- expressions:
- expr: _col0
- type: string
- outputColumnNames: _col0
- Select Operator
- expressions:
- expr: _col0
- type: string
- outputColumnNames: _col0
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col5
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- z
- TableScan
- alias: z
- Filter Operator
- predicate:
- expr: ((ds = '2008-04-08') and (hr = 11))
- type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Filter Operator
- predicate:
- expr: (hr = 11)
- type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col5
- Position of Big Table: 0
- 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-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-14-18_425_4598079873799409050/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-15_15-04-53_319_3769577272445368796/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -538,7 +450,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-14-18_581_5217007605308966204/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-53_504_7399621961470089400/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
FROM
(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2
@@ -549,7 +461,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-14-18_581_5217007605308966204/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-53_504_7399621961470089400/-mr-10000
128 val_128
128 val_128
128 val_128
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out?rev=1027672&r1=1027671&r2=1027672&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out Tue Oct 26 18:28:23 2010
@@ -14,10 +14,34 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src a) (TOK_TABREF src b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a))) (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL a) value)) TOK_SERDE TOK_RECORDWRITER '/bin/cat' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST tkey tvalue))))))
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:
+ a
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {value}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
+ outputColumnNames: _col0, _col1
+ Position of Big Table: 1
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -63,51 +87,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key} {value}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col1
- Position of Big Table: 1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -120,14 +99,14 @@ FROM src a join src b
on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive_RCFile/build/ql/scratchdir/hive_2010-03-16_18-09-59_313_6684536786654133017/10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-13_781_8569397391886762548/-mr-10000
POSTHOOK: query: SELECT /*+MAPJOIN(a)*/
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive_RCFile/build/ql/scratchdir/hive_2010-03-16_18-09-59_313_6684536786654133017/10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-13_781_8569397391886762548/-mr-10000
238 val_238
238 val_238
86 val_86
@@ -1247,14 +1226,14 @@ FROM src a join src b
on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive_RCFile/build/ql/scratchdir/hive_2010-03-16_18-10-07_522_7541183111575060436/10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-19_149_1815239476955309395/-mr-10000
POSTHOOK: query: SELECT /*+STREAMTABLE(a)*/
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive_RCFile/build/ql/scratchdir/hive_2010-03-16_18-10-07_522_7541183111575060436/10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-19_149_1815239476955309395/-mr-10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out?rev=1027672&r1=1027671&r2=1027672&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out Tue Oct 26 18:28:23 2010
@@ -8,11 +8,11 @@ POSTHOOK: Output: default@t1
PREHOOK: query: select * from t1 sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-30-50_167_4710362643764304912/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-48_453_7580246906147447007/-mr-10000
POSTHOOK: query: select * from t1 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-30-50_167_4710362643764304912/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-48_453_7580246906147447007/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -34,11 +34,11 @@ POSTHOOK: Output: default@t2
PREHOOK: query: select * from t2 sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-30-56_490_1305333221881884322/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-55_870_6093540767773075041/-mr-10000
POSTHOOK: query: select * from t2 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-30-56_490_1305333221881884322/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-55_870_6093540767773075041/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -62,11 +62,11 @@ POSTHOOK: Output: default@t3
PREHOOK: query: select * from t3 sort by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-05_939_5708575653370225816/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-06_872_5514286542584251869/-mr-10000
POSTHOOK: query: select * from t3 sort by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-05_939_5708575653370225816/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-06_872_5514286542584251869/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -97,11 +97,11 @@ POSTHOOK: Output: default@t4
PREHOOK: query: select * from t4
PREHOOK: type: QUERY
PREHOOK: Input: default@t4
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-09_089_5243149004986287422/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_517_8043595902141289587/-mr-10000
POSTHOOK: query: select * from t4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-09_089_5243149004986287422/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_517_8043595902141289587/-mr-10000
PREHOOK: query: explain select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
@@ -185,7 +185,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-09_221_5886345330918235176/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-10_683_6224851131670102704/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -217,12 +217,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-09_324_7400916651438089839/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_800_2513299296698295975/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-09_324_7400916651438089839/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_800_2513299296698295975/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -312,7 +312,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-15_398_6184531515584998832/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-17_836_5547579604305564817/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -344,12 +344,12 @@ PREHOOK: query: select * from t2 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-15_505_8084865171579203366/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-17_952_8107824929568696805/-mr-10000
POSTHOOK: query: select * from t2 a left semi join t1 b on b.key=a.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-15_505_8084865171579203366/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-17_952_8107824929568696805/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -441,7 +441,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-21_590_8928586964867939357/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-25_023_4437489275956384567/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -473,12 +473,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t4
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-21_694_7949704596850731671/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-25_142_359943279087785463/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t4 b on b.key=a.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t4
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-21_694_7949704596850731671/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-25_142_359943279087785463/-mr-10000
PREHOOK: query: explain select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
@@ -568,7 +568,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-27_718_982050412756211456/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-32_006_1648677446700970744/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -596,12 +596,12 @@ PREHOOK: query: select a.value from t1 a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-27_822_1350911842616975350/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-32_125_2593078127467219576/-mr-10000
POSTHOOK: query: select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-27_822_1350911842616975350/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-32_125_2593078127467219576/-mr-10000
val_0
val_0
val_0
@@ -708,7 +708,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-33_923_9214921681958097012/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-40_123_4389202735836518462/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -740,12 +740,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-34_031_5185180184218172844/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-40_243_7850910287841643376/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key = b.key and b.value < "val_10" sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-34_031_5185180184218172844/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-40_243_7850910287841643376/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -841,7 +841,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-40_153_883351923688146736/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-48_323_8119296433999603117/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -869,12 +869,12 @@ PREHOOK: query: select a.value from t1 a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-40_268_6201543529188681953/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-48_445_7415332140514709784/-mr-10000
POSTHOOK: query: select a.value from t1 a left semi join (select key from t3 where key > 5) b on a.key = b.key sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-40_268_6201543529188681953/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-48_445_7415332140514709784/-mr-10000
val_10
val_8
val_9
@@ -980,7 +980,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-46_312_3993050304389236152/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-55-56_537_2903311238836289590/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1008,12 +1008,12 @@ PREHOOK: query: select a.value from t1 a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-46_425_3381490323707009880/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-56_664_5020769161087651831/-mr-10000
POSTHOOK: query: select a.value from t1 a left semi join (select key , value from t2 where key > 5) b on a.key = b.key and b.value <= 'val_20' sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-46_425_3381490323707009880/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-56_664_5020769161087651831/-mr-10000
PREHOOK: query: explain select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
@@ -1110,7 +1110,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-52_549_6755746237152848554/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-04_059_355987900517518175/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1142,12 +1142,12 @@ PREHOOK: query: select * from t2 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-52_659_5464756953472677859/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-04_183_8670610688043673425/-mr-10000
POSTHOOK: query: select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-52_659_5464756953472677859/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-04_183_8670610688043673425/-mr-10000
4 val_2
8 val_4
10 val_5
@@ -1161,11 +1161,47 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_LEFTSEMIJOIN (TOK_TABREF t3 a) (TOK_TABREF t1 b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST b))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-4 is a root stage
+ Stage-1 depends on stages: Stage-4
Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-4
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ b
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ b
+ TableScan
+ alias: b
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ outputColumnNames: key
+ Group By Operator
+ bucketGroup: false
+ keys:
+ expr: key
+ type: int
+ mode: hash
+ outputColumnNames: _col0
+ Common Join Operator
+ condition map:
+ Left Semi Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[_col0]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -1192,49 +1228,11 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- b
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- b
- TableScan
- alias: b
- Select Operator
- expressions:
- expr: key
- type: int
- outputColumnNames: key
- Group By Operator
- bucketGroup: false
- keys:
- expr: key
- type: int
- mode: hash
- outputColumnNames: _col0
- Common Join Operator
- condition map:
- Left Semi Join 0 to 1
- condition expressions:
- 0 {key}
- 1
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[_col0]]
- outputColumnNames: _col0
- Position of Big Table: 0
- 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-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-31-58_752_2377854145526588776/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-12_336_1953660551209643271/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -1272,12 +1270,12 @@ PREHOOK: query: select /*+ mapjoin(b) */
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-58_854_7200265512841921451/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-12_453_4269654069294497779/-mr-10000
POSTHOOK: query: select /*+ mapjoin(b) */ a.key from t3 a left semi join t1 b on a.key = b.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-31-58_854_7200265512841921451/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-12_453_4269654069294497779/-mr-10000
0
0
0
@@ -1380,7 +1378,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-04_643_2338407986226403980/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-19_517_1787680149236807917/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1412,12 +1410,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-04_744_623541634907516161/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-19_645_8738010680958797763/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key = 2*b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-04_744_623541634907516161/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-19_645_8738010680958797763/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1528,7 +1526,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-10_767_3479460229051595720/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-27_826_6825405805902610028/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1565,13 +1563,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-10_884_4563457848546641930/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-27_976_3972434369204782156/-mr-10000
POSTHOOK: query: select * from t1 a join t2 b on a.key = b.key left semi join t3 c on b.key = c.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-10_884_4563457848546641930/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-27_976_3972434369204782156/-mr-10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
@@ -1681,7 +1679,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-18_210_7397281763659818293/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-36_330_6779914873043487516/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1713,12 +1711,12 @@ PREHOOK: query: select * from t3 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-18_313_6529433048035998250/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-36_446_531074999473537299/-mr-10000
POSTHOOK: query: select * from t3 a left semi join t1 b on a.key = b.key and a.value=b.value sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-18_313_6529433048035998250/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-36_446_531074999473537299/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1741,11 +1739,83 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_LEFTSEMIJOIN (TOK_LEFTSEMIJOIN (TOK_TABREF t3 a) (TOK_TABREF t1 b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF t2 c) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST b c))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-5 is a root stage
+ Stage-1 depends on stages: Stage-5
Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-5
+ 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
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ outputColumnNames: key
+ Group By Operator
+ bucketGroup: false
+ keys:
+ expr: key
+ type: int
+ mode: hash
+ outputColumnNames: _col0
+ Common Join Operator
+ condition map:
+ Left Semi Join 0 to 1
+ Left Semi Join 0 to 2
+ condition expressions:
+ 0 {key}
+ 1
+ 2
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[_col0]]
+ 2 [Column[_col0]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
+ c
+ TableScan
+ alias: c
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ outputColumnNames: key
+ Group By Operator
+ bucketGroup: false
+ keys:
+ expr: key
+ type: int
+ mode: hash
+ outputColumnNames: _col0
+ Common Join Operator
+ condition map:
+ Left Semi Join 0 to 1
+ Left Semi Join 0 to 2
+ condition expressions:
+ 0 {key}
+ 1
+ 2
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[_col0]]
+ 2 [Column[_col0]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
+
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
@@ -1775,91 +1845,11 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
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
- Select Operator
- expressions:
- expr: key
- type: int
- outputColumnNames: key
- Group By Operator
- bucketGroup: false
- keys:
- expr: key
- type: int
- mode: hash
- outputColumnNames: _col0
- Common Join Operator
- condition map:
- Left Semi Join 0 to 1
- Left Semi Join 0 to 2
- condition expressions:
- 0 {key}
- 1
- 2
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[_col0]]
- 2 [Column[_col0]]
- outputColumnNames: _col0
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- c
- TableScan
- alias: c
- Select Operator
- expressions:
- expr: key
- type: int
- outputColumnNames: key
- Group By Operator
- bucketGroup: false
- keys:
- expr: key
- type: int
- mode: hash
- outputColumnNames: _col0
- Common Join Operator
- condition map:
- Left Semi Join 0 to 1
- Left Semi Join 0 to 2
- condition expressions:
- 0 {key}
- 1
- 2
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[_col0]]
- 2 [Column[_col0]]
- outputColumnNames: _col0
- Position of Big Table: 0
- 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-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-24_354_7818817395350959657/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-43_461_1825225512272201729/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -1898,13 +1888,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-24_474_1477633509986082418/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-43_597_7730476012893391191/-mr-10000
POSTHOOK: query: select /*+ mapjoin(b, c) */ a.key from t3 a left semi join t1 b on a.key = b.key left semi join t2 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-24_474_1477633509986082418/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-43_597_7730476012893391191/-mr-10000
0
0
0
@@ -2012,7 +2002,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-30_284_6051624992600368837/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-51_193_4971480791101556085/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2041,13 +2031,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-30_400_7335870280927099010/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-51_329_5949380496953796907/-mr-10000
POSTHOOK: query: select a.key from t3 a left outer join t1 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-30_400_7335870280927099010/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-51_329_5949380496953796907/-mr-10000
0
0
0
@@ -2167,7 +2157,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-37_758_3950677286047860567/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-56-59_679_8191924060733337482/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2196,13 +2186,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-37_871_2454366781942838266/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-59_811_3831038390861954254/-mr-10000
POSTHOOK: query: select a.key from t1 a right outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-37_871_2454366781942838266/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-59_811_3831038390861954254/-mr-10000
NULL
NULL
NULL
@@ -2325,7 +2315,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-45_262_5992955238945717538/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-57-08_142_4862659123810822662/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2354,13 +2344,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-45_380_6139341223545736201/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-08_274_1271914331764289510/-mr-10000
POSTHOOK: query: select a.key from t1 a full outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-45_380_6139341223545736201/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-08_274_1271914331764289510/-mr-10000
NULL
NULL
NULL
@@ -2483,7 +2473,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-32-52_808_8193104458011818678/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-57-16_618_1799543107598292752/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2512,13 +2502,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-52_924_3358318124911522745/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-16_749_4595962962752839059/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-32-52_924_3358318124911522745/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-16_749_4595962962752839059/-mr-10000
0
0
0
@@ -2641,7 +2631,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-33-00_334_3947388254240326821/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-57-25_108_1492275708770566570/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2670,13 +2660,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-33-00_450_7944705166831975761/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-25_243_1263591880561616930/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key right outer join t1 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-33-00_450_7944705166831975761/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-25_243_1263591880561616930/-mr-10000
NULL
NULL
NULL
@@ -2801,7 +2791,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-33-07_801_4655936433608376440/-mr-10002
+ file:/tmp/liyintang/hive_2010-10-16_20-57-33_674_2234020911596435252/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2830,13 +2820,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-33-07_917_7933086183001476835/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-33_808_3288750373349451656/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t1 b on a.key = b.key full outer join t2 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-33-07_917_7933086183001476835/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-33_808_3288750373349451656/-mr-10000
NULL
NULL
NULL
@@ -3005,7 +2995,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jsichi/hive_2010-08-26_16-33-15_319_6054233081828350725/-mr-10003
+ file:/tmp/liyintang/hive_2010-10-16_20-57-42_172_571318165223667427/-mr-10003
Reduce Output Operator
key expressions:
expr: _col0
@@ -3034,13 +3024,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-33-15_444_3464952629462504820/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-42_311_595775460689974599/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.value = c.value sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-33-15_444_3464952629462504820/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-42_311_595775460689974599/-mr-10000
0
0
0