hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r1170005 [3/7] - in /hive/trunk: data/files/ ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/ ql/src/test/results/compiler/plan/
Date Tue, 13 Sep 2011 02:06:05 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Tue Sep 13 02:06:03 2011
@@ -107,10 +107,10 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -123,7 +123,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -134,7 +134,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -145,7 +145,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -156,11 +156,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -173,7 +173,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -184,7 +184,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -195,7 +195,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -206,7 +206,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -215,15 +215,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-23_794_45487565656477583/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-21_129_4065046827555412953/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-23_794_45487565656477583/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-21_129_4065046827555412953/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2
                   columns.types int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -238,12 +239,12 @@ PREHOOK: query: select key, value, ds fr
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-23_901_543871112868419867/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-21_189_928400507516888386/-mr-10000
 POSTHOOK: query: select key, value, ds from pcr_t1 where ds<='2000-04-09' and key<5 order by key, ds
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-23_901_543871112868419867/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-21_189_928400507516888386/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -310,11 +311,11 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -327,7 +328,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -338,7 +339,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -349,7 +350,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -360,11 +361,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -377,7 +378,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -388,7 +389,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -399,7 +400,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -410,11 +411,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
           Partition
             base file name: ds=2000-04-10
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -427,7 +428,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -438,7 +439,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984463
+              transient_lastDdlTime 1311931521
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -449,7 +450,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -460,7 +461,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -469,15 +470,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-26_949_686771378189251939/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-23_865_6506623963862014221/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-26_949_686771378189251939/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-23_865_6506623963862014221/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1
                   columns.types int:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -493,13 +495,13 @@ PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
 PREHOOK: Input: default@pcr_t1@ds=2000-04-10
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-27_063_5837880324861709071/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-23_926_1611813292250503932/-mr-10000
 POSTHOOK: query: select key, value from pcr_t1 where ds<='2000-04-09' or key<5 order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-10
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-27_063_5837880324861709071/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-23_926_1611813292250503932/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -607,10 +609,10 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -623,7 +625,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -634,7 +636,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -645,7 +647,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -656,11 +658,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -673,7 +675,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -684,7 +686,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -695,7 +697,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -706,7 +708,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -715,15 +717,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-30_270_8932721888182592546/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-26_679_5171780899276979732/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-30_270_8932721888182592546/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-26_679_5171780899276979732/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2
                   columns.types int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -738,12 +741,12 @@ PREHOOK: query: select key, value, ds fr
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-30_378_3001871383983881471/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-26_734_1964916511399680084/-mr-10000
 POSTHOOK: query: select key, value, ds from pcr_t1 where ds<='2000-04-09' and key<5 and value != 'val_2' order by key, ds
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-30_378_3001871383983881471/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-26_734_1964916511399680084/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -818,10 +821,10 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -834,7 +837,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -845,7 +848,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -856,7 +859,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -867,11 +870,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
           Partition
             base file name: ds=2000-04-10
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -884,7 +887,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -895,7 +898,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984463
+              transient_lastDdlTime 1311931521
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -906,7 +909,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -917,7 +920,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -926,15 +929,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-33_477_4843342398582016187/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-29_372_2124753264258245021/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-33_477_4843342398582016187/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-29_372_2124753264258245021/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2
                   columns.types int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -950,13 +954,13 @@ where (ds < '2000-04-09' and key < 5) or
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-10
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-33_595_7059370303120446928/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-29_446_9139902346775639073/-mr-10000
 POSTHOOK: query: select key, value, ds from pcr_t1
 where (ds < '2000-04-09' and key < 5) or (ds > '2000-04-09' and value == 'val_5') order by key, ds
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-10
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-33_595_7059370303120446928/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-29_446_9139902346775639073/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1031,11 +1035,11 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1048,7 +1052,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1059,7 +1063,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1070,7 +1074,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1081,11 +1085,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1098,7 +1102,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1109,7 +1113,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1120,7 +1124,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1131,11 +1135,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
           Partition
             base file name: ds=2000-04-10
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1148,7 +1152,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1159,7 +1163,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984463
+              transient_lastDdlTime 1311931521
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1170,7 +1174,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1181,7 +1185,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -1190,15 +1194,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-36_836_3051586657356094147/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-32_131_4848675280784439482/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-36_836_3051586657356094147/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-32_131_4848675280784439482/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2
                   columns.types int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -1215,14 +1220,14 @@ PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
 PREHOOK: Input: default@pcr_t1@ds=2000-04-10
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-37_078_5128271294396999103/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-32_192_4474962480767634565/-mr-10000
 POSTHOOK: query: select key, value, ds from pcr_t1
 where (ds < '2000-04-10' and key < 5) or (ds > '2000-04-08' and value == 'val_5') order by key, ds
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-10
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-37_078_5128271294396999103/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-32_192_4474962480767634565/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1305,11 +1310,11 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1322,7 +1327,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1333,7 +1338,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1344,7 +1349,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1355,11 +1360,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1372,7 +1377,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1383,7 +1388,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1394,7 +1399,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1405,11 +1410,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
           Partition
             base file name: ds=2000-04-10
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1422,7 +1427,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1433,7 +1438,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984463
+              transient_lastDdlTime 1311931521
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1444,7 +1449,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1455,7 +1460,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -1464,15 +1469,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-40_317_3482597828578299090/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-34_889_6668013612120955079/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-40_317_3482597828578299090/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-34_889_6668013612120955079/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2
                   columns.types int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -1489,14 +1495,14 @@ PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
 PREHOOK: Input: default@pcr_t1@ds=2000-04-10
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-40_434_156015404539012634/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-34_951_6978641764651819716/-mr-10000
 POSTHOOK: query: select key, value, ds from pcr_t1
 where (ds < '2000-04-10' or key < 5) and (ds > '2000-04-08' or value == 'val_5') order by key, ds
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-10
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-40_434_156015404539012634/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-34_951_6978641764651819716/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1583,10 +1589,10 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1599,7 +1605,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1610,7 +1616,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1621,7 +1627,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1632,11 +1638,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1649,7 +1655,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1660,7 +1666,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1671,7 +1677,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1682,7 +1688,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -1691,15 +1697,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-43_671_9068406681245435665/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-37_712_2575302228085329340/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-43_671_9068406681245435665/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-37_712_2575302228085329340/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1
                   columns.types int:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -1714,12 +1721,12 @@ PREHOOK: query: select key, value from p
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-43_787_4480677150525031425/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-37_773_2998616591696876714/-mr-10000
 POSTHOOK: query: select key, value from pcr_t1 where (ds='2000-04-08' or ds='2000-04-09') and key=14 order by key, value
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-43_787_4480677150525031425/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-37_773_2998616591696876714/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1773,10 +1780,10 @@ STAGE PLANS:
                       type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1789,7 +1796,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1800,7 +1807,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1811,7 +1818,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1822,11 +1829,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1839,7 +1846,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -1850,7 +1857,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1861,7 +1868,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -1872,7 +1879,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -1881,15 +1888,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-46_895_6528226210433167390/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-40_463_8266098016871150118/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-46_895_6528226210433167390/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-40_463_8266098016871150118/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1
                   columns.types int:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -1904,12 +1912,12 @@ PREHOOK: query: select key, value from p
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-47_011_5025313460613776496/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-40_524_2597517539449159730/-mr-10000
 POSTHOOK: query: select key, value from pcr_t1 where ds='2000-04-08' or ds='2000-04-09' order by key, value
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-47_011_5025313460613776496/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-40_524_2597517539449159730/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2003,11 +2011,11 @@ STAGE PLANS:
                       type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2020,7 +2028,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -2031,7 +2039,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2042,7 +2050,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -2053,11 +2061,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2070,7 +2078,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -2081,7 +2089,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2092,7 +2100,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -2103,11 +2111,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 
           Partition
             base file name: ds=2000-04-10
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2120,7 +2128,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -2131,7 +2139,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984463
+              transient_lastDdlTime 1311931521
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2142,7 +2150,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -2153,7 +2161,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -2162,15 +2170,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-50_070_7918278309965809032/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-43_193_5744597926147610591/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-50_070_7918278309965809032/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-43_193_5744597926147610591/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1
                   columns.types int:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -2186,13 +2195,13 @@ PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
 PREHOOK: Input: default@pcr_t1@ds=2000-04-10
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-50_186_7467964439268319364/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-43_252_4071559680842866158/-mr-10000
 POSTHOOK: query: select key, value from pcr_t1 where ds>='2000-04-08' or ds<'2000-04-10' order by key, value
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-10
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-50_186_7467964439268319364/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-43_252_4071559680842866158/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2317,10 +2326,10 @@ STAGE PLANS:
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2333,7 +2342,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -2344,7 +2353,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2355,7 +2364,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -2366,11 +2375,11 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 
           Partition
             base file name: ds=2000-04-09
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2383,7 +2392,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -2394,7 +2403,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984459
+              transient_lastDdlTime 1311931517
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2405,7 +2414,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -2416,7 +2425,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -2425,15 +2434,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-53_371_8781736527660496822/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-45_996_195479673300228897/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-53_371_8781736527660496822/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-45_996_195479673300228897/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2
                   columns.types int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -2448,12 +2458,12 @@ PREHOOK: query: select key, value, ds fr
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08
 PREHOOK: Input: default@pcr_t1@ds=2000-04-09
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-53_489_3007975236537851113/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-46_058_7061582212109052102/-mr-10000
 POSTHOOK: query: select key, value, ds from pcr_t1 where (ds='2000-04-08' and key=1) or (ds='2000-04-09' and key=2) order by key, value, ds
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-09
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-53_489_3007975236537851113/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_02-25-46_058_7061582212109052102/-mr-10000
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-08).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: pcr_t1 PARTITION(ds=2000-04-09).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2525,9 +2535,9 @@ STAGE PLANS:
                     type: string
       Needs Tagging: true
       Path -> Alias:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [t2, t1]
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [t2, t1]
       Path -> Partition:
