You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by he...@apache.org on 2011/02/04 00:49:21 UTC
svn commit: r1067034 [1/2] - in /hive/trunk: ./
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Author: heyongqiang
Date: Thu Feb 3 23:49:21 2011
New Revision: 1067034
URL: http://svn.apache.org/viewvc?rev=1067034&view=rev
Log:
HIVE-1952. fix some outputs and make some tests deterministic (namit via He Yongqiang)
Modified:
hive/trunk/CHANGES.txt
hive/trunk/ql/src/test/queries/clientpositive/input_part7.q
hive/trunk/ql/src/test/queries/clientpositive/partition_vs_table_metadata.q
hive/trunk/ql/src/test/queries/clientpositive/union_ppr.q
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out
hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out
hive/trunk/ql/src/test/results/clientpositive/scriptfile1.q.out
hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
Modified: hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hive/trunk/CHANGES.txt?rev=1067034&r1=1067033&r2=1067034&view=diff
==============================================================================
--- hive/trunk/CHANGES.txt (original)
+++ hive/trunk/CHANGES.txt Thu Feb 3 23:49:21 2011
@@ -783,6 +783,9 @@ Trunk - Unreleased
HIVE-1942. change the value of hive.input.format to CombineHiveInputFormat for tests
(namit via He Yongqiang)
+ HIVE-1952. fix some outputs and make some tests deterministic
+ (namit via He Yongqiang)
+
TASKS
HIVE-1526. Hive should depend on a release version of Thrift
Modified: hive/trunk/ql/src/test/queries/clientpositive/input_part7.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/input_part7.q?rev=1067034&r1=1067033&r2=1067034&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/input_part7.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/input_part7.q Thu Feb 3 23:49:21 2011
@@ -1,14 +1,14 @@
-EXPLAIN EXTENDED
+EXPLAIN EXTENDED
SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
) A
-SORT BY A.key;
+SORT BY A.key, A.value, A.ds, A.hr;
SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
) A
-SORT BY A.key;
+SORT BY A.key, A.value, A.ds, A.hr;
Modified: hive/trunk/ql/src/test/queries/clientpositive/partition_vs_table_metadata.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/partition_vs_table_metadata.q?rev=1067034&r1=1067033&r2=1067034&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/partition_vs_table_metadata.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/partition_vs_table_metadata.q Thu Feb 3 23:49:21 2011
@@ -9,5 +9,5 @@ alter table partition_vs_table add colum
insert overwrite table partition_vs_table partition(ds='101') select key, value, key from src;
select key, value, newcol from partition_vs_table
-order by key;
+order by key, value, newcol;
Modified: hive/trunk/ql/src/test/queries/clientpositive/union_ppr.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/union_ppr.q?rev=1067034&r1=1067033&r2=1067034&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/union_ppr.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/union_ppr.q Thu Feb 3 23:49:21 2011
@@ -1,11 +1,11 @@
-EXPLAIN EXTENDED
+EXPLAIN EXTENDED
SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.key < 100
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.key < 100
) A
WHERE A.ds = '2008-04-08'
-SORT BY A.key;
+SORT BY A.key, A.value, A.ds, A.hr;
SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.key < 100
@@ -13,4 +13,4 @@ SELECT * FROM (
SELECT Y.* FROM SRCPART Y WHERE Y.key < 100
) A
WHERE A.ds = '2008-04-08'
-SORT BY A.key;
+SORT BY A.key, A.value, A.ds, A.hr;
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out?rev=1067034&r1=1067033&r2=1067034&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out Thu Feb 3 23:49:21 2011
@@ -68,16 +68,16 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table bucketmapjoin_tmp_result (key string , value1 string, value2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@bucketmapjoin_tmp_result
-PREHOOK: query: explain extended
-insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+PREHOOK: query: explain extended
+insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(b)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+POSTHOOK: query: explain extended
+insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(b)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
@@ -117,10 +117,10 @@ STAGE PLANS:
Alias Bucket Base File Name Mapping:
b {srcbucket20.txt=[srcbucket20.txt], srcbucket21.txt=[srcbucket21.txt]}
Alias Bucket File Name Mapping:
- b {pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt=[pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt=[pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt]}
+ b {pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt=[pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt=[pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt]}
Alias Bucket Output File Name Mapping:
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt 0
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt 1
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt 0
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt 1
Stage: Stage-1
Map Reduce
@@ -162,9 +162,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10002
+ directory: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -174,12 +174,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894960
+ transient_lastDdlTime 1296758377
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
TotalFiles: 1
@@ -189,9 +189,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin [a]
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin [a]
Path -> Partition:
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin
Partition
base file name: srcbucket_mapjoin
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -203,12 +203,12 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin
name srcbucket_mapjoin
serialization.ddl struct srcbucket_mapjoin { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894953
+ transient_lastDdlTime 1296758374
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -220,12 +220,12 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin
name srcbucket_mapjoin
serialization.ddl struct srcbucket_mapjoin { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894953
+ transient_lastDdlTime 1296758374
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket_mapjoin
name: srcbucket_mapjoin
@@ -237,14 +237,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10002
- destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10000
+ source: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10002
+ destination: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10000
+ source: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -254,28 +254,28 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894960
+ transient_lastDdlTime 1296758377
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
- tmp directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10001
+ tmp directory: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10002
+ pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10000
+ directory: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -286,12 +286,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894960
+ transient_lastDdlTime 1296758377
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
TotalFiles: 1
@@ -299,9 +299,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10002 [pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10002]
+ pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10002 [pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10002]
Path -> Partition:
- pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-22-40_615_6683611377161445328/-ext-10002
+ pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-39-37_892_6043894210590111647/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -312,12 +312,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894960
+ transient_lastDdlTime 1296758377
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -328,27 +328,27 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894960
+ transient_lastDdlTime 1296758377
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
name: bucketmapjoin_tmp_result
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+select /*+mapjoin(b)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket_mapjoin
PREHOOK: Output: default@bucketmapjoin_tmp_result
POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+select /*+mapjoin(b)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket_mapjoin
@@ -359,11 +359,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-22-55_207_7676433402628717113/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-39-48_581_8752071715056059159/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-22-55_207_7676433402628717113/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-39-48_581_8752071715056059159/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_tmp_result.key SIMPLE [(srcbucket_mapjoin)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value1 SIMPLE [(srcbucket_mapjoin)a.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin)b.FieldSchema(name:value, type:string, comment:null), ]
@@ -384,16 +384,16 @@ POSTHOOK: Lineage: bucketmapjoin_hash_re
POSTHOOK: Lineage: bucketmapjoin_tmp_result.key SIMPLE [(srcbucket_mapjoin)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value1 SIMPLE [(srcbucket_mapjoin)a.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin)b.FieldSchema(name:value, type:string, comment:null), ]
-PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(b)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket_mapjoin
PREHOOK: Output: default@bucketmapjoin_tmp_result
-POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(b)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket_mapjoin
@@ -410,11 +410,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-23-19_849_7262162116822440/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-03_632_6447279372975019708/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-23-19_849_7262162116822440/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-03_632_6447279372975019708/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value2 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value2, type:string, comment:null), ]
@@ -453,14 +453,14 @@ on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_hash_result_1
PREHOOK: Input: default@bucketmapjoin_hash_result_2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-23-30_833_1363058298477291982/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-10_514_4277378777837780536/-mr-10000
POSTHOOK: query: select a.key-b.key, a.value1-b.value1, a.value2-b.value2
from bucketmapjoin_hash_result_1 a left outer join bucketmapjoin_hash_result_2 b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_hash_result_1
POSTHOOK: Input: default@bucketmapjoin_hash_result_2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-23-30_833_1363058298477291982/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-10_514_4277378777837780536/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value2 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value2, type:string, comment:null), ]
@@ -475,15 +475,15 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin)b.FieldSchema(name:value, type:string, comment:null), ]
0 0 0
PREHOOK: query: explain extended
-insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(a)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(a)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain extended
-insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(a)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(a)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
POSTHOOK: type: QUERY
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
@@ -535,10 +535,10 @@ STAGE PLANS:
Alias Bucket Base File Name Mapping:
a {srcbucket20.txt=[srcbucket20.txt], srcbucket21.txt=[srcbucket21.txt]}
Alias Bucket File Name Mapping:
- a {pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt=[pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt=[pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt]}
+ a {pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt=[pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt=[pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt]}
Alias Bucket Output File Name Mapping:
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt 0
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt 1
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt 0
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt 1
Stage: Stage-1
Map Reduce
@@ -580,9 +580,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10002
+ directory: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -592,7 +592,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -601,7 +601,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1288894999
+ transient_lastDdlTime 1296758403
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
TotalFiles: 1
@@ -611,9 +611,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin [b]
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin [b]
Path -> Partition:
- pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin
Partition
base file name: srcbucket_mapjoin
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -625,12 +625,12 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin
name srcbucket_mapjoin
serialization.ddl struct srcbucket_mapjoin { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894953
+ transient_lastDdlTime 1296758374
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -642,12 +642,12 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcbucket_mapjoin
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcbucket_mapjoin
name srcbucket_mapjoin
serialization.ddl struct srcbucket_mapjoin { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288894953
+ transient_lastDdlTime 1296758374
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket_mapjoin
name: srcbucket_mapjoin
@@ -659,14 +659,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10002
- destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10000
+ source: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10002
+ destination: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10000
+ source: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -676,7 +676,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -685,23 +685,23 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1288894999
+ transient_lastDdlTime 1296758403
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
- tmp directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10001
+ tmp directory: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10002
+ pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10000
+ directory: pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -712,7 +712,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -721,7 +721,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1288894999
+ transient_lastDdlTime 1296758403
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
TotalFiles: 1
@@ -729,9 +729,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10002 [pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10002]
+ pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10002 [pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10002]
Path -> Partition:
- pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_11-23-36_325_7813368709164240016/-ext-10002
+ pfile:/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-40-13_672_8524397052406932420/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -742,7 +742,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -751,7 +751,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1288894999
+ transient_lastDdlTime 1296758403
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -762,7 +762,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -771,22 +771,22 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1288894999
+ transient_lastDdlTime 1296758403
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucketmapjoin_tmp_result
name: bucketmapjoin_tmp_result
-PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(a)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(a)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket_mapjoin
PREHOOK: Output: default@bucketmapjoin_tmp_result
-POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(a)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(a)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket_mapjoin
@@ -809,11 +809,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-23-51_993_4668218591132162022/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-22_377_5727516753399224026/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-23-51_993_4668218591132162022/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-22_377_5727516753399224026/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value2 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value2, type:string, comment:null), ]
@@ -858,16 +858,16 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin)b.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin)b.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin)b.FieldSchema(name:value, type:string, comment:null), ]
-PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(a)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(a)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket_mapjoin
PREHOOK: Output: default@bucketmapjoin_tmp_result
-POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
-select /*+mapjoin(a)*/ a.key, a.value, b.value
-from srcbucket_mapjoin a join srcbucket_mapjoin b
+POSTHOOK: query: insert overwrite table bucketmapjoin_tmp_result
+select /*+mapjoin(a)*/ a.key, a.value, b.value
+from srcbucket_mapjoin a join srcbucket_mapjoin b
on a.key=b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket_mapjoin
@@ -896,11 +896,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-24-23_108_4512355766611583689/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-37_249_1616452678927934445/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-24-23_108_4512355766611583689/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-37_249_1616452678927934445/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
@@ -963,14 +963,14 @@ on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_hash_result_1
PREHOOK: Input: default@bucketmapjoin_hash_result_2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-24-35_316_1675503630341751532/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-44_035_1613079877808759652/-mr-10000
POSTHOOK: query: select a.key-b.key, a.value1-b.value1, a.value2-b.value2
from bucketmapjoin_hash_result_1 a left outer join bucketmapjoin_hash_result_2 b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_hash_result_1
POSTHOOK: Input: default@bucketmapjoin_hash_result_2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_11-24-35_316_1675503630341751532/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_10-40-44_035_1613079877808759652/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1067034&r1=1067033&r2=1067034&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Thu Feb 3 23:49:21 2011
@@ -1,21 +1,21 @@
-PREHOOK: query: EXPLAIN EXTENDED
+PREHOOK: query: EXPLAIN EXTENDED
SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
) A
-SORT BY A.key
+SORT BY A.key, A.value, A.ds, A.hr
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN EXTENDED
+POSTHOOK: query: EXPLAIN EXTENDED
SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
) A
-SORT BY A.key
+SORT BY A.key, A.value, A.ds, A.hr
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART X)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF X))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL X) ds) '2008-04-08') (< (. (TOK_TABLE_OR_COL X) key) 100))))) (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART Y)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF Y))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL Y) ds) '2008-04-08') (< (. (TOK_TABLE_OR_COL Y) key) 100)))))) A)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL A) key)))))
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART X)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF X))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL X) ds) '2008-04-08') (< (. (TOK_TABLE_OR_COL X) key) 100))))) (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART Y)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF Y))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL Y) ds) '2008-04-08') (< (. (TOK_TABLE_OR_COL Y) key) 100)))))) A)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL A) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL A) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL A) ds)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL A) hr)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -66,7 +66,13 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ sort order: ++++
tag: -1
value expressions:
expr: _col0
@@ -118,7 +124,13 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ sort order: ++++
tag: -1
value expressions:
expr: _col0
@@ -131,10 +143,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -148,13 +160,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288389287
+ transient_lastDdlTime 1296760001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -165,17 +177,17 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288389287
+ transient_lastDdlTime 1296760001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -189,13 +201,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288389287
+ transient_lastDdlTime 1296760001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -206,13 +218,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/njain/hive_commit1/build/ql/test/data/warehouse/srcpart
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288389287
+ transient_lastDdlTime 1296760001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -221,9 +233,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2010-10-29_15-34-09_209_7181704230582070311/-ext-10001
+ directory: file:/tmp/njain/hive_2011-02-03_11-06-52_255_8150535869499892719/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2010-10-29_15-34-09_209_7181704230582070311/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/njain/hive_2011-02-03_11-06-52_255_8150535869499892719/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -245,21 +257,21 @@ PREHOOK: query: SELECT * FROM (
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
) A
-SORT BY A.key
+SORT BY A.key, A.value, A.ds, A.hr
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_15-34-09_364_978163510203107296/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2011-02-03_11-06-52_647_4598400577694048071/-mr-10000
POSTHOOK: query: SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
) A
-SORT BY A.key
+SORT BY A.key, A.value, A.ds, A.hr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_15-34-09_364_978163510203107296/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2011-02-03_11-06-52_647_4598400577694048071/-mr-10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
@@ -272,22 +284,22 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
0 val_0 2008-04-08 12
0 val_0 2008-04-08 12
0 val_0 2008-04-08 12
-10 val_10 2008-04-08 12
-10 val_10 2008-04-08 12
10 val_10 2008-04-08 11
10 val_10 2008-04-08 11
+10 val_10 2008-04-08 12
+10 val_10 2008-04-08 12
11 val_11 2008-04-08 11
11 val_11 2008-04-08 11
11 val_11 2008-04-08 12
11 val_11 2008-04-08 12
-12 val_12 2008-04-08 12
-12 val_12 2008-04-08 12
-12 val_12 2008-04-08 12
-12 val_12 2008-04-08 12
12 val_12 2008-04-08 11
12 val_12 2008-04-08 11
12 val_12 2008-04-08 11
12 val_12 2008-04-08 11
+12 val_12 2008-04-08 12
+12 val_12 2008-04-08 12
+12 val_12 2008-04-08 12
+12 val_12 2008-04-08 12
15 val_15 2008-04-08 11
15 val_15 2008-04-08 11
15 val_15 2008-04-08 11
@@ -296,10 +308,10 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
15 val_15 2008-04-08 12
15 val_15 2008-04-08 12
15 val_15 2008-04-08 12
-17 val_17 2008-04-08 12
-17 val_17 2008-04-08 12
17 val_17 2008-04-08 11
17 val_17 2008-04-08 11
+17 val_17 2008-04-08 12
+17 val_17 2008-04-08 12
18 val_18 2008-04-08 11
18 val_18 2008-04-08 11
18 val_18 2008-04-08 11
@@ -308,18 +320,18 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
18 val_18 2008-04-08 12
18 val_18 2008-04-08 12
18 val_18 2008-04-08 12
-19 val_19 2008-04-08 12
-19 val_19 2008-04-08 12
19 val_19 2008-04-08 11
19 val_19 2008-04-08 11
+19 val_19 2008-04-08 12
+19 val_19 2008-04-08 12
2 val_2 2008-04-08 11
2 val_2 2008-04-08 11
2 val_2 2008-04-08 12
2 val_2 2008-04-08 12
-20 val_20 2008-04-08 12
-20 val_20 2008-04-08 12
20 val_20 2008-04-08 11
20 val_20 2008-04-08 11
+20 val_20 2008-04-08 12
+20 val_20 2008-04-08 12
24 val_24 2008-04-08 11
24 val_24 2008-04-08 11
24 val_24 2008-04-08 11
@@ -328,46 +340,46 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
24 val_24 2008-04-08 12
24 val_24 2008-04-08 12
24 val_24 2008-04-08 12
-26 val_26 2008-04-08 12
-26 val_26 2008-04-08 12
-26 val_26 2008-04-08 12
-26 val_26 2008-04-08 12
26 val_26 2008-04-08 11
26 val_26 2008-04-08 11
26 val_26 2008-04-08 11
26 val_26 2008-04-08 11
+26 val_26 2008-04-08 12
+26 val_26 2008-04-08 12
+26 val_26 2008-04-08 12
+26 val_26 2008-04-08 12
27 val_27 2008-04-08 11
27 val_27 2008-04-08 11
27 val_27 2008-04-08 12
27 val_27 2008-04-08 12
-28 val_28 2008-04-08 12
-28 val_28 2008-04-08 12
28 val_28 2008-04-08 11
28 val_28 2008-04-08 11
+28 val_28 2008-04-08 12
+28 val_28 2008-04-08 12
30 val_30 2008-04-08 11
30 val_30 2008-04-08 11
30 val_30 2008-04-08 12
30 val_30 2008-04-08 12
-33 val_33 2008-04-08 12
-33 val_33 2008-04-08 12
33 val_33 2008-04-08 11
33 val_33 2008-04-08 11
+33 val_33 2008-04-08 12
+33 val_33 2008-04-08 12
34 val_34 2008-04-08 11
34 val_34 2008-04-08 11
34 val_34 2008-04-08 12
34 val_34 2008-04-08 12
-35 val_35 2008-04-08 12
-35 val_35 2008-04-08 12
-35 val_35 2008-04-08 12
-35 val_35 2008-04-08 12
-35 val_35 2008-04-08 12
-35 val_35 2008-04-08 12
35 val_35 2008-04-08 11
35 val_35 2008-04-08 11
35 val_35 2008-04-08 11
35 val_35 2008-04-08 11
35 val_35 2008-04-08 11
35 val_35 2008-04-08 11
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
37 val_37 2008-04-08 11
37 val_37 2008-04-08 11
37 val_37 2008-04-08 11
@@ -376,46 +388,46 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
37 val_37 2008-04-08 12
37 val_37 2008-04-08 12
37 val_37 2008-04-08 12
-4 val_4 2008-04-08 12
-4 val_4 2008-04-08 12
4 val_4 2008-04-08 11
4 val_4 2008-04-08 11
+4 val_4 2008-04-08 12
+4 val_4 2008-04-08 12
41 val_41 2008-04-08 11
41 val_41 2008-04-08 11
41 val_41 2008-04-08 12
41 val_41 2008-04-08 12
-42 val_42 2008-04-08 12
-42 val_42 2008-04-08 12
-42 val_42 2008-04-08 12
-42 val_42 2008-04-08 12
42 val_42 2008-04-08 11
42 val_42 2008-04-08 11
42 val_42 2008-04-08 11
42 val_42 2008-04-08 11
+42 val_42 2008-04-08 12
+42 val_42 2008-04-08 12
+42 val_42 2008-04-08 12
+42 val_42 2008-04-08 12
43 val_43 2008-04-08 11
43 val_43 2008-04-08 11
43 val_43 2008-04-08 12
43 val_43 2008-04-08 12
-44 val_44 2008-04-08 12
-44 val_44 2008-04-08 12
44 val_44 2008-04-08 11
44 val_44 2008-04-08 11
+44 val_44 2008-04-08 12
+44 val_44 2008-04-08 12
47 val_47 2008-04-08 11
47 val_47 2008-04-08 11
47 val_47 2008-04-08 12
47 val_47 2008-04-08 12
-5 val_5 2008-04-08 12
-5 val_5 2008-04-08 12
-5 val_5 2008-04-08 12
-5 val_5 2008-04-08 12
-5 val_5 2008-04-08 12
-5 val_5 2008-04-08 12
5 val_5 2008-04-08 11
5 val_5 2008-04-08 11
5 val_5 2008-04-08 11
5 val_5 2008-04-08 11
5 val_5 2008-04-08 11
5 val_5 2008-04-08 11
+5 val_5 2008-04-08 12
+5 val_5 2008-04-08 12
+5 val_5 2008-04-08 12
+5 val_5 2008-04-08 12
+5 val_5 2008-04-08 12
+5 val_5 2008-04-08 12
51 val_51 2008-04-08 11
51 val_51 2008-04-08 11
51 val_51 2008-04-08 11
@@ -424,18 +436,18 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
51 val_51 2008-04-08 12
51 val_51 2008-04-08 12
51 val_51 2008-04-08 12
-53 val_53 2008-04-08 12
-53 val_53 2008-04-08 12
53 val_53 2008-04-08 11
53 val_53 2008-04-08 11
+53 val_53 2008-04-08 12
+53 val_53 2008-04-08 12
54 val_54 2008-04-08 11
54 val_54 2008-04-08 11
54 val_54 2008-04-08 12
54 val_54 2008-04-08 12
-57 val_57 2008-04-08 12
-57 val_57 2008-04-08 12
57 val_57 2008-04-08 11
57 val_57 2008-04-08 11
+57 val_57 2008-04-08 12
+57 val_57 2008-04-08 12
58 val_58 2008-04-08 11
58 val_58 2008-04-08 11
58 val_58 2008-04-08 11
@@ -444,18 +456,18 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
58 val_58 2008-04-08 12
58 val_58 2008-04-08 12
58 val_58 2008-04-08 12
-64 val_64 2008-04-08 12
-64 val_64 2008-04-08 12
64 val_64 2008-04-08 11
64 val_64 2008-04-08 11
+64 val_64 2008-04-08 12
+64 val_64 2008-04-08 12
65 val_65 2008-04-08 11
65 val_65 2008-04-08 11
65 val_65 2008-04-08 12
65 val_65 2008-04-08 12
-66 val_66 2008-04-08 12
-66 val_66 2008-04-08 12
66 val_66 2008-04-08 11
66 val_66 2008-04-08 11
+66 val_66 2008-04-08 12
+66 val_66 2008-04-08 12
67 val_67 2008-04-08 11
67 val_67 2008-04-08 11
67 val_67 2008-04-08 11
@@ -464,10 +476,10 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
67 val_67 2008-04-08 12
67 val_67 2008-04-08 12
67 val_67 2008-04-08 12
-69 val_69 2008-04-08 12
-69 val_69 2008-04-08 12
69 val_69 2008-04-08 11
69 val_69 2008-04-08 11
+69 val_69 2008-04-08 12
+69 val_69 2008-04-08 12
70 val_70 2008-04-08 11
70 val_70 2008-04-08 11
70 val_70 2008-04-08 11
@@ -480,54 +492,54 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
70 val_70 2008-04-08 12
70 val_70 2008-04-08 12
70 val_70 2008-04-08 12
-72 val_72 2008-04-08 12
-72 val_72 2008-04-08 12
-72 val_72 2008-04-08 12
-72 val_72 2008-04-08 12
72 val_72 2008-04-08 11
72 val_72 2008-04-08 11
72 val_72 2008-04-08 11
72 val_72 2008-04-08 11
+72 val_72 2008-04-08 12
+72 val_72 2008-04-08 12
+72 val_72 2008-04-08 12
+72 val_72 2008-04-08 12
74 val_74 2008-04-08 11
74 val_74 2008-04-08 11
74 val_74 2008-04-08 12
74 val_74 2008-04-08 12
-76 val_76 2008-04-08 12
-76 val_76 2008-04-08 12
-76 val_76 2008-04-08 12
-76 val_76 2008-04-08 12
76 val_76 2008-04-08 11
76 val_76 2008-04-08 11
76 val_76 2008-04-08 11
76 val_76 2008-04-08 11
+76 val_76 2008-04-08 12
+76 val_76 2008-04-08 12
+76 val_76 2008-04-08 12
+76 val_76 2008-04-08 12
77 val_77 2008-04-08 11
77 val_77 2008-04-08 11
77 val_77 2008-04-08 12
77 val_77 2008-04-08 12
-78 val_78 2008-04-08 12
-78 val_78 2008-04-08 12
78 val_78 2008-04-08 11
78 val_78 2008-04-08 11
+78 val_78 2008-04-08 12
+78 val_78 2008-04-08 12
8 val_8 2008-04-08 11
8 val_8 2008-04-08 11
8 val_8 2008-04-08 12
8 val_8 2008-04-08 12
-80 val_80 2008-04-08 12
-80 val_80 2008-04-08 12
80 val_80 2008-04-08 11
80 val_80 2008-04-08 11
+80 val_80 2008-04-08 12
+80 val_80 2008-04-08 12
82 val_82 2008-04-08 11
82 val_82 2008-04-08 11
82 val_82 2008-04-08 12
82 val_82 2008-04-08 12
-83 val_83 2008-04-08 12
-83 val_83 2008-04-08 12
-83 val_83 2008-04-08 12
-83 val_83 2008-04-08 12
83 val_83 2008-04-08 11
83 val_83 2008-04-08 11
83 val_83 2008-04-08 11
83 val_83 2008-04-08 11
+83 val_83 2008-04-08 12
+83 val_83 2008-04-08 12
+83 val_83 2008-04-08 12
+83 val_83 2008-04-08 12
84 val_84 2008-04-08 11
84 val_84 2008-04-08 11
84 val_84 2008-04-08 11
@@ -536,58 +548,58 @@ POSTHOOK: Output: file:/tmp/sdong/hive_2
84 val_84 2008-04-08 12
84 val_84 2008-04-08 12
84 val_84 2008-04-08 12
-85 val_85 2008-04-08 12
-85 val_85 2008-04-08 12
85 val_85 2008-04-08 11
85 val_85 2008-04-08 11
+85 val_85 2008-04-08 12
+85 val_85 2008-04-08 12
86 val_86 2008-04-08 11
86 val_86 2008-04-08 11
86 val_86 2008-04-08 12
86 val_86 2008-04-08 12
-87 val_87 2008-04-08 12
-87 val_87 2008-04-08 12
87 val_87 2008-04-08 11
87 val_87 2008-04-08 11
+87 val_87 2008-04-08 12
+87 val_87 2008-04-08 12
9 val_9 2008-04-08 11
9 val_9 2008-04-08 11
9 val_9 2008-04-08 12
9 val_9 2008-04-08 12
-90 val_90 2008-04-08 12
-90 val_90 2008-04-08 12
-90 val_90 2008-04-08 12
-90 val_90 2008-04-08 12
-90 val_90 2008-04-08 12
-90 val_90 2008-04-08 12
90 val_90 2008-04-08 11
90 val_90 2008-04-08 11
90 val_90 2008-04-08 11
90 val_90 2008-04-08 11
90 val_90 2008-04-08 11
90 val_90 2008-04-08 11
+90 val_90 2008-04-08 12
+90 val_90 2008-04-08 12
+90 val_90 2008-04-08 12
+90 val_90 2008-04-08 12
+90 val_90 2008-04-08 12
+90 val_90 2008-04-08 12
92 val_92 2008-04-08 11
92 val_92 2008-04-08 11
92 val_92 2008-04-08 12
92 val_92 2008-04-08 12
-95 val_95 2008-04-08 12
-95 val_95 2008-04-08 12
-95 val_95 2008-04-08 12
-95 val_95 2008-04-08 12
95 val_95 2008-04-08 11
95 val_95 2008-04-08 11
95 val_95 2008-04-08 11
95 val_95 2008-04-08 11
+95 val_95 2008-04-08 12
+95 val_95 2008-04-08 12
+95 val_95 2008-04-08 12
+95 val_95 2008-04-08 12
96 val_96 2008-04-08 11
96 val_96 2008-04-08 11
96 val_96 2008-04-08 12
96 val_96 2008-04-08 12
-97 val_97 2008-04-08 12
-97 val_97 2008-04-08 12
-97 val_97 2008-04-08 12
-97 val_97 2008-04-08 12
97 val_97 2008-04-08 11
97 val_97 2008-04-08 11
97 val_97 2008-04-08 11
97 val_97 2008-04-08 11
+97 val_97 2008-04-08 12
+97 val_97 2008-04-08 12
+97 val_97 2008-04-08 12
+97 val_97 2008-04-08 12
98 val_98 2008-04-08 11
98 val_98 2008-04-08 11
98 val_98 2008-04-08 11