You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jv...@apache.org on 2010/07/30 08:40:11 UTC
svn commit: r980659 [25/34] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/common/
contrib/src/test/results/clientpositive/ metastore/if/ metastore/src/gen-cpp/
metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/ metast...
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=980659&r1=980658&r2=980659&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 Fri Jul 30 06:40:04 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/jssarma/hive_2010-07-21_11-51-35_256_7415221356692960639/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-31-56_945_3977812479935651025/-mr-10000
POSTHOOK: query: select * from t1 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-51-35_256_7415221356692960639/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-31-56_945_3977812479935651025/-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/jssarma/hive_2010-07-21_11-51-40_528_939202288577935919/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-07_980_8279539228492626989/-mr-10000
POSTHOOK: query: select * from t2 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-51-40_528_939202288577935919/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-07_980_8279539228492626989/-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/jssarma/hive_2010-07-21_11-51-47_912_8068355266970079632/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-20_567_3140026584812908154/-mr-10000
POSTHOOK: query: select * from t3 sort by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-51-47_912_8068355266970079632/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-20_567_3140026584812908154/-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/jssarma/hive_2010-07-21_11-51-50_455_801375301191193749/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-25_015_2952548280591215309/-mr-10000
POSTHOOK: query: select * from t4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-51-50_455_801375301191193749/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-25_015_2952548280591215309/-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/jssarma/hive_2010-07-21_11-51-50_501_2275832402557448214/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-25_103_1392993488798067716/-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@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-51-50_588_8376275316100037063/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-25_507_672234473019697329/-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@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-51-50_588_8376275316100037063/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-25_507_672234473019697329/-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/jssarma/hive_2010-07-21_11-51-55_574_539988252801347645/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-33_848_7018221642451774467/-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/jssarma/hive_2010-07-21_11-51-55_663_6493556599812017880/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-34_004_7788048860411280876/-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/jssarma/hive_2010-07-21_11-51-55_663_6493556599812017880/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-34_004_7788048860411280876/-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/jssarma/hive_2010-07-21_11-52-00_731_4688799125623187788/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-42_102_7156671426907165640/-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@t4
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-00_821_8531941471423951343/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-42_218_8723575608296194278/-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@t4
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-00_821_8531941471423951343/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-42_218_8723575608296194278/-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/jssarma/hive_2010-07-21_11-52-05_850_5295438124379472928/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-51_096_4623214549063353202/-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@t3
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-05_940_1477925378025144213/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-51_185_4682423418266607663/-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@t3
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-05_940_1477925378025144213/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-32-51_185_4682423418266607663/-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/jssarma/hive_2010-07-21_11-52-11_016_6870613802522541542/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-00_658_3638135161738749845/-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@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-11_129_6383903554820825954/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-00_763_6634156825342170288/-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@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-11_129_6383903554820825954/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-00_763_6634156825342170288/-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/jssarma/hive_2010-07-21_11-52-16_235_779399372058035213/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-10_417_7578367697020753062/-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/jssarma/hive_2010-07-21_11-52-16_329_2275706273437432925/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-10_537_4948371486177162830/-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/jssarma/hive_2010-07-21_11-52-16_329_2275706273437432925/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-10_537_4948371486177162830/-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/jssarma/hive_2010-07-21_11-52-21_457_1331498307427022235/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-20_289_4234953905040662046/-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@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-21_555_5905902383917612228/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-20_404_9054226561644712354/-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@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-21_555_5905902383917612228/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-20_404_9054226561644712354/-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/jssarma/hive_2010-07-21_11-52-26_723_1440922755946250273/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-29_819_4830332805438806811/-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/jssarma/hive_2010-07-21_11-52-26_818_30173046506810770/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-29_962_4637203536100177562/-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/jssarma/hive_2010-07-21_11-52-26_818_30173046506810770/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-29_962_4637203536100177562/-mr-10000
4 val_2
8 val_4
10 val_5
@@ -1234,7 +1234,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-52-32_078_2679043381204546775/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-39_814_3237757741903688182/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -1272,12 +1272,12 @@ PREHOOK: query: select /*+ mapjoin(b) */
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-32_166_7467327752440689603/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-39_949_3832492951103179833/-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/jssarma/hive_2010-07-21_11-52-32_166_7467327752440689603/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-39_949_3832492951103179833/-mr-10000
0
0
0
@@ -1380,7 +1380,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-52-37_167_3913040878592306902/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-47_334_8659909258995059282/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1412,12 +1412,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-37_255_8499123111273265654/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-47_442_5393165062196597981/-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@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-37_255_8499123111273265654/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-33-47_442_5393165062196597981/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1506,16 +1506,16 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
2
handleSkewJoin: false
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -1528,7 +1528,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-52-42_392_8203492842374000703/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-00_532_862914177595416183/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1565,13 +1565,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-42_498_7477642768461117554/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-00_669_2146718815299380705/-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@t2
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-42_498_7477642768461117554/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-00_669_2146718815299380705/-mr-10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
@@ -1681,7 +1681,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-52-47_638_2312914691946155301/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-10_154_8713164422099440585/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1713,12 +1713,12 @@ PREHOOK: query: select * from t3 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-47_729_1185838697277763263/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-10_285_5690346901938522778/-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/jssarma/hive_2010-07-21_11-52-47_729_1185838697277763263/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-10_285_5690346901938522778/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1859,7 +1859,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-52-53_202_3850672920021608450/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-19_632_5616980801714535288/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -1898,13 +1898,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-53_303_2583889326927676663/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-19_800_5503128702886670226/-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/jssarma/hive_2010-07-21_11-52-53_303_2583889326927676663/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-19_800_5503128702886670226/-mr-10000
0
0
0
@@ -2012,7 +2012,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-52-58_405_4765969463451941200/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-27_599_2523062859748071251/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2041,13 +2041,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-52-58_504_5713820003651410015/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-27_734_280601286647555771/-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/jssarma/hive_2010-07-21_11-52-58_504_5713820003651410015/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-27_734_280601286647555771/-mr-10000
0
0
0
@@ -2167,7 +2167,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-53-03_590_5882424135335798699/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-38_081_8628736863899363243/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2196,13 +2196,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t3
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-03_688_7110160714226284605/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-38_206_6481133578520858234/-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@t3
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-03_688_7110160714226284605/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-38_206_6481133578520858234/-mr-10000
NULL
NULL
NULL
@@ -2325,7 +2325,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-53-08_783_8469421069250274879/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-47_226_8207416263682466389/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2354,13 +2354,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t3
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-08_882_8562747020920066272/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-47_317_2493886120219911769/-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@t3
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-08_882_8562747020920066272/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-47_317_2493886120219911769/-mr-10000
NULL
NULL
NULL
@@ -2483,7 +2483,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-53-14_002_4363333810736619868/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-58_249_8286755896825534965/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2512,13 +2512,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-14_106_6347833426207703036/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-58_371_725595106575971018/-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@t2
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-14_106_6347833426207703036/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-34-58_371_725595106575971018/-mr-10000
0
0
0
@@ -2641,7 +2641,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-53-19_255_649175280232405937/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-09_782_1244256265233886249/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2670,13 +2670,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-19_353_2282659306314528737/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-09_879_5062879341680309052/-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@t2
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-19_353_2282659306314528737/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-09_879_5062879341680309052/-mr-10000
NULL
NULL
NULL
@@ -2801,7 +2801,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-53-24_533_3457531430693293506/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-19_402_5459989887173784573/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2830,13 +2830,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-24_631_7396802807404398252/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-19_511_7936884878847745536/-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/jssarma/hive_2010-07-21_11-53-24_631_7396802807404398252/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-19_511_7936884878847745536/-mr-10000
NULL
NULL
NULL
@@ -3005,7 +3005,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-53-29_673_2449127370572583191/10003
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-29_028_3549801595991009687/-mr-10003
Reduce Output Operator
key expressions:
expr: _col0
@@ -3034,13 +3034,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-29_775_6410083097422203082/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-29_134_5024788535763869568/-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@t2
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-53-29_775_6410083097422203082/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-35-29_134_5024788535763869568/-mr-10000
0
0
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out?rev=980659&r1=980658&r2=980659&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out Fri Jul 30 06:40:04 2010
@@ -34,6 +34,7 @@ case
ceil
ceiling
coalesce
+collect_set
concat
concat_ws
conv
@@ -158,6 +159,7 @@ case
ceil
ceiling
coalesce
+collect_set
concat
concat_ws
conv
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out?rev=980659&r1=980658&r2=980659&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out Fri Jul 30 06:40:04 2010
@@ -102,12 +102,12 @@ STAGE PLANS:
0 {VALUE._col0}
1 {VALUE._col1}
handleSkewJoin: true
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Select Operator
@@ -143,13 +143,13 @@ STAGE PLANS:
keys:
0 [Column[joinkey0]]
1 [Column[joinkey0]]
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Position of Big Table: 0
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Select Operator
@@ -185,13 +185,13 @@ STAGE PLANS:
keys:
0 [Column[joinkey0]]
1 [Column[joinkey0]]
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Position of Big Table: 0
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Select Operator
@@ -236,11 +236,11 @@ POSTHOOK: Lineage: dest_j1.value SIMPLE
PREHOOK: query: SELECT sum(hash(key)), sum(hash(value)) FROM dest_j1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-54-34_773_8974429205684276500/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-37-21_000_2671125070772953479/-mr-10000
POSTHOOK: query: SELECT sum(hash(key)), sum(hash(value)) FROM dest_j1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-54-34_773_8974429205684276500/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-37-21_000_2671125070772953479/-mr-10000
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), ]
278697 101852390308
@@ -349,24 +349,24 @@ STAGE PLANS:
2 {VALUE._col0} {VALUE._col1}
3 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Select Operator
expressions:
expr: _col0
type: string
expr: _col1
type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
expr: _col4
type: string
expr: _col5
type: string
- expr: _col6
+ expr: _col8
+ type: string
+ expr: _col9
type: string
- expr: _col7
+ expr: _col12
+ type: string
+ expr: _col13
type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
File Output Operator
@@ -390,7 +390,7 @@ PREHOOK: Input: default@t4
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-54-58_628_3356378875993632263/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-04_518_2033294341400244571/-mr-10000
POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON b.key = c.key
@@ -400,7 +400,7 @@ POSTHOOK: Input: default@t4
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-54-58_628_3356378875993632263/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-04_518_2033294341400244571/-mr-10000
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), ]
2 12 2 22 2 12 2 12
@@ -509,24 +509,24 @@ STAGE PLANS:
2 {VALUE._col0} {VALUE._col1}
3 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Select Operator
expressions:
expr: _col0
type: string
expr: _col1
type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
expr: _col4
type: string
expr: _col5
type: string
- expr: _col6
+ expr: _col8
+ type: string
+ expr: _col9
+ type: string
+ expr: _col12
type: string
- expr: _col7
+ expr: _col13
type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
File Output Operator
@@ -550,7 +550,7 @@ PREHOOK: Input: default@t4
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-55-01_582_1289945692817010031/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-10_460_3051517674755082937/-mr-10000
POSTHOOK: query: SELECT /*+ STREAMTABLE(a,c) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON b.key = c.key
@@ -560,7 +560,7 @@ POSTHOOK: Input: default@t4
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-55-01_582_1289945692817010031/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-10_460_3051517674755082937/-mr-10000
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), ]
2 12 2 22 2 12 2 12
@@ -622,21 +622,21 @@ STAGE PLANS:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0}
handleSkewJoin: false
- outputColumnNames: _col0, _col1, _col2
+ outputColumnNames: _col0, _col1, _col4
Select Operator
expressions:
expr: _col0
type: string
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: string
- outputColumnNames: _col0, _col1, _col2
+ outputColumnNames: _col0, _col1, _col4
Group By Operator
aggregations:
expr: sum(hash(_col0))
expr: sum(hash(_col1))
- expr: sum(hash(_col2))
+ expr: sum(hash(_col4))
bucketGroup: false
mode: hash
outputColumnNames: _col0, _col1, _col2
@@ -650,7 +650,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-55-04_590_6073131371882078309/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-16_967_5437652130828251791/-mr-10002
Reduce Output Operator
sort order:
tag: -1
@@ -695,12 +695,12 @@ PREHOOK: query: FROM T1 a JOIN src c ON
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-55-04_686_5498328271539894923/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-17_099_1067879277293261019/-mr-10000
POSTHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key SELECT /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-55-04_686_5498328271539894923/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-17_099_1067879277293261019/-mr-10000
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), ]
198 6274 194
@@ -888,7 +888,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-55-10_006_6998240996689349171/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-28_069_4204177388671027934/-mr-10002
Reduce Output Operator
sort order:
tag: -1
@@ -932,7 +932,7 @@ ON (x.key = Y.key)
SELECT sum(hash(Y.key)), sum(hash(Y.value))
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-55-10_210_3789281218627696460/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-28_276_728470981211329651/-mr-10000
POSTHOOK: query: FROM
(SELECT src.* FROM src) x
JOIN
@@ -941,7 +941,7 @@ ON (x.key = Y.key)
SELECT sum(hash(Y.key)), sum(hash(Y.value))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-55-10_210_3789281218627696460/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-38-28_276_728470981211329651/-mr-10000
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), ]
44481300 101852390308
@@ -1139,7 +1139,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-56-24_288_8833007000539087866/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-40-10_039_3701518454064987743/-mr-10002
Reduce Output Operator
sort order:
tag: -1
@@ -1183,7 +1183,7 @@ ON (x.key = Y.key and substring(x.value,
SELECT sum(hash(Y.key)), sum(hash(Y.value))
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-56-24_510_9175473615433048274/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-40-10_305_7566971631583481386/-mr-10000
POSTHOOK: query: FROM
(SELECT src.* FROM src) x
JOIN
@@ -1192,7 +1192,7 @@ ON (x.key = Y.key and substring(x.value,
SELECT sum(hash(Y.key)), sum(hash(Y.value))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-56-24_510_9175473615433048274/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-40-10_305_7566971631583481386/-mr-10000
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), ]
NULL NULL
@@ -1470,7 +1470,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-57-04_081_7395777836875573715/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-41-13_763_5486455246013984944/-mr-10002
Reduce Output Operator
sort order:
tag: -1
@@ -1639,7 +1639,7 @@ JOIN
ON src1.c1 = src3.c5 AND src3.c5 < 80
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-57-04_482_4874015887141984879/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-41-14_138_857225741486464066/-mr-10000
POSTHOOK: query: SELECT sum(hash(src1.c1)), sum(hash(src2.c4))
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
@@ -1651,7 +1651,7 @@ JOIN
ON src1.c1 = src3.c5 AND src3.c5 < 80
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-57-04_482_4874015887141984879/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-41-14_138_857225741486464066/-mr-10000
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), ]
293143 -136853010385
@@ -1688,7 +1688,7 @@ STAGE PLANS:
keys:
0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key], Const int 1()]
1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Position of Big Table: 0
File Output Operator
compressed: false
@@ -1716,7 +1716,7 @@ STAGE PLANS:
keys:
0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key], Const int 1()]
1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Position of Big Table: 0
File Output Operator
compressed: false
@@ -1728,25 +1728,25 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/jssarma/hive_2010-07-21_11-57-50_557_7888570900112459597/10002
+ file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-29_281_5055738049430830069/-mr-10002
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col3
+ outputColumnNames: _col0, _col5
Group By Operator
aggregations:
expr: sum(hash(_col0))
- expr: sum(hash(_col3))
+ expr: sum(hash(_col5))
bucketGroup: false
mode: hash
outputColumnNames: _col0, _col1
@@ -1788,55 +1788,55 @@ STAGE PLANS:
PREHOOK: query: SELECT /*+ mapjoin(v)*/ sum(hash(k.key)), sum(hash(v.val)) FROM T1 k LEFT OUTER JOIN T1 v ON k.key+1=v.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-57-50_652_7524559661828781918/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-29_370_3600297360970542153/-mr-10000
POSTHOOK: query: SELECT /*+ mapjoin(v)*/ sum(hash(k.key)), sum(hash(v.val)) FROM T1 k LEFT OUTER JOIN T1 v ON k.key+1=v.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-57-50_652_7524559661828781918/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-29_370_3600297360970542153/-mr-10000
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), ]
372 6320
PREHOOK: query: select /*+ mapjoin(k)*/ sum(hash(k.key)), sum(hash(v.val)) from T1 k join T1 v on k.key=v.val
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-57-55_680_7454971209844095002/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-36_144_5811855051099731026/-mr-10000
POSTHOOK: query: select /*+ mapjoin(k)*/ sum(hash(k.key)), sum(hash(v.val)) from T1 k join T1 v on k.key=v.val
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-57-55_680_7454971209844095002/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-36_144_5811855051099731026/-mr-10000
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), ]
NULL NULL
PREHOOK: query: select /*+ mapjoin(k)*/ sum(hash(k.key)), sum(hash(v.val)) from T1 k join T1 v on k.key=v.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-00_759_2503525506382756482/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-44_576_282167472451878689/-mr-10000
POSTHOOK: query: select /*+ mapjoin(k)*/ sum(hash(k.key)), sum(hash(v.val)) from T1 k join T1 v on k.key=v.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-00_759_2503525506382756482/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-44_576_282167472451878689/-mr-10000
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), ]
429 12643
PREHOOK: query: select sum(hash(k.key)), sum(hash(v.val)) from T1 k join T1 v on k.key=v.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-05_940_2644358672516865932/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-52_450_3199148070832612430/-mr-10000
POSTHOOK: query: select sum(hash(k.key)), sum(hash(v.val)) from T1 k join T1 v on k.key=v.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-05_940_2644358672516865932/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-42-52_450_3199148070832612430/-mr-10000
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), ]
429 12643
PREHOOK: query: select count(1) from T1 a join T1 b on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-13_601_8769607871191941131/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-04_335_5121628332368349916/-mr-10000
POSTHOOK: query: select count(1) from T1 a join T1 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-13_601_8769607871191941131/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-04_335_5121628332368349916/-mr-10000
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), ]
8
@@ -1844,12 +1844,12 @@ PREHOOK: query: FROM T1 a LEFT OUTER JOI
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-21_418_5101143786482013059/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-16_335_6156730727323887138/-mr-10000
POSTHOOK: query: FROM T1 a LEFT OUTER JOIN T2 c ON c.key+1=a.key SELECT sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-21_418_5101143786482013059/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-16_335_6156730727323887138/-mr-10000
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), ]
317 9462 50
@@ -1857,12 +1857,12 @@ PREHOOK: query: FROM T1 a RIGHT OUTER JO
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-26_607_2103870217105546568/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-25_726_4662996952485642353/-mr-10000
POSTHOOK: query: FROM T1 a RIGHT OUTER JOIN T2 c ON c.key+1=a.key SELECT /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-26_607_2103870217105546568/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-25_726_4662996952485642353/-mr-10000
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), ]
51 1570 318
@@ -1870,12 +1870,12 @@ PREHOOK: query: FROM T1 a FULL OUTER JOI
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-31_727_8374135807047103504/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-35_816_1937851827863127884/-mr-10000
POSTHOOK: query: FROM T1 a FULL OUTER JOIN T2 c ON c.key+1=a.key SELECT /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-31_727_8374135807047103504/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-35_816_1937851827863127884/-mr-10000
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), ]
317 9462 318
@@ -1883,12 +1883,12 @@ PREHOOK: query: SELECT sum(hash(src1.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-36_776_8115766802135436631/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-45_577_4148142258509714415/-mr-10000
POSTHOOK: query: SELECT sum(hash(src1.key)), sum(hash(src1.val)), sum(hash(src2.key)) FROM T1 src1 LEFT OUTER JOIN T2 src2 ON src1.key+1 = src2.key RIGHT OUTER JOIN T2 src3 ON src2.key = src3.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-36_776_8115766802135436631/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-45_577_4148142258509714415/-mr-10000
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), ]
370 11003 377
@@ -1896,23 +1896,23 @@ PREHOOK: query: SELECT sum(hash(src1.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-42_007_1359296702764686796/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-55_040_8769802363049508359/-mr-10000
POSTHOOK: query: SELECT sum(hash(src1.key)), sum(hash(src1.val)), sum(hash(src2.key)) FROM T1 src1 JOIN T2 src2 ON src1.key+1 = src2.key JOIN T2 src3 ON src2.key = src3.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-42_007_1359296702764686796/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-43-55_040_8769802363049508359/-mr-10000
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), ]
370 11003 377
PREHOOK: query: select /*+ mapjoin(v)*/ sum(hash(k.key)), sum(hash(v.val)) from T1 k left outer join T1 v on k.key+1=v.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-52_321_6570425935975725957/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-13_748_8725230467902356167/-mr-10000
POSTHOOK: query: select /*+ mapjoin(v)*/ sum(hash(k.key)), sum(hash(v.val)) from T1 k left outer join T1 v on k.key+1=v.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-52_321_6570425935975725957/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-13_748_8725230467902356167/-mr-10000
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), ]
372 6320
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out?rev=980659&r1=980658&r2=980659&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out Fri Jul 30 06:40:04 2010
@@ -58,7 +58,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 1
Select Operator
expressions:
@@ -66,20 +66,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -98,12 +98,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-58_160_2147647945746405898/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-25_514_1522228888338492810/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-58-58_160_2147647945746405898/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-25_514_1522228888338492810/-mr-10000
PREHOOK: query: explain
select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
PREHOOK: type: QUERY
@@ -134,7 +134,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 1
Select Operator
expressions:
@@ -142,20 +142,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -174,12 +174,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-00_868_8045473741395817195/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-29_836_7003200343993374451/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-00_868_8045473741395817195/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-29_836_7003200343993374451/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 NULL NULL
@@ -215,7 +215,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 1
Select Operator
expressions:
@@ -223,20 +223,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -255,12 +255,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-03_575_2296154727598489186/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-34_164_3075844906078088691/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-03_575_2296154727598489186/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-34_164_3075844906078088691/-mr-10000
NULL NULL 20 val_20
NULL NULL 23 val_23
NULL NULL 25 val_25
@@ -295,7 +295,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 1
Select Operator
expressions:
@@ -303,20 +303,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -335,12 +335,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-06_230_3764138320854595509/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-38_566_6581323232434123318/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-06_230_3764138320854595509/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-38_566_6581323232434123318/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 NULL NULL
@@ -380,7 +380,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
Select Operator
expressions:
@@ -388,20 +388,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -420,12 +420,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-08_885_5981278369954590271/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-43_501_3496508926661952381/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-08_885_5981278369954590271/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-43_501_3496508926661952381/-mr-10000
PREHOOK: query: explain
select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
PREHOOK: type: QUERY
@@ -456,7 +456,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
Select Operator
expressions:
@@ -464,20 +464,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -496,12 +496,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-11_538_4757194244114259808/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-47_669_5185705008991050470/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-11_538_4757194244114259808/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-47_669_5185705008991050470/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 NULL NULL
@@ -537,7 +537,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
Select Operator
expressions:
@@ -545,20 +545,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -577,12 +577,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-14_194_1923984070343940268/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-51_748_7678694225223867435/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-14_194_1923984070343940268/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-51_748_7678694225223867435/-mr-10000
NULL NULL 20 val_20
NULL NULL 23 val_23
NULL NULL 25 val_25
@@ -617,7 +617,7 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
Select Operator
expressions:
@@ -625,20 +625,20 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
@@ -657,12 +657,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-16_789_1314118076102856939/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-56_103_5715275651117467212/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-16_789_1314118076102856939/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-44-56_103_5715275651117467212/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 NULL NULL