Return-Path: Delivered-To: apmail-hive-commits-archive@www.apache.org Received: (qmail 64809 invoked from network); 13 Oct 2010 04:28:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 Oct 2010 04:28:21 -0000 Received: (qmail 55683 invoked by uid 500); 13 Oct 2010 04:28:21 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 55645 invoked by uid 500); 13 Oct 2010 04:28:21 -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 55625 invoked by uid 500); 13 Oct 2010 04:28:21 -0000 Delivered-To: apmail-hadoop-hive-commits@hadoop.apache.org Received: (qmail 55620 invoked by uid 99); 13 Oct 2010 04:28:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Oct 2010 04:28:21 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.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; Wed, 13 Oct 2010 04:28:07 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 7A3892388C06; Wed, 13 Oct 2010 04:26:40 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1021992 [9/13] - in /hadoop/hive/trunk: ./ contrib/src/test/results/clientpositive/ hbase-handler/src/test/queries/ hbase-handler/src/test/results/ hwi/src/test/org/apache/hadoop/hive/hwi/ jdbc/src/test/org/apache/hadoop/hive/jdbc/ ql/src/... Date: Wed, 13 Oct 2010 04:26:38 -0000 To: hive-commits@hadoop.apache.org From: nzhang@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20101013042644.7A3892388C06@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part5.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part5.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part5.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part5.q.out Wed Oct 13 04:26:34 2010 @@ -7,38 +7,10 @@ PREHOOK: query: describe extended nzhang PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended nzhang_part5 POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string None - -# Partition Information -col_name data_type comment - -value string None - -# Detailed Table Information -Database: default -Owner: nzhang -CreateTime: Tue Sep 21 00:16:35 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part5 -Table Type: MANAGED_TABLE -Table Parameters: - transient_lastDdlTime 1285053395 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string +value string +Detailed Table Information Table(tableName:nzhang_part5, dbName:default, owner:thiruvel, createTime:1286799582, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part5, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:value, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799582}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: explain insert overwrite table nzhang_part5 partition (value) select key, value from src PREHOOK: type: QUERY @@ -1341,11 +1313,11 @@ value=val_98 PREHOOK: query: select * from nzhang_part5 where value='val_0' PREHOOK: type: QUERY PREHOOK: Input: default@nzhang_part5@value=val_0 -PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-02_739_6993685440443435128/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-20-37_135_2967055930778038061/-mr-10000 POSTHOOK: query: select * from nzhang_part5 where value='val_0' POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part5@value=val_0 -POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-02_739_6993685440443435128/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-20-37_135_2967055930778038061/-mr-10000 POSTHOOK: Lineage: nzhang_part5 PARTITION(value=val_0).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part5 PARTITION(value=val_100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part5 PARTITION(value=val_103).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] @@ -1661,11 +1633,11 @@ POSTHOOK: Lineage: nzhang_part5 PARTITIO PREHOOK: query: select * from nzhang_part5 where value='val_2' PREHOOK: type: QUERY PREHOOK: Input: default@nzhang_part5@value=val_2 -PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-03_529_3084528464376724751/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-20-37_468_7815672615609060174/-mr-10000 POSTHOOK: query: select * from nzhang_part5 where value='val_2' POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part5@value=val_2 -POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-03_529_3084528464376724751/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-20-37_468_7815672615609060174/-mr-10000 POSTHOOK: Lineage: nzhang_part5 PARTITION(value=val_0).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part5 PARTITION(value=val_100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part5 PARTITION(value=val_103).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part6.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part6.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part6.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part6.q.out Wed Oct 13 04:26:34 2010 @@ -15,41 +15,12 @@ PREHOOK: query: describe extended nzhang PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended nzhang_part6 POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string default -value string default - -# Partition Information -col_name data_type comment - -ds string None -hr string None - -# Detailed Table Information -Database: default -Owner: null -CreateTime: Tue Sep 14 07:13:24 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/nzhang_part6 -Table Type: MANAGED_TABLE -Table Parameters: - EXTERNAL FALSE - transient_lastDdlTime 1284473604 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string default +value string default +ds string +hr string +Detailed Table Information Table(tableName:nzhang_part6, dbName:default, owner:null, createTime:1286799989, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part6, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=128679998 9}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: insert overwrite table nzhang_part6 partition (ds="2010-03-03", hr) select key, value, hr from srcpart where ds is not null and hr is not null PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 @@ -71,11 +42,11 @@ POSTHOOK: Lineage: nzhang_part6 PARTITIO PREHOOK: query: select * from nzhang_part6 where ds = '2010-03-03' and hr = '11' PREHOOK: type: QUERY PREHOOK: Input: default@nzhang_part6@ds=2010-03-03/hr=11 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_260_7865814790114421170/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-26-33_896_3173294056554622080/-mr-10000 POSTHOOK: query: select * from nzhang_part6 where ds = '2010-03-03' and hr = '11' POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part6@ds=2010-03-03/hr=11 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_260_7865814790114421170/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-26-33_896_3173294056554622080/-mr-10000 POSTHOOK: Lineage: nzhang_part6 PARTITION(ds=2010-03-03,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part6 PARTITION(ds=2010-03-03,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part6 PARTITION(ds=2010-03-03,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] @@ -1083,11 +1054,11 @@ POSTHOOK: Lineage: nzhang_part6 PARTITIO PREHOOK: query: select * from nzhang_part6 where ds = '2010-03-03' and hr = '12' PREHOOK: type: QUERY PREHOOK: Input: default@nzhang_part6@ds=2010-03-03/hr=12 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_494_9148794446592123412/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-26-34_103_8617093898941504396/-mr-10000 POSTHOOK: query: select * from nzhang_part6 where ds = '2010-03-03' and hr = '12' POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part6@ds=2010-03-03/hr=12 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_494_9148794446592123412/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-26-34_103_8617093898941504396/-mr-10000 POSTHOOK: Lineage: nzhang_part6 PARTITION(ds=2010-03-03,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part6 PARTITION(ds=2010-03-03,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part6 PARTITION(ds=2010-03-03,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part7.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part7.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part7.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part7.q.out Wed Oct 13 04:26:34 2010 @@ -15,41 +15,12 @@ PREHOOK: query: describe extended nzhang PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended nzhang_part7 POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string default -value string default - -# Partition Information -col_name data_type comment - -ds string None -hr string None - -# Detailed Table Information -Database: default -Owner: null -CreateTime: Tue Sep 14 07:14:05 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/nzhang_part7 -Table Type: MANAGED_TABLE -Table Parameters: - EXTERNAL FALSE - transient_lastDdlTime 1284473645 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string default +value string default +ds string +hr string +Detailed Table Information Table(tableName:nzhang_part7, dbName:default, owner:null, createTime:1286798090, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part7, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=128679809 0}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: insert overwrite table nzhang_part7 partition (ds='2010-03-03', hr='12') select key, value from srcpart where ds = '2008-04-08' and hr = '12' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 @@ -70,11 +41,11 @@ ds=2010-03-03/hr=12 PREHOOK: query: select * from nzhang_part7 where ds is not null and hr is not null PREHOOK: type: QUERY PREHOOK: Input: default@nzhang_part7@ds=2010-03-03/hr=12 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-14-08_307_1529161512865456988/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_04-54-55_696_6581080841860335202/-mr-10000 POSTHOOK: query: select * from nzhang_part7 where ds is not null and hr is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part7@ds=2010-03-03/hr=12 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-14-08_307_1529161512865456988/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_04-54-55_696_6581080841860335202/-mr-10000 POSTHOOK: Lineage: nzhang_part7 PARTITION(ds=2010-03-03,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part7 PARTITION(ds=2010-03-03,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] 238 val_238 2010-03-03 12 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out Wed Oct 13 04:26:34 2010 @@ -15,41 +15,12 @@ PREHOOK: query: describe extended nzhang PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended nzhang_part8 POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string default -value string default - -# Partition Information -col_name data_type comment - -ds string None -hr string None - -# Detailed Table Information -Database: default -Owner: null -CreateTime: Tue Sep 21 00:22:30 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part8 -Table Type: MANAGED_TABLE -Table Parameters: - EXTERNAL FALSE - transient_lastDdlTime 1285053750 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string default +value string default +ds string +hr string +Detailed Table Information Table(tableName:nzhang_part8, dbName:default, owner:null, createTime:1286798595, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part8, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=128679859 5}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: explain extended from srcpart insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08' @@ -97,9 +68,9 @@ STAGE PLANS: File Output Operator compressed: false GlobalTableId: 1 - directory: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10000 + directory: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10000 NumFilesPerFileSink: 1 - Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10000/ + Stats Publishing Key Prefix: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10000/ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -110,13 +81,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part8 + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part8 name nzhang_part8 partition_columns ds/hr serialization.ddl struct nzhang_part8 { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285053750 + transient_lastDdlTime 1286798595 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: nzhang_part8 TotalFiles: 1 @@ -139,10 +110,10 @@ STAGE PLANS: File Output Operator compressed: false GlobalTableId: 2 - directory: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10002 + directory: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10002 NumFilesPerFileSink: 1 Static Partition Specification: ds=2008-12-31/ - Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10002/ + Stats Publishing Key Prefix: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10002/ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -153,13 +124,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part8 + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part8 name nzhang_part8 partition_columns ds/hr serialization.ddl struct nzhang_part8 { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285053750 + transient_lastDdlTime 1286798595 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: nzhang_part8 TotalFiles: 1 @@ -167,12 +138,12 @@ STAGE PLANS: MultiFileSpray: false Needs Tagging: false Path -> Alias: - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart] - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [srcpart] - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [srcpart] - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [srcpart] + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart] + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [srcpart] + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [srcpart] + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [srcpart] Path -> Partition: - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 Partition base file name: hr=11 input format: org.apache.hadoop.mapred.TextInputFormat @@ -186,13 +157,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat @@ -203,17 +174,17 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart name: srcpart - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Partition base file name: hr=12 input format: org.apache.hadoop.mapred.TextInputFormat @@ -227,13 +198,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat @@ -244,17 +215,17 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart name: srcpart - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 Partition base file name: hr=11 input format: org.apache.hadoop.mapred.TextInputFormat @@ -268,13 +239,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat @@ -285,17 +256,17 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart name: srcpart - pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 Partition base file name: hr=12 input format: org.apache.hadoop.mapred.TextInputFormat @@ -309,13 +280,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat @@ -326,13 +297,13 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/srcpart + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/srcpart name srcpart partition_columns ds/hr serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285049300 + transient_lastDdlTime 1286798591 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart name: srcpart @@ -344,7 +315,7 @@ STAGE PLANS: ds hr replace: true - source: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10000 + source: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -355,20 +326,20 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part8 + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part8 name nzhang_part8 partition_columns ds/hr serialization.ddl struct nzhang_part8 { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285053750 + transient_lastDdlTime 1286798595 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: nzhang_part8 - tmp directory: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10001 + tmp directory: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10001 Stage: Stage-3 Stats-Aggr Operator - Stats Aggregation Key Prefix: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10000/ + Stats Aggregation Key Prefix: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10000/ Stage: Stage-1 Move Operator @@ -377,7 +348,7 @@ STAGE PLANS: ds 2008-12-31 hr replace: true - source: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10002 + source: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10002 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -388,20 +359,20 @@ STAGE PLANS: columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part8 + location pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part8 name nzhang_part8 partition_columns ds/hr serialization.ddl struct nzhang_part8 { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1285053750 + transient_lastDdlTime 1286798595 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: nzhang_part8 - tmp directory: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10003 + tmp directory: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10003 Stage: Stage-4 Stats-Aggr Operator - Stats Aggregation Key Prefix: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-22-30_626_3614055251733750528/-ext-10002/ + Stats Aggregation Key Prefix: pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/scratchdir/hive_2010-10-11_05-03-15_995_2260098661536645536/-ext-10002/ PREHOOK: query: from srcpart @@ -454,14 +425,14 @@ PREHOOK: Input: default@nzhang_part8@ds= PREHOOK: Input: default@nzhang_part8@ds=2008-04-08/hr=12 PREHOOK: Input: default@nzhang_part8@ds=2008-12-31/hr=11 PREHOOK: Input: default@nzhang_part8@ds=2008-12-31/hr=12 -PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-42_722_1686154939137108359/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-03-21_094_356366396228463557/-mr-10000 POSTHOOK: query: select * from nzhang_part8 where ds is not null and hr is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part8@ds=2008-04-08/hr=11 POSTHOOK: Input: default@nzhang_part8@ds=2008-04-08/hr=12 POSTHOOK: Input: default@nzhang_part8@ds=2008-12-31/hr=11 POSTHOOK: Input: default@nzhang_part8@ds=2008-12-31/hr=12 -POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-42_722_1686154939137108359/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-03-21_094_356366396228463557/-mr-10000 POSTHOOK: Lineage: nzhang_part8 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part8 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part8 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out Wed Oct 13 04:26:34 2010 @@ -15,41 +15,12 @@ PREHOOK: query: describe extended nzhang PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended nzhang_part9 POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string default -value string default - -# Partition Information -col_name data_type comment - -ds string None -hr string None - -# Detailed Table Information -Database: default -Owner: null -CreateTime: Tue Sep 21 00:22:45 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/nzhang_part9 -Table Type: MANAGED_TABLE -Table Parameters: - EXTERNAL FALSE - transient_lastDdlTime 1285053765 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string default +value string default +ds string +hr string +Detailed Table Information Table(tableName:nzhang_part9, dbName:default, owner:null, createTime:1286799061, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/nzhang_part9, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=128679906 1}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: explain from srcpart insert overwrite table nzhang_part9 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08' @@ -148,12 +119,12 @@ PREHOOK: query: select * from nzhang_par PREHOOK: type: QUERY PREHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=11 PREHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=12 -PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-54_672_6614309113250566122/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-11-06_778_2445817243586539124/-mr-10000 POSTHOOK: query: select * from nzhang_part9 where ds is not null and hr is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=11 POSTHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=12 -POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-22-54_672_6614309113250566122/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-11-06_778_2445817243586539124/-mr-10000 POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out Wed Oct 13 04:26:34 2010 @@ -18,19 +18,19 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: select * from tbl1 PREHOOK: type: QUERY PREHOOK: Input: default@tbl1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_204_5200678719528751162/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-31_476_4515339611013455991/-mr-10000 POSTHOOK: query: select * from tbl1 POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_204_5200678719528751162/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-31_476_4515339611013455991/-mr-10000 PREHOOK: query: select col from tbl1 PREHOOK: type: QUERY PREHOOK: Input: default@tbl1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_410_3116016317581246388/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-31_638_1101319849914301170/-mr-10000 POSTHOOK: query: select col from tbl1 POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_410_3116016317581246388/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-31_638_1101319849914301170/-mr-10000 PREHOOK: query: alter table tbl1 enable offline PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl1 @@ -43,36 +43,9 @@ PREHOOK: query: desc extended tbl1 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl1 POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Detailed Table Information -Database: default -Owner: thiruvel -CreateTime: Tue Sep 14 08:18:44 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: OFFLINE -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl1 -Table Type: MANAGED_TABLE -Table Parameters: - last_modified_by thiruvel - last_modified_time 1284477526 - PROTECT_MODE OFFLINE - transient_lastDdlTime 1284477526 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +Detailed Table Information Table(tableName:tbl1, dbName:default, owner:thiruvel, createTime:1286798911, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=thiruvel, last_modified_time=1286798914, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286798914}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl1 disable offline PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl1 @@ -85,51 +58,25 @@ PREHOOK: query: desc extended tbl1 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl1 POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Detailed Table Information -Database: default -Owner: thiruvel -CreateTime: Tue Sep 14 08:18:44 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl1 -Table Type: MANAGED_TABLE -Table Parameters: - last_modified_by thiruvel - last_modified_time 1284477526 - transient_lastDdlTime 1284477526 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +Detailed Table Information Table(tableName:tbl1, dbName:default, owner:thiruvel, createTime:1286798911, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=thiruvel, last_modified_time=1286798914, transient_lastDdlTime=1286798914}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: select * from tbl1 PREHOOK: type: QUERY PREHOOK: Input: default@tbl1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_071_5796000117996838565/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-34_256_3955988268350475784/-mr-10000 POSTHOOK: query: select * from tbl1 POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_071_5796000117996838565/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-34_256_3955988268350475784/-mr-10000 PREHOOK: query: select col from tbl1 PREHOOK: type: QUERY PREHOOK: Input: default@tbl1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_133_5745323122679121918/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-34_405_8359234130543394694/-mr-10000 POSTHOOK: query: select col from tbl1 POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_133_5745323122679121918/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-34_405_8359234130543394694/-mr-10000 PREHOOK: query: create table tbl2 (col string) partitioned by (p string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table tbl2 (col string) partitioned by (p string) @@ -165,19 +112,19 @@ POSTHOOK: Input: default@tbl2 PREHOOK: query: select * from tbl2 where p='p1' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-49_993_330775998736653121/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-37_067_483902882123618984/-mr-10000 POSTHOOK: query: select * from tbl2 where p='p1' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl2@p=p1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-49_993_330775998736653121/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-37_067_483902882123618984/-mr-10000 PREHOOK: query: select * from tbl2 where p='p2' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p2 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-50_113_8495177326193613878/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-37_187_7573865201096655538/-mr-10000 POSTHOOK: query: select * from tbl2 where p='p2' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl2@p=p2 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-50_113_8495177326193613878/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-37_187_7573865201096655538/-mr-10000 PREHOOK: query: alter table tbl2 partition (p='p1') enable offline PREHOOK: type: ALTERPARTITION_PROTECTMODE PREHOOK: Input: default@tbl2 @@ -192,40 +139,10 @@ PREHOOK: query: desc extended tbl2 parti PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 partition (p='p1') POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Partition Information -col_name data_type comment - -p string None - -# Detailed Partition Information -Partition Value: [p1] -Database: default -Table: tbl2 -CreateTime: Tue Sep 14 08:18:49 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: OFFLINE -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl2/p=p1 -Partition Parameters: - last_modified_by thiruvel - last_modified_time 1284477530 - PROTECT_MODE OFFLINE - transient_lastDdlTime 1284477530 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +p string +Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1286798916, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl2/p=p1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{last_modified_by=thiruvel, last_modified_time=1286798917, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286798917}) PREHOOK: query: alter table tbl2 enable offline PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl2 @@ -238,41 +155,10 @@ PREHOOK: query: desc extended tbl2 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Partition Information -col_name data_type comment - -p string None - -# Detailed Table Information -Database: default -Owner: thiruvel -CreateTime: Tue Sep 14 08:18:49 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: OFFLINE -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl2 -Table Type: MANAGED_TABLE -Table Parameters: - last_modified_by thiruvel - last_modified_time 1284477530 - PROTECT_MODE OFFLINE - transient_lastDdlTime 1284477530 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +p string +Detailed Table Information Table(tableName:tbl2, dbName:default, owner:thiruvel, createTime:1286798916, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286798917, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286798917}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl2 enable no_drop PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl2 @@ -285,41 +171,10 @@ PREHOOK: query: desc extended tbl2 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Partition Information -col_name data_type comment - -p string None - -# Detailed Table Information -Database: default -Owner: thiruvel -CreateTime: Tue Sep 14 08:18:49 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: OFFLINE,NO_DROP -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl2 -Table Type: MANAGED_TABLE -Table Parameters: - last_modified_by thiruvel - last_modified_time 1284477530 - PROTECT_MODE OFFLINE,NO_DROP - transient_lastDdlTime 1284477530 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +p string +Detailed Table Information Table(tableName:tbl2, dbName:default, owner:thiruvel, createTime:1286798916, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286798917, PROTECT_MODE=OFFLINE,NO_DROP, transient_lastDdlTime=1286798917}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl2 drop partition (p='p3') PREHOOK: type: ALTERTABLE_DROPPARTS PREHOOK: Input: default@tbl2 @@ -340,41 +195,10 @@ PREHOOK: query: desc extended tbl2 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Partition Information -col_name data_type comment - -p string None - -# Detailed Table Information -Database: default -Owner: thiruvel -CreateTime: Tue Sep 14 08:18:49 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: NO_DROP -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl2 -Table Type: MANAGED_TABLE -Table Parameters: - last_modified_by thiruvel - last_modified_time 1284477530 - PROTECT_MODE NO_DROP - transient_lastDdlTime 1284477530 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +p string +Detailed Table Information Table(tableName:tbl2, dbName:default, owner:thiruvel, createTime:1286798916, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286798917, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1286798917}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl2 disable no_drop PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl2 @@ -387,56 +211,26 @@ PREHOOK: query: desc extended tbl2 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Partition Information -col_name data_type comment - -p string None - -# Detailed Table Information -Database: default -Owner: thiruvel -CreateTime: Tue Sep 14 08:18:49 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl2 -Table Type: MANAGED_TABLE -Table Parameters: - last_modified_by thiruvel - last_modified_time 1284477531 - transient_lastDdlTime 1284477531 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +p string +Detailed Table Information Table(tableName:tbl2, dbName:default, owner:thiruvel, createTime:1286798916, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286798918, transient_lastDdlTime=1286798918}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: select * from tbl2 where p='p2' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p2 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_381_75919177097290803/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-38_066_2185936582247020299/-mr-10000 POSTHOOK: query: select * from tbl2 where p='p2' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl2@p=p2 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_381_75919177097290803/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-38_066_2185936582247020299/-mr-10000 PREHOOK: query: select col from tbl2 where p='p2' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p2 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_472_535925465163597692/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-38_143_3716448971940234870/-mr-10000 POSTHOOK: query: select col from tbl2 where p='p2' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl2@p=p2 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_472_535925465163597692/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-38_143_3716448971940234870/-mr-10000 PREHOOK: query: alter table tbl2 partition (p='p1') disable offline PREHOOK: type: ALTERPARTITION_PROTECTMODE PREHOOK: Input: default@tbl2 @@ -451,55 +245,26 @@ PREHOOK: query: desc extended tbl2 parti PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 partition (p='p1') POSTHOOK: type: DESCTABLE -col_name data_type comment - -col string None - -# Partition Information -col_name data_type comment - -p string None - -# Detailed Partition Information -Partition Value: [p1] -Database: default -Table: tbl2 -CreateTime: Tue Sep 14 08:18:49 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl2/p=p1 -Partition Parameters: - last_modified_by thiruvel - last_modified_time 1284477533 - transient_lastDdlTime 1284477533 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +col string +p string +Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1286798916, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl2/p=p1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{last_modified_by=thiruvel, last_modified_time=1286798920, transient_lastDdlTime=1286798920}) PREHOOK: query: select * from tbl2 where p='p1' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-53_931_2424791435771957392/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-40_488_6927546031831134671/-mr-10000 POSTHOOK: query: select * from tbl2 where p='p1' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl2@p=p1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-53_931_2424791435771957392/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-40_488_6927546031831134671/-mr-10000 PREHOOK: query: select col from tbl2 where p='p1' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p1 -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-54_013_1094236570501427496/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-40_571_5074072043256621472/-mr-10000 POSTHOOK: query: select col from tbl2 where p='p1' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl2@p=p1 -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-54_013_1094236570501427496/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-08-40_571_5074072043256621472/-mr-10000 PREHOOK: query: insert overwrite table tbl1 select col from tbl2 where p='p1' PREHOOK: type: QUERY PREHOOK: Input: default@tbl2@p=p1 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_bigdata.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_bigdata.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_bigdata.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_bigdata.q.out Wed Oct 13 04:26:34 2010 @@ -31,18 +31,16 @@ POSTHOOK: query: describe columnTable_Bi POSTHOOK: type: DESCTABLE POSTHOOK: Lineage: columntable_bigdata.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: columntable_bigdata.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] -col_name data_type comment - -key string from deserializer -value string from deserializer +key string from deserializer +value string from deserializer PREHOOK: query: select count(columnTable_Bigdata.key) from columnTable_Bigdata PREHOOK: type: QUERY PREHOOK: Input: default@columntable_bigdata -PREHOOK: Output: file:/tmp/jssarma/hive_2010-10-04_16-33-25_075_8537788494860858123/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_13-11-03_144_8903230502874546869/-mr-10000 POSTHOOK: query: select count(columnTable_Bigdata.key) from columnTable_Bigdata POSTHOOK: type: QUERY POSTHOOK: Input: default@columntable_bigdata -POSTHOOK: Output: file:/tmp/jssarma/hive_2010-10-04_16-33-25_075_8537788494860858123/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_13-11-03_144_8903230502874546869/-mr-10000 POSTHOOK: Lineage: columntable_bigdata.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: columntable_bigdata.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] 5005500 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_columnar.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_columnar.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_columnar.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_columnar.q.out Wed Oct 13 04:26:34 2010 @@ -31,18 +31,16 @@ POSTHOOK: query: describe columnTable POSTHOOK: type: DESCTABLE POSTHOOK: Lineage: columntable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -col_name data_type comment - -key string from deserializer -value string from deserializer +key string from deserializer +value string from deserializer PREHOOK: query: SELECT columnTable.* FROM columnTable PREHOOK: type: QUERY PREHOOK: Input: default@columntable -PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-16-53_856_5575945175837293998/-mr-10000 +PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-19-15_391_1140349792913027723/-mr-10000 POSTHOOK: query: SELECT columnTable.* FROM columnTable POSTHOOK: type: QUERY POSTHOOK: Input: default@columntable -POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-16-53_856_5575945175837293998/-mr-10000 +POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-19-15_391_1140349792913027723/-mr-10000 POSTHOOK: Lineage: columntable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 238 val_238 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out Wed Oct 13 04:26:34 2010 @@ -7,33 +7,9 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string from deserializer - -# Detailed Table Information -Database: default -Owner: nzhang -CreateTime: Tue Sep 21 00:42:27 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/rcfile_default_format -Table Type: MANAGED_TABLE -Table Parameters: - transient_lastDdlTime 1285054947 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe -InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string from deserializer +Detailed Table Information Table(tableName:rcfile_default_format, dbName:default, owner:thiruvel, createTime:1286799201, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/rcfile_default_format, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799201}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src PREHOOK: type: CREATETABLE PREHOOK: Input: default@src @@ -45,34 +21,10 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas POSTHOOK: type: DESCTABLE -col_name data_type comment - -key string from deserializer -value string from deserializer - -# Detailed Table Information -Database: default -Owner: nzhang -CreateTime: Tue Sep 21 00:42:31 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/rcfile_default_format_ctas -Table Type: MANAGED_TABLE -Table Parameters: - transient_lastDdlTime 1285054951 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe -InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string from deserializer +value string from deserializer +Detailed Table Information Table(tableName:rcfile_default_format_ctas, dbName:default, owner:thiruvel, createTime:1286799204, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/rcfile_default_format_ctas, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799204}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: CREATE TABLE rcfile_default_format_txtfile (key STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE rcfile_default_format_txtfile (key STRING) STORED AS TEXTFILE @@ -92,37 +44,9 @@ PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile POSTHOOK: type: DESCTABLE POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -col_name data_type comment - -key string None - -# Detailed Table Information -Database: default -Owner: nzhang -CreateTime: Tue Sep 21 00:42:31 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/rcfile_default_format_txtfile -Table Type: MANAGED_TABLE -Table Parameters: - numPartitions 0 - numFiles 1 - transient_lastDdlTime 1285054957 - numRows 500 - totalSize 1906 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string +Detailed Table Information Table(tableName:rcfile_default_format_txtfile, dbName:default, owner:thiruvel, createTime:1286799204, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/rcfile_default_format_txtfile, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{numPartitions=0, numFiles=1, transient_lastDdlTime=1286799207, numRows=500, totalSize=1906}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas PREHOOK: type: CREATETABLE PREHOOK: Input: default@rcfile_default_format_ctas @@ -136,31 +60,7 @@ PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas POSTHOOK: type: DESCTABLE POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -col_name data_type comment - -key string None -value string None - -# Detailed Table Information -Database: default -Owner: nzhang -CreateTime: Tue Sep 21 00:42:41 PDT 2010 -LastAccessTime: Wed Dec 31 16:00:00 PST 1969 -Protect Mode: None -Retention: 0 -Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/textfile_default_format_ctas -Table Type: MANAGED_TABLE -Table Parameters: - transient_lastDdlTime 1285054961 - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 +key string +value string +Detailed Table Information Table(tableName:textfile_default_format_ctas, dbName:default, owner:thiruvel, createTime:1286799209, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/textfile_default_format_ctas, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799209}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)