You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/08/29 08:53:19 UTC
svn commit: r990499 [17/17] - in /hadoop/hive/trunk: ./
hbase-handler/src/test/results/ ql/src/test/org/apache/hadoop/hive/ql/hooks/
ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out Sun Aug 29 06:53:17 2010
@@ -127,14 +127,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results
POSTHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results
POSTHOOK: Lineage: smb_bucket4_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -147,11 +147,11 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: select * from smb_join_results order by k1
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-10_926_8745628360725409758/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-43-58_355_4241912694869470636/-mr-10000
POSTHOOK: query: select * from smb_join_results order by k1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-10_926_8745628360725409758/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-43-58_355_4241912694869470636/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1190,13 +1190,13 @@ POSTHOOK: Lineage: smb_join_results.v2 S
498 val_498 498 val_498
PREHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@normal_join_results
POSTHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@normal_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -1213,11 +1213,11 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from normal_join_results
PREHOOK: type: QUERY
PREHOOK: Input: default@normal_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-23_089_8916105885194180283/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-07_386_5215362180353440890/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from normal_join_results
POSTHOOK: type: QUERY
POSTHOOK: Input: default@normal_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-23_089_8916105885194180283/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-07_386_5215362180353440890/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.v1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:value, type:string, comment:from deserializer), ]
@@ -1234,11 +1234,11 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-27_271_4277665023453991774/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-10_503_5044933337669213788/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-27_271_4277665023453991774/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-10_503_5044933337669213788/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.v1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:value, type:string, comment:from deserializer), ]
@@ -1343,14 +1343,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(b)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results
POSTHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(b)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -1371,14 +1371,14 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results
POSTHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -1403,11 +1403,11 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: select * from smb_join_results order by k1
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-42_542_6844851430917483539/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-21_789_8349972338199515523/-mr-10000
POSTHOOK: query: select * from smb_join_results order by k1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-42_542_6844851430917483539/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-21_789_8349972338199515523/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.v1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:value, type:string, comment:from deserializer), ]
@@ -2458,13 +2458,13 @@ POSTHOOK: Lineage: smb_join_results.v2 S
498 val_498 498 val_498
PREHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@normal_join_results
POSTHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@normal_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -2493,11 +2493,11 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from normal_join_results
PREHOOK: type: QUERY
PREHOOK: Input: default@normal_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-54_759_7739155121976805350/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-30_839_4771778288932582310/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from normal_join_results
POSTHOOK: type: QUERY
POSTHOOK: Input: default@normal_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-54_759_7739155121976805350/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-30_839_4771778288932582310/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -2526,11 +2526,11 @@ POSTHOOK: Lineage: smb_join_results.v2 S
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-59_435_4638146387519059756/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-33_938_44080156296442227/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-49-59_435_4638146387519059756/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-33_938_44080156296442227/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -2663,14 +2663,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key where a.key>1000
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results
POSTHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key where a.key>1000
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -2815,14 +2815,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(b)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key where a.key>1000
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results
POSTHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(b)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key where a.key>1000
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -2975,14 +2975,14 @@ STAGE PLANS:
PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key join smb_bucket4_2 c on b.key = c.key where a.key>1000
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-50-18_801_6427179719209140669/-mr-10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-46_257_446569303031962295/-mr-10000
POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key join smb_bucket4_2 c on b.key = c.key where a.key>1000
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-50-18_801_6427179719209140669/-mr-10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-44-46_257_446569303031962295/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:from deserializer), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_7.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_7.q.out Sun Aug 29 06:53:17 2010
@@ -48,14 +48,14 @@ POSTHOOK: Lineage: smb_bucket4_2.value S
PREHOOK: query: insert overwrite table smb_join_results_empty_bigtable
select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results_empty_bigtable
POSTHOOK: query: insert overwrite table smb_join_results_empty_bigtable
select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results_empty_bigtable
POSTHOOK: Lineage: smb_bucket4_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -66,14 +66,14 @@ POSTHOOK: Lineage: smb_join_results_empt
PREHOOK: query: insert overwrite table smb_join_results_empty_bigtable
select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results_empty_bigtable
POSTHOOK: query: insert overwrite table smb_join_results_empty_bigtable
select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results_empty_bigtable
POSTHOOK: Lineage: smb_bucket4_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -88,11 +88,11 @@ POSTHOOK: Lineage: smb_join_results_empt
PREHOOK: query: select * from smb_join_results_empty_bigtable order by k1, v1, k2, v2
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results_empty_bigtable
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-50-43_427_8121040407367650033/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-05_497_2942078521176735166/-mr-10000
POSTHOOK: query: select * from smb_join_results_empty_bigtable order by k1, v1, k2, v2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results_empty_bigtable
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-50-43_427_8121040407367650033/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-05_497_2942078521176735166/-mr-10000
POSTHOOK: Lineage: smb_bucket4_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: smb_join_results_empty_bigtable.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:null), ]
@@ -692,14 +692,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@smb_join_results
POSTHOOK: query: insert overwrite table smb_join_results
select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@smb_join_results
POSTHOOK: Lineage: smb_bucket4_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -718,11 +718,11 @@ POSTHOOK: Lineage: smb_join_results_empt
PREHOOK: query: select * from smb_join_results order by k1, v1, k2, v2
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-50-54_358_7035919660030544601/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-12_973_1372102537783813819/-mr-10000
POSTHOOK: query: select * from smb_join_results order by k1, v1, k2, v2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-50-54_358_7035919660030544601/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-12_973_1372102537783813819/-mr-10000
POSTHOOK: Lineage: smb_bucket4_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: smb_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:null), ]
@@ -1239,13 +1239,13 @@ NULL NULL 498 val_498
NULL NULL 498 val_498
PREHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
+PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Output: default@normal_join_results
POSTHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
+POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Output: default@normal_join_results
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:null), ]
@@ -1268,11 +1268,11 @@ POSTHOOK: Lineage: smb_join_results_empt
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from normal_join_results
PREHOOK: type: QUERY
PREHOOK: Input: default@normal_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-51-07_558_4585413126943846420/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-21_393_9150168126997644301/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from normal_join_results
POSTHOOK: type: QUERY
POSTHOOK: Input: default@normal_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-51-07_558_4585413126943846420/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-21_393_9150168126997644301/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.v1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:value, type:string, comment:null), ]
@@ -1295,11 +1295,11 @@ POSTHOOK: Lineage: smb_join_results_empt
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-51-11_602_8426676182344229346/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-24_503_4889415074353736512/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-51-11_602_8426676182344229346/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-24_503_4889415074353736512/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.v1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:value, type:string, comment:null), ]
@@ -1322,11 +1322,11 @@ POSTHOOK: Lineage: smb_join_results_empt
PREHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results_empty_bigtable
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_join_results_empty_bigtable
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-51-15_729_4579951655784934773/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-27_617_7238754568395999026/-mr-10000
POSTHOOK: query: select sum(hash(k1)) as k1, sum(hash(k2)) as k2, sum(hash(v1)) as v1, sum(hash(v2)) as v2 from smb_join_results_empty_bigtable
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_join_results_empty_bigtable
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-51-15_729_4579951655784934773/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-45-27_617_7238754568395999026/-mr-10000
POSTHOOK: Lineage: normal_join_results.k1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.k2 SIMPLE [(smb_bucket4_2)b.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: normal_join_results.v1 SIMPLE [(smb_bucket4_1)a.FieldSchema(name:value, type:string, comment:null), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out Sun Aug 29 06:53:17 2010
@@ -47,14 +47,14 @@ POSTHOOK: Lineage: smb_bucket4_2.key SIM
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-34_137_8141051139723931378/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-23-26_339_3909337999945942045/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-34_137_8141051139723931378/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-23-26_339_3909337999945942045/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -67,14 +67,14 @@ NULL NULL 3000 val_169
NULL NULL 5000 val_125
PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-36_691_9046607359163451591/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-23-38_317_508151892313324438/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-36_691_9046607359163451591/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-23-38_317_508151892313324438/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -117,14 +117,14 @@ POSTHOOK: Lineage: smb_bucket4_2.value S
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-44_394_7557765393788088271/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-24-31_952_8374542834959139365/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-44_394_7557765393788088271/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-24-31_952_8374542834959139365/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
@@ -139,14 +139,14 @@ NULL NULL 3000 val_169
NULL NULL 5000 val_125
PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-46_918_7232119579754498838/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-24-43_990_3126143867389068365/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-46_918_7232119579754498838/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-24-43_990_3126143867389068365/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
@@ -199,14 +199,14 @@ POSTHOOK: Lineage: smb_bucket4_2.value S
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-54_681_4952863565750203661/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-25-38_661_7409288226979635465/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-54_681_4952863565750203661/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-25-38_661_7409288226979635465/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -223,14 +223,14 @@ POSTHOOK: Lineage: smb_bucket4_2.value S
NULL NULL 5000 val_125
PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-57_249_6696803477494534544/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-25-50_868_4035898613792109463/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-02-57_249_6696803477494534544/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-25-50_868_4035898613792109463/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -293,14 +293,14 @@ POSTHOOK: Lineage: smb_bucket4_2.value S
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:from deserializer), ]
PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-05_070_1157762852634375607/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-26-45_411_1957736509270496141/-mr-10000
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-05_070_1157762852634375607/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-26-45_411_1957736509270496141/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -322,14 +322,14 @@ POSTHOOK: Lineage: smb_bucket4_2.value S
NULL NULL 5000 val_125
PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-07_631_8246437502603272669/10000
+PREHOOK: Input: default@smb_bucket4_2
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-26-57_373_7830701927735743689/-mr-10000
POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-07_631_8246437502603272669/10000
+POSTHOOK: Input: default@smb_bucket4_2
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-26-57_373_7830701927735743689/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -436,17 +436,17 @@ POSTHOOK: Lineage: smb_bucket4_3.value S
PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@smb_bucket4_1
PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_3
-PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-18_035_8194510363795325400/10000
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-28-12_376_3195316619132079809/-mr-10000
POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@smb_bucket4_1
POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_3
-POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-18_035_8194510363795325400/10000
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-28-12_376_3195316619132079809/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -578,17 +578,17 @@ POSTHOOK: Lineage: smb_bucket4_3.value S
PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@smb_bucket4_1
PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_3
-PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-28_546_3828350776248819685/10000
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-29-27_919_6526558082466570828/-mr-10000
POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@smb_bucket4_1
POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_3
-POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-28_546_3828350776248819685/10000
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-29-27_919_6526558082466570828/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -743,17 +743,17 @@ POSTHOOK: Lineage: smb_bucket4_3.value S
PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@smb_bucket4_1
PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_3
-PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-38_980_3157892661865975232/10000
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-30-43_540_1966536991630908087/-mr-10000
POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@smb_bucket4_1
POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_3
-POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-38_980_3157892661865975232/10000
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-30-43_540_1966536991630908087/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -931,17 +931,17 @@ POSTHOOK: Lineage: smb_bucket4_3.value S
PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@smb_bucket4_1
PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_3
-PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-49_348_5700728228920265228/10000
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-31-58_568_6938740676741659181/-mr-10000
POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@smb_bucket4_1
POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_3
-POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-49_348_5700728228920265228/10000
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-31-58_568_6938740676741659181/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
@@ -1143,17 +1143,17 @@ POSTHOOK: Lineage: smb_bucket4_3.value S
PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@smb_bucket4_1
PREHOOK: Input: default@smb_bucket4_2
PREHOOK: Input: default@smb_bucket4_3
-PREHOOK: Input: default@smb_bucket4_1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-59_852_8218593296814549763/10000
+PREHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-33-14_722_2351975474311252846/-mr-10000
POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
full outer join smb_bucket4_3 c on a.key=c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@smb_bucket4_1
POSTHOOK: Input: default@smb_bucket4_2
POSTHOOK: Input: default@smb_bucket4_3
-POSTHOOK: Input: default@smb_bucket4_1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-03-59_852_8218593296814549763/10000
+POSTHOOK: Output: hdfs://localhost.localdomain:47035/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-33-14_722_2351975474311252846/-mr-10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:from deserializer), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out Sun Aug 29 06:53:17 2010
@@ -47,7 +47,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1033881589/10002
+ file:/tmp/jsichi/hive_2010-08-26_17-07-20_757_8607585855873415399/-mr-10002
Union
Select Operator
expressions:
@@ -75,7 +75,7 @@ STAGE PLANS:
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1033881589/10003
+ file:/tmp/jsichi/hive_2010-08-26_17-07-20_757_8607585855873415399/-mr-10003
Union
Select Operator
expressions:
@@ -177,17 +177,17 @@ PREHOOK: query: select unionsrc.key, cou
select 'tst1' as key, cast(count(1) as string) as value from src s1)
unionsrc group by unionsrc.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@src1
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/156140549/10000
+PREHOOK: Input: default@src1
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-07-20_875_6103598893495788063/-mr-10000
POSTHOOK: query: select unionsrc.key, count(1) FROM (select s2.key as key, s2.value as value from src1 s2
UNION ALL
select 'tst1' as key, cast(count(1) as string) as value from src s1)
unionsrc group by unionsrc.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src1
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/156140549/10000
+POSTHOOK: Input: default@src1
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-07-20_875_6103598893495788063/-mr-10000
10
128 1
146 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out Sun Aug 29 06:53:17 2010
@@ -261,9 +261,9 @@ FROM (
) union_output
GROUP BY key
PREHOOK: type: QUERY
-PREHOOK: Input: default@src_thrift
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-50-40_879_1035612367995200636/10000
+PREHOOK: Input: default@src_thrift
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-09-13_745_2040382884129754790/-mr-10000
POSTHOOK: query: SELECT key, count(1)
FROM (
SELECT '1' as key from src
@@ -278,9 +278,9 @@ FROM (
) union_output
GROUP BY key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_thrift
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-50-40_879_1035612367995200636/10000
+POSTHOOK: Input: default@src_thrift
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-09-13_745_2040382884129754790/-mr-10000
NULL 2
0 7
001 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out Sun Aug 29 06:53:17 2010
@@ -118,7 +118,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/heyongqiang/hive_2010-08-10_15-20-19_225_1224246482641447263/-mr-10002
+ directory: file:/tmp/jsichi/hive_2010-08-26_17-09-26_366_7362686340086914056/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -173,7 +173,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/heyongqiang/hive_2010-08-10_15-20-19_225_1224246482641447263/-mr-10002
+ directory: file:/tmp/jsichi/hive_2010-08-26_17-09-26_366_7362686340086914056/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -186,9 +186,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22/ds=1 [null-subquery2:subq-subquery2:a]
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1 [null-subquery2:subq-subquery2:a]
Path -> Partition:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22/ds=1
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1
Partition
base file name: ds=1
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -201,13 +201,13 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
name dst_union22
partition_columns ds
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867758
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -218,13 +218,13 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
name dst_union22
partition_columns ds
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867758
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
name: dst_union22
@@ -232,7 +232,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/heyongqiang/hive_2010-08-10_15-20-19_225_1224246482641447263/-mr-10002
+ file:/tmp/jsichi/hive_2010-08-26_17-09-26_366_7362686340086914056/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -275,7 +275,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_15-20-19_225_1224246482641447263/-ext-10000
+ directory: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-09-26_366_7362686340086914056/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -286,13 +286,13 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
name dst_union22
partition_columns ds
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867758
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
TotalFiles: 1
@@ -336,7 +336,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_15-20-19_225_1224246482641447263/-ext-10000
+ directory: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-09-26_366_7362686340086914056/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -347,23 +347,23 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
name dst_union22
partition_columns ds
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867758
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
TotalFiles: 1
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- file:/tmp/heyongqiang/hive_2010-08-10_15-20-19_225_1224246482641447263/-mr-10002 [file:/tmp/heyongqiang/hive_2010-08-10_15-20-19_225_1224246482641447263/-mr-10002]
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22_delta/ds=1 [null-subquery1:subq-subquery1:dst_union22_delta]
+ file:/tmp/jsichi/hive_2010-08-26_17-09-26_366_7362686340086914056/-mr-10002 [file:/tmp/jsichi/hive_2010-08-26_17-09-26_366_7362686340086914056/-mr-10002]
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1 [null-subquery1:subq-subquery1:dst_union22_delta]
Path -> Partition:
- file:/tmp/heyongqiang/hive_2010-08-10_15-20-19_225_1224246482641447263/-mr-10002
+ file:/tmp/jsichi/hive_2010-08-26_17-09-26_366_7362686340086914056/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -379,7 +379,7 @@ STAGE PLANS:
columns _col0,_col1,_col10,_col11
columns.types string,string,string,string
escape.delim \
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22_delta/ds=1
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1
Partition
base file name: ds=1
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -392,13 +392,13 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22_delta
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta
name dst_union22_delta
partition_columns ds
serialization.ddl struct dst_union22_delta { string k0, string k1, string k2, string k3, string k4, string k5}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867759
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -409,13 +409,13 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22_delta
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta
name dst_union22_delta
partition_columns ds
serialization.ddl struct dst_union22_delta { string k0, string k1, string k2, string k3, string k4, string k5}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867759
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22_delta
name: dst_union22_delta
@@ -426,7 +426,7 @@ STAGE PLANS:
partition:
ds 2
replace: true
- source: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_15-20-19_225_1224246482641447263/-ext-10000
+ source: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-09-26_366_7362686340086914056/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -436,16 +436,16 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
name dst_union22
partition_columns ds
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1281478813
+ transient_lastDdlTime 1282867758
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
- tmp directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_15-20-19_225_1224246482641447263/-ext-10001
+ tmp directory: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_17-09-26_366_7362686340086914056/-ext-10001
PREHOOK: query: insert overwrite table dst_union22 partition (ds='2')
@@ -460,8 +460,8 @@ where a.k1 > 20
)
subq
PREHOOK: type: QUERY
-PREHOOK: Input: default@dst_union22_delta@ds=1
PREHOOK: Input: default@dst_union22@ds=1
+PREHOOK: Input: default@dst_union22_delta@ds=1
PREHOOK: Output: default@dst_union22@ds=2
POSTHOOK: query: insert overwrite table dst_union22 partition (ds='2')
select * from
@@ -475,8 +475,8 @@ where a.k1 > 20
)
subq
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dst_union22_delta@ds=1
POSTHOOK: Input: default@dst_union22@ds=1
+POSTHOOK: Input: default@dst_union22_delta@ds=1
POSTHOOK: Output: default@dst_union22@ds=2
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -495,11 +495,11 @@ POSTHOOK: Lineage: dst_union22_delta PAR
PREHOOK: query: select * from dst_union22 where ds = '2' order by k1
PREHOOK: type: QUERY
PREHOOK: Input: default@dst_union22@ds=2
-PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-08-10_15-20-24_642_7811595587149170257/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-09-33_354_7230169091871487696/-mr-10000
POSTHOOK: query: select * from dst_union22 where ds = '2' order by k1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dst_union22@ds=2
-POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-08-10_15-20-24_642_7811595587149170257/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-09-33_354_7230169091871487696/-mr-10000
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k3 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/uniquejoin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/uniquejoin.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/uniquejoin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/uniquejoin.q.out Sun Aug 29 06:53:17 2010
@@ -31,17 +31,17 @@ POSTHOOK: Output: default@t3
PREHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c (c.key)
SELECT a.key, b.key, c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-37_498_6289754437459240853/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-24_069_7764691059022887570/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c (c.key)
SELECT a.key, b.key, c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-37_498_6289754437459240853/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-24_069_7764691059022887570/-mr-10000
1 NULL NULL
2 2 2
3 3 NULL
@@ -56,49 +56,49 @@ NULL NULL 6
PREHOOK: query: FROM UNIQUEJOIN T1 a (a.key), T2 b (b.key), T3 c (c.key)
SELECT a.key, b.key, c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-40_127_7250085494294549177/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-28_719_4365937084792175328/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN T1 a (a.key), T2 b (b.key), T3 c (c.key)
SELECT a.key, b.key, c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-40_127_7250085494294549177/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-28_719_4365937084792175328/-mr-10000
2 2 2
PREHOOK: query: FROM UNIQUEJOIN T1 a (a.key), T2 b (b.key-1), T3 c (c.key)
SELECT a.key, b.key, c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-43_825_1567908835853076632/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-33_295_8916870494939642635/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN T1 a (a.key), T2 b (b.key-1), T3 c (c.key)
SELECT a.key, b.key, c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-43_825_1567908835853076632/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-33_295_8916870494939642635/-mr-10000
2 3 2
7 8 7
7 8 7
PREHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key, a.val), PRESERVE T2 b (b.key, b.val), PRESERVE T3 c (c.key, c.val)
SELECT a.key, a.val, b.key, b.val, c.key, c.val
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-46_450_7673639263976981471/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-38_025_3055236114247084019/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key, a.val), PRESERVE T2 b (b.key, b.val), PRESERVE T3 c (c.key, c.val)
SELECT a.key, a.val, b.key, b.val, c.key, c.val
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-46_450_7673639263976981471/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-38_025_3055236114247084019/-mr-10000
1 11 NULL NULL NULL NULL
2 12 NULL NULL 2 12
NULL NULL 2 22 NULL NULL
@@ -113,17 +113,17 @@ NULL NULL NULL NULL 6 16
PREHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), T2 b (b.key), PRESERVE T3 c (c.key)
SELECT a.key, b.key, c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-49_123_8832279231761811264/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-42_685_7167574432261426669/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), T2 b (b.key), PRESERVE T3 c (c.key)
SELECT a.key, b.key, c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-49_123_8832279231761811264/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-42_685_7167574432261426669/-mr-10000
1 NULL NULL
2 2 2
3 3 NULL
@@ -137,15 +137,15 @@ NULL NULL 6
PREHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), T2 b(b.key)
SELECT a.key, b.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-51_850_1196382022472758858/10000
+PREHOOK: Input: default@t2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-47_377_9190717715738946261/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), T2 b(b.key)
SELECT a.key, b.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-42-51_850_1196382022472758858/10000
+POSTHOOK: Input: default@t2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_17-11-47_377_9190717715738946261/-mr-10000
1 NULL
2 2
3 3