Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E236F6796 for ; Fri, 3 Jun 2011 16:46:28 +0000 (UTC) Received: (qmail 47238 invoked by uid 500); 3 Jun 2011 16:46:28 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 47202 invoked by uid 500); 3 Jun 2011 16:46:28 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 47190 invoked by uid 99); 3 Jun 2011 16:46:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Jun 2011 16:46:28 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Jun 2011 16:46:25 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 9174D2388C0E; Fri, 3 Jun 2011 16:45:41 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: 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/... Date: Fri, 03 Jun 2011 16:45:40 -0000 To: commits@hive.apache.org From: nzhang@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20110603164541.9174D2388C0E@eris.apache.org> 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 ...]