-        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
+        pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 
           Partition
             base file name: ds=2000-04-08
             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2540,7 +2550,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+              location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
               name default.pcr_t1
               numFiles 1
               numPartitions 3
@@ -2551,7 +2561,7 @@ STAGE PLANS:
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               totalSize 180
-              transient_lastDdlTime 1306984455
+              transient_lastDdlTime 1311931513
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2562,7 +2572,7 @@ 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/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
+                location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/pcr_t1
                 name default.pcr_t1
                 numFiles 3
                 numPartitions 3
@@ -2573,7 +2583,7 @@ STAGE PLANS:
                 serialization.format 1
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 totalSize 540
-                transient_lastDdlTime 1306984463
+                transient_lastDdlTime 1311931521
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: default.pcr_t1
             name: default.pcr_t1
@@ -2604,7 +2614,7 @@ STAGE PLANS:
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-mr-10002
+              directory: file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-mr-10002
               NumFilesPerFileSink: 1
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -2620,7 +2630,7 @@ STAGE PLANS:
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-mr-10002 
+        file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-mr-10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -2642,9 +2652,9 @@ STAGE PLANS:
                     type: string
       Needs Tagging: false
       Path -> Alias:
-        file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-mr-10002 [file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-mr-10002]
+        file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-mr-10002 [file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-mr-10002]
       Path -> Partition:
-        file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-mr-10002 
+        file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-mr-10002 
           Partition
             base file name: -mr-10002
             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -2665,15 +2675,16 @@ STAGE PLANS:
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-ext-10001
+            directory: file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-ext-10001
             NumFilesPerFileSink: 1
-            Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-56_612_921414605077106335/-ext-10001/
+            Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_02-25-48_777_7397747697764876900/-ext-10001/
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   columns _col0,_col1,_col2,_col3,_col4,_col5
                   columns.types int:string:string:int:string:string
+                  escape.delim \
                   serialization.format 1
             TotalFiles: 1
             GatherStats: false
@@ -2687,11 +2698,11 @@ STAGE PLANS:
 PREHOOK: query: select * from pcr_t1 t1 join pcr_t1 t2 on t1.key=t2.key and t1.ds='2000-04-08' and t2.ds='2000-04-08' order by t1.key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@pcr_t1@ds=2000-04-08

[... 1532 lines stripped ...]


Mime
View raw message