hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject 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...
Date Fri, 30 Jul 2010 06:40:11 GMT
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



Mime
View raw message