You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2011/06/03 18:45:40 UTC
svn commit: r1131106 [8/11] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/java/org/apache/hadoop/hive/contrib/serde2/
contrib/src/java/org/apache/hadoop/hive/contrib/serde2/s3/
hbase-handler/src/java/org/apache/hadoop/hive/...
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=1131106&r1=1131105&r2=1131106&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Fri Jun 3 16:45:37 2011
@@ -112,10 +112,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/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-08 [pcr_t1]
+ pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -128,17 +128,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -149,21 +150,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -176,17 +178,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -197,17 +200,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -216,9 +220,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-04-50_219_2344810470921724019/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-23_794_45487565656477583/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-04-50_219_2344810470921724019/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-23_794_45487565656477583/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -239,12 +243,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/nzhang/hive_2011-04-05_21-04-50_338_1591075691969072143/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-23_901_543871112868419867/-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/nzhang/hive_2011-04-05_21-04-50_338_1591075691969072143/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-23_901_543871112868419867/-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), ]
@@ -316,11 +320,11 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+ 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]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -333,17 +337,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -354,21 +359,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -381,17 +387,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -402,21 +409,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ pfile:/data/users/tomasz/apache-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
@@ -429,17 +437,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -450,17 +459,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -469,9 +479,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-04-53_453_8448141753544546219/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-26_949_686771378189251939/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-04-53_453_8448141753544546219/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-26_949_686771378189251939/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -493,13 +503,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/nzhang/hive_2011-04-05_21-04-53_585_2471663808341442226/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-27_063_5837880324861709071/-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/nzhang/hive_2011-04-05_21-04-53_585_2471663808341442226/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-27_063_5837880324861709071/-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), ]
@@ -612,10 +622,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/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-08 [pcr_t1]
+ pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -628,17 +638,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -649,21 +660,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -676,17 +688,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -697,17 +710,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -716,9 +730,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-04-56_945_7230683149267115968/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-30_270_8932721888182592546/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-04-56_945_7230683149267115968/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-30_270_8932721888182592546/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -739,12 +753,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/nzhang/hive_2011-04-05_21-04-57_056_4209791858248998349/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-30_378_3001871383983881471/-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/nzhang/hive_2011-04-05_21-04-57_056_4209791858248998349/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-30_378_3001871383983881471/-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), ]
@@ -824,10 +838,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+ 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]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -840,17 +854,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -861,21 +876,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ pfile:/data/users/tomasz/apache-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
@@ -888,17 +904,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -909,17 +926,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -928,9 +946,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-00_228_5831869255225828862/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-33_477_4843342398582016187/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-00_228_5831869255225828862/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-33_477_4843342398582016187/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -952,13 +970,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/nzhang/hive_2011-04-05_21-05-00_333_4989277825355087551/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-33_595_7059370303120446928/-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/nzhang/hive_2011-04-05_21-05-00_333_4989277825355087551/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-33_595_7059370303120446928/-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), ]
@@ -1038,11 +1056,11 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+ 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]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -1055,17 +1073,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1076,21 +1095,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -1103,17 +1123,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1124,21 +1145,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ pfile:/data/users/tomasz/apache-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
@@ -1151,17 +1173,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1172,17 +1195,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -1191,9 +1215,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-03_835_409179175272920478/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-36_836_3051586657356094147/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-03_835_409179175272920478/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-36_836_3051586657356094147/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1216,14 +1240,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/nzhang/hive_2011-04-05_21-05-03_964_6808457543204138401/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-37_078_5128271294396999103/-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/nzhang/hive_2011-04-05_21-05-03_964_6808457543204138401/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-37_078_5128271294396999103/-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), ]
@@ -1311,11 +1335,11 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+ 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]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -1328,17 +1352,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1349,21 +1374,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -1376,17 +1402,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1397,21 +1424,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ pfile:/data/users/tomasz/apache-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
@@ -1424,17 +1452,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1445,17 +1474,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -1464,9 +1494,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-07_318_2291350301336316720/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-40_317_3482597828578299090/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-07_318_2291350301336316720/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-40_317_3482597828578299090/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1489,14 +1519,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/nzhang/hive_2011-04-05_21-05-07_429_6918784087469321838/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-40_434_156015404539012634/-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/nzhang/hive_2011-04-05_21-05-07_429_6918784087469321838/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-40_434_156015404539012634/-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), ]
@@ -1588,10 +1618,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/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-08 [pcr_t1]
+ pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -1604,17 +1634,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1625,21 +1656,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -1652,17 +1684,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1673,17 +1706,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -1692,9 +1726,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-10_812_3644022781819738746/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-43_671_9068406681245435665/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-10_812_3644022781819738746/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-43_671_9068406681245435665/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1715,12 +1749,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/nzhang/hive_2011-04-05_21-05-10_942_5582319643394362276/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-43_787_4480677150525031425/-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/nzhang/hive_2011-04-05_21-05-10_942_5582319643394362276/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-43_787_4480677150525031425/-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), ]
@@ -1779,10 +1813,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/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-08 [pcr_t1]
+ pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -1795,17 +1829,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1816,21 +1851,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -1843,17 +1879,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1864,17 +1901,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -1883,9 +1921,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-14_152_1811663463960358965/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-46_895_6528226210433167390/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-14_152_1811663463960358965/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-46_895_6528226210433167390/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1906,12 +1944,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/nzhang/hive_2011-04-05_21-05-14_278_8063853710021572577/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-47_011_5025313460613776496/-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/nzhang/hive_2011-04-05_21-05-14_278_8063853710021572577/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-47_011_5025313460613776496/-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), ]
@@ -2010,11 +2048,11 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10 [pcr_t1]
+ 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]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -2027,17 +2065,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2048,21 +2087,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -2075,17 +2115,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2096,21 +2137,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ pfile:/data/users/tomasz/apache-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
@@ -2123,17 +2165,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-10
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2144,17 +2187,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -2163,9 +2207,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-17_390_8218241996261628500/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-50_070_7918278309965809032/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-17_390_8218241996261628500/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-50_070_7918278309965809032/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2187,13 +2231,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/nzhang/hive_2011-04-05_21-05-17_499_3923962528754522723/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-50_186_7467964439268319364/-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/nzhang/hive_2011-04-05_21-05-17_499_3923962528754522723/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-50_186_7467964439268319364/-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), ]
@@ -2323,10 +2367,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
- pfile:/data/users/nzhang/work/3/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-08 [pcr_t1]
+ pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09 [pcr_t1]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -2339,17 +2383,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062681
+ transient_lastDdlTime 1306984455
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2360,21 +2405,22 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ pfile:/data/users/tomasz/apache-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
@@ -2387,17 +2433,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-09
name default.pcr_t1
numFiles 1
numPartitions 3
numRows 20
partition_columns ds
+ rawDataSize 160
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 180
- transient_lastDdlTime 1302062685
+ transient_lastDdlTime 1306984459
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2408,17 +2455,18 @@ 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/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1
+ location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1
name default.pcr_t1
numFiles 3
numPartitions 3
numRows 60
partition_columns ds
+ rawDataSize 480
serialization.ddl struct pcr_t1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 540
- transient_lastDdlTime 1302062690
+ transient_lastDdlTime 1306984463
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.pcr_t1
name: default.pcr_t1
@@ -2427,9 +2475,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/nzhang/hive_2011-04-05_21-05-20_753_4457015784894213273/-ext-10001
+ directory: file:/tmp/tomasz/hive_2011-06-01_20-14-53_371_8781736527660496822/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/nzhang/hive_2011-04-05_21-05-20_753_4457015784894213273/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_20-14-53_371_8781736527660496822/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2450,12 +2498,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/nzhang/hive_2011-04-05_21-05-20_868_2203544985953380948/-mr-10000
+PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-53_489_3007975236537851113/-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/nzhang/hive_2011-04-05_21-05-20_868_2203544985953380948/-mr-10000
+POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-14-53_489_3007975236537851113/-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), ]
@@ -2537,9 +2585,9 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [t2, t1]
+ pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [t2, t1]
Path -> Partition:
- pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08
+ pfile:/data/users/tomasz/apache-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
@@ -2552,17 +2600,18 @@ STAGE PLANS:
columns.types int:string
[... 1662 lines stripped ...]