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/09/09 00:46:05 UTC
svn commit: r995276 [3/3] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out?rev=995276&r1=995275&r2=995276&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out Wed Sep 8 22:46:04 2010
@@ -114,11 +114,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-26_585_7062984907777099434/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-31_140_408153388431420454/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-26_585_7062984907777099434/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-31_140_408153388431420454/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -136,11 +136,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-29_855_7237865230311355980/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-34_565_3781095733171262946/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-29_855_7237865230311355980/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-34_565_3781095733171262946/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -235,7 +235,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-33_328_2488770448970587011/-ext-10000
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-48-37_960_7019885533125445720/-ext-10000
Stage: Stage-0
Move Operator
@@ -250,7 +250,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-33_328_2488770448970587011/-ext-10004
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-48-37_960_7019885533125445720/-ext-10004
File Output Operator
compressed: false
GlobalTableId: 0
@@ -267,7 +267,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-33_328_2488770448970587011/-ext-10002
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-48-37_960_7019885533125445720/-ext-10002
Stage: Stage-1
Move Operator
@@ -282,7 +282,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-33_328_2488770448970587011/-ext-10005
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-48-37_960_7019885533125445720/-ext-10005
File Output Operator
compressed: false
GlobalTableId: 0
@@ -318,11 +318,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-37_686_3497447837335838641/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-42_412_1170633204972932042/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-37_686_3497447837335838641/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-42_412_1170633204972932042/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -344,11 +344,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-40_903_8138497954444523923/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-45_763_5479993978027191761/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-40_903_8138497954444523923/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-45_763_5479993978027191761/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -488,11 +488,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-48_278_6551952599833046968/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-53_390_1496432989382326411/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-48_278_6551952599833046968/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-53_390_1496432989382326411/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -518,11 +518,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-51_519_5112664897229715826/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-56_756_201654693279703699/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-51_519_5112664897229715826/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-48-56_756_201654693279703699/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -633,7 +633,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-54_819_7280026365714941347/-ext-10000
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-00_176_6281419673711922916/-ext-10000
Stage: Stage-0
Move Operator
@@ -648,7 +648,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-54_819_7280026365714941347/-ext-10004
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-00_176_6281419673711922916/-ext-10004
File Output Operator
compressed: false
GlobalTableId: 0
@@ -665,7 +665,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-54_819_7280026365714941347/-ext-10002
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-00_176_6281419673711922916/-ext-10002
Stage: Stage-1
Move Operator
@@ -680,7 +680,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-56-54_819_7280026365714941347/-ext-10005
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-00_176_6281419673711922916/-ext-10005
File Output Operator
compressed: false
GlobalTableId: 0
@@ -724,11 +724,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-59_335_5805006242053448401/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-04_617_771346073947439653/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-56-59_335_5805006242053448401/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-04_617_771346073947439653/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -758,11 +758,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-03_563_3139826999127039850/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-08_004_8497688845623423902/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-03_563_3139826999127039850/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-08_004_8497688845623423902/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -928,7 +928,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/nzhang/hive_2010-08-17_22-57-06_813_6503552756819430103/-mr-10004
+ file:/tmp/nzhang/hive_2010-09-08_11-49-11_372_6760243603000094371/-mr-10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -1016,11 +1016,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-14_388_7344452730412942447/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-19_241_4482349853651717318/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-14_388_7344452730412942447/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-19_241_4482349853651717318/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1050,11 +1050,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-17_791_1471719234231660660/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-22_691_5332657061833015800/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-17_791_1471719234231660660/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-22_691_5332657061833015800/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1225,7 +1225,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-21_039_3786514637394123600/-ext-10000
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-26_076_4560863739653462938/-ext-10000
Stage: Stage-0
Move Operator
@@ -1240,33 +1240,20 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-21_039_3786514637394123600/-ext-10004
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: src_multi1
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-26_076_4560863739653462938/-ext-10004
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: src_multi1
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/nzhang/hive_2010-08-17_22-57-21_039_3786514637394123600/-mr-10005
+ file:/tmp/nzhang/hive_2010-09-08_11-49-26_076_4560863739653462938/-mr-10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -1313,7 +1300,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-21_039_3786514637394123600/-ext-10002
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-26_076_4560863739653462938/-ext-10002
Stage: Stage-1
Move Operator
@@ -1328,28 +1315,15 @@ STAGE PLANS:
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-21_039_3786514637394123600/-ext-10006
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: src_multi2
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-26_076_4560863739653462938/-ext-10006
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: src_multi2
PREHOOK: query: from src
@@ -1393,11 +1367,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-28_920_700954237231927578/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-34_227_8027514505131711662/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-28_920_700954237231927578/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-34_227_8027514505131711662/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1431,11 +1405,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-32_318_7076622065680688760/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-37_603_3188940703758528665/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-32_318_7076622065680688760/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-37_603_3188940703758528665/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1614,7 +1588,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/nzhang/hive_2010-08-17_22-57-35_568_5668515889509258573/-mr-10004
+ file:/tmp/nzhang/hive_2010-09-08_11-49-40_955_545837270613951770/-mr-10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -1710,11 +1684,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-43_273_1006878872083743769/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-48_540_8456363806132424052/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-43_273_1006878872083743769/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-48_540_8456363806132424052/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1752,11 +1726,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-46_513_2443526604434599677/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-51_869_2652647599896531556/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-46_513_2443526604434599677/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-49-51_869_2652647599896531556/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1943,7 +1917,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-49_826_1827980113796407575/-ext-10000
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-55_241_3567543209701813700/-ext-10000
Stage: Stage-0
Move Operator
@@ -1958,7 +1932,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-49_826_1827980113796407575/-ext-10004
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-55_241_3567543209701813700/-ext-10004
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1971,7 +1945,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/nzhang/hive_2010-08-17_22-57-49_826_1827980113796407575/-mr-10005
+ file:/tmp/nzhang/hive_2010-09-08_11-49-55_241_3567543209701813700/-mr-10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -2018,7 +1992,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-49_826_1827980113796407575/-ext-10002
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-55_241_3567543209701813700/-ext-10002
Stage: Stage-1
Move Operator
@@ -2033,7 +2007,7 @@ STAGE PLANS:
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-57-49_826_1827980113796407575/-ext-10006
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-49-55_241_3567543209701813700/-ext-10006
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2093,11 +2067,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-58_059_8032577405312510986/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-03_079_8531959109144658995/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-57-58_059_8032577405312510986/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-03_079_8531959109144658995/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2139,11 +2113,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-01_347_6020666371340921134/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-06_488_55514686473669450/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-01_347_6020666371340921134/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-06_488_55514686473669450/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2409,11 +2383,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-08_774_4546462201936974076/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-14_155_2946380734145038539/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-08_774_4546462201936974076/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-14_155_2946380734145038539/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2473,11 +2447,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-13_022_821442089976470111/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-17_544_7626453465948145276/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-13_022_821442089976470111/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-17_544_7626453465948145276/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2702,7 +2676,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-16_273_7611279327659254187/-ext-10000
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-21_024_3082231325676704620/-ext-10000
Stage: Stage-0
Move Operator
@@ -2717,7 +2691,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-16_273_7611279327659254187/-ext-10004
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-21_024_3082231325676704620/-ext-10004
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2734,7 +2708,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-16_273_7611279327659254187/-ext-10002
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-21_024_3082231325676704620/-ext-10002
Stage: Stage-1
Move Operator
@@ -2749,7 +2723,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-16_273_7611279327659254187/-ext-10005
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-21_024_3082231325676704620/-ext-10005
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2817,11 +2791,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-20_758_8049663464735280689/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-25_618_5592276031368737141/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-20_758_8049663464735280689/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-25_618_5592276031368737141/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2885,11 +2859,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-24_002_9038273304711556584/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-29_030_5331520731644742115/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-24_002_9038273304711556584/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-29_030_5331520731644742115/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3191,11 +3165,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-31_552_3785685174355217935/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-36_787_2151577805016606292/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-31_552_3785685174355217935/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-36_787_2151577805016606292/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3263,11 +3237,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-34_794_6718886110856561482/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-40_190_4485616316665087301/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-34_794_6718886110856561482/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-40_190_4485616316665087301/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3508,7 +3482,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-38_304_6070049678551009376/-ext-10000
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-43_616_3748893713824339469/-ext-10000
Stage: Stage-0
Move Operator
@@ -3523,7 +3497,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-38_304_6070049678551009376/-ext-10004
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-43_616_3748893713824339469/-ext-10004
File Output Operator
compressed: false
GlobalTableId: 0
@@ -3540,7 +3514,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-38_304_6070049678551009376/-ext-10002
+ destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-43_616_3748893713824339469/-ext-10002
Stage: Stage-1
Move Operator
@@ -3555,7 +3529,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-58-38_304_6070049678551009376/-ext-10005
+ pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-09-08_11-50-43_616_3748893713824339469/-ext-10005
File Output Operator
compressed: false
GlobalTableId: 0
@@ -3631,11 +3605,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-42_988_2723219009626595461/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-48_153_8333575735946910490/-mr-10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-42_988_2723219009626595461/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-48_153_8333575735946910490/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3707,11 +3681,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-46_459_3639633790369527585/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-51_551_8227839750501945135/-mr-10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-17_22-58-46_459_3639633790369527585/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-08_11-50-51_551_8227839750501945135/-mr-10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]