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 [26/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/smb_mapjoin_2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out?rev=980659&r1=980658&r2=980659&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_2.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_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-20_114_6729049322478705958/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-02_694_3636391872212461439/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-20_114_6729049322478705958/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-02_694_3636391872212461439/-mr-10000
4 val_4 4 val_4
10 val_10 10 val_10
PREHOOK: query: explain
@@ -136,7 +136,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:
@@ -144,20 +144,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
@@ -176,12 +176,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-22_746_1628423413210127007/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-07_018_7301752522071852777/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-22_746_1628423413210127007/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-07_018_7301752522071852777/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 4 val_4
@@ -217,7 +217,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:
@@ -225,20 +225,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
@@ -257,12 +257,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-25_414_5347137080834424806/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-11_316_7090256510661284902/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a right outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-25_414_5347137080834424806/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-11_316_7090256510661284902/-mr-10000
4 val_4 4 val_4
10 val_10 10 val_10
NULL NULL 17 val_17
@@ -299,7 +299,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:
@@ -307,20 +307,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
@@ -339,12 +339,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-28_070_5426906800620762025/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-15_627_5055331353742537985/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a full outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-28_070_5426906800620762025/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-15_627_5055331353742537985/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 4 val_4
@@ -384,7 +384,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:
@@ -392,20 +392,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
@@ -424,12 +424,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-30_739_59573784104638805/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-20_888_3104242973720820092/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-30_739_59573784104638805/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-20_888_3104242973720820092/-mr-10000
4 val_4 4 val_4
10 val_10 10 val_10
PREHOOK: query: explain
@@ -462,7 +462,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:
@@ -470,20 +470,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
@@ -502,12 +502,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-33_409_6668885682210635497/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-25_305_6648820221031980381/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-33_409_6668885682210635497/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-25_305_6648820221031980381/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 4 val_4
@@ -543,7 +543,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:
@@ -551,20 +551,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
@@ -583,12 +583,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-36_171_6013991795978323279/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-29_574_4161973268171742510/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a right outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-36_171_6013991795978323279/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-29_574_4161973268171742510/-mr-10000
4 val_4 4 val_4
10 val_10 10 val_10
NULL NULL 17 val_17
@@ -625,7 +625,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:
@@ -633,20 +633,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
@@ -665,12 +665,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-38_942_2715973452861735765/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-33_942_7132087148038788477/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a full outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-38_942_2715973452861735765/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-33_942_7132087148038788477/-mr-10000
1 val_1 NULL NULL
3 val_3 NULL NULL
4 val_4 4 val_4
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out?rev=980659&r1=980658&r2=980659&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_3.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_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-42_230_3901951310502370670/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-40_508_4960774771566994787/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-42_230_3901951310502370670/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-40_508_4960774771566994787/-mr-10000
20 val_20 20 val_20
23 val_23 23 val_23
PREHOOK: query: explain
@@ -136,7 +136,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:
@@ -144,20 +144,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
@@ -176,12 +176,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-44_878_1636786032063672327/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-45_277_5700990852273275881/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-44_878_1636786032063672327/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-45_277_5700990852273275881/-mr-10000
20 val_20 20 val_20
23 val_23 23 val_23
25 val_25 NULL NULL
@@ -216,7 +216,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:
@@ -224,20 +224,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
@@ -256,12 +256,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-47_542_136511562565391235/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-49_340_7691095813207554920/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-47_542_136511562565391235/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-49_340_7691095813207554920/-mr-10000
NULL NULL 4 val_4
NULL NULL 10 val_10
NULL NULL 17 val_17
@@ -298,7 +298,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:
@@ -306,20 +306,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
@@ -338,12 +338,12 @@ PREHOOK: query: select /*+mapjoin(a)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-50_137_5584442750772813211/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-53_191_8130624523560369131/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-50_137_5584442750772813211/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-53_191_8130624523560369131/-mr-10000
NULL NULL 4 val_4
NULL NULL 10 val_10
NULL NULL 17 val_17
@@ -382,7 +382,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:
@@ -390,20 +390,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
@@ -422,12 +422,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-52_734_8865231468690927845/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-57_456_6504839502595322531/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-52_734_8865231468690927845/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-45-57_456_6504839502595322531/-mr-10000
20 val_20 20 val_20
23 val_23 23 val_23
PREHOOK: query: explain
@@ -460,7 +460,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:
@@ -468,20 +468,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
@@ -500,12 +500,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-55_437_3419031084272250181/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-01_597_2602358804194838555/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-55_437_3419031084272250181/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-01_597_2602358804194838555/-mr-10000
20 val_20 20 val_20
23 val_23 23 val_23
25 val_25 NULL NULL
@@ -540,7 +540,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:
@@ -548,20 +548,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
@@ -580,12 +580,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-58_113_8843462871528159229/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-05_884_8956877303331909974/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-59-58_113_8843462871528159229/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-05_884_8956877303331909974/-mr-10000
NULL NULL 4 val_4
NULL NULL 10 val_10
NULL NULL 17 val_17
@@ -622,7 +622,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:
@@ -630,20 +630,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
@@ -662,12 +662,12 @@ PREHOOK: query: select /*+mapjoin(b)*/ *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-00_903_4320870631966344212/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-10_056_3171406730646207661/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-00_903_4320870631966344212/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-10_056_3171406730646207661/-mr-10000
NULL NULL 4 val_4
NULL NULL 10 val_10
NULL NULL 17 val_17
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_4.q.out?rev=980659&r1=980658&r2=980659&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_4.q.out Fri Jul 30 06:40:04 2010
@@ -61,7 +61,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -69,29 +69,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -110,13 +110,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-04_369_6894437003845124922/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-16_409_5138180854708940810/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-04_369_6894437003845124922/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-16_409_5138180854708940810/-mr-10000
PREHOOK: query: explain
select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
PREHOOK: type: QUERY
@@ -150,7 +150,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -158,29 +158,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -199,13 +199,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-07_477_1024337567507880023/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-21_597_3057219238806085881/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-07_477_1024337567507880023/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-21_597_3057219238806085881/-mr-10000
PREHOOK: query: explain
select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
PREHOOK: type: QUERY
@@ -239,7 +239,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -247,29 +247,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -288,13 +288,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-10_477_2598270851351649787/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-29_753_1380615669511069311/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-10_477_2598270851351649787/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-29_753_1380615669511069311/-mr-10000
1 val_1 NULL NULL NULL NULL
3 val_3 NULL NULL NULL NULL
4 val_4 NULL NULL NULL NULL
@@ -333,7 +333,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -341,29 +341,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -382,13 +382,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-13_272_3162263331814942921/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-35_571_1378309731459967102/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-13_272_3162263331814942921/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-35_571_1378309731459967102/-mr-10000
NULL NULL NULL NULL 4 val_4
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 17 val_17
@@ -428,7 +428,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -436,29 +436,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -477,13 +477,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-15_985_2079439490852572040/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-41_533_2015841460506976627/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-15_985_2079439490852572040/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-41_533_2015841460506976627/-mr-10000
1 val_1 NULL NULL NULL NULL
3 val_3 NULL NULL NULL NULL
4 val_4 NULL NULL NULL NULL
@@ -528,7 +528,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -536,29 +536,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -577,13 +577,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-18_694_6706221629562778220/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-46_768_5503417338251350024/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-18_694_6706221629562778220/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-46_768_5503417338251350024/-mr-10000
NULL NULL 20 val_20 20 val_20
NULL NULL 23 val_23 23 val_23
PREHOOK: query: explain
@@ -619,7 +619,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -627,29 +627,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -668,13 +668,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-21_507_7272100397679559384/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-51_754_1468604868878284906/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-21_507_7272100397679559384/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-51_754_1468604868878284906/-mr-10000
NULL NULL 20 val_20 20 val_20
NULL NULL 23 val_23 23 val_23
NULL NULL 25 val_25 NULL NULL
@@ -712,7 +712,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -720,29 +720,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -761,13 +761,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-24_251_4640595451549814065/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-57_851_8735805432799020968/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-24_251_4640595451549814065/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-46-57_851_8735805432799020968/-mr-10000
NULL NULL NULL NULL 4 val_4
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 17 val_17
@@ -807,7 +807,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -815,29 +815,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -856,13 +856,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-27_092_4533249428280289957/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-02_882_8778606981409240289/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-27_092_4533249428280289957/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-02_882_8778606981409240289/-mr-10000
NULL NULL NULL NULL 4 val_4
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 17 val_17
@@ -904,7 +904,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -912,29 +912,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -953,13 +953,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-29_832_2145197883545130418/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-07_985_4686365613476850781/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-29_832_2145197883545130418/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-07_985_4686365613476850781/-mr-10000
NULL NULL 20 val_20 20 val_20
NULL NULL 23 val_23 23 val_23
PREHOOK: query: explain
@@ -995,7 +995,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -1003,29 +1003,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -1044,13 +1044,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-32_567_8429095297894742947/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-13_919_3840473410453589647/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-32_567_8429095297894742947/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-13_919_3840473410453589647/-mr-10000
1 val_1 NULL NULL NULL NULL
3 val_3 NULL NULL NULL NULL
4 val_4 NULL NULL NULL NULL
@@ -1093,7 +1093,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -1101,29 +1101,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -1142,13 +1142,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-35_425_7494156323664202716/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-19_875_2707544952287739378/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-35_425_7494156323664202716/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-19_875_2707544952287739378/-mr-10000
NULL NULL NULL NULL 4 val_4
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 17 val_17
@@ -1188,7 +1188,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Position of Big Table: 2
Select Operator
expressions:
@@ -1196,29 +1196,29 @@ STAGE PLANS:
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: _col2
- type: int
- expr: _col3
- type: string
expr: _col4
type: int
expr: _col5
type: string
+ expr: _col8
+ type: int
+ expr: _col9
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
File Output Operator
compressed: false
@@ -1237,13 +1237,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@smb_bucket_2
PREHOOK: Input: default@smb_bucket_3
PREHOOK: Input: default@smb_bucket_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-38_154_5107590626190601504/10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-29_028_7569403133068144512/-mr-10000
POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_bucket_2
POSTHOOK: Input: default@smb_bucket_3
POSTHOOK: Input: default@smb_bucket_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-00-38_154_5107590626190601504/10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-47-29_028_7569403133068144512/-mr-10000
1 val_1 NULL NULL NULL NULL
3 val_3 NULL NULL NULL NULL
4 val_4 NULL NULL NULL NULL