hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From heyongqi...@apache.org
Subject svn commit: r1067034 [1/2] - in /hive/trunk: ./ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Date Thu, 03 Feb 2011 23:49:21 GMT
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



Mime
View raw message