You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/09/20 22:22:25 UTC
svn commit: r999101 [8/9] - in /hadoop/hive/trunk: ./
contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/
hwi/src/test/org/apache/hadoop/hive/hwi/
jdbc/src/test/org/apache/hadoop/hive/jdbc/
ql/src/java/org/apache/hadoop/hive/ql/exe...
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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -15,12 +15,41 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part6
POSTHOOK: type: DESCTABLE
-key string default
-value string default
-ds string
-hr string
+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
-Detailed Table Information Table(tableName:nzhang_part6, dbName:default, owner:null, createTime:1281476394, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/heyongqiang/hive-trunk-clean/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=1281476394}, 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
@@ -42,11 +71,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/heyongqiang/hive_2010-08-10_14-39-57_588_3134302625586003902/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_260_7865814790114421170/-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/heyongqiang/hive_2010-08-10_14-39-57_588_3134302625586003902/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_260_7865814790114421170/-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), ]
@@ -1054,11 +1083,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/heyongqiang/hive_2010-08-10_14-39-57_846_2567995546766265811/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_494_9148794446592123412/-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/heyongqiang/hive_2010-08-10_14-39-57_846_2567995546766265811/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-13-27_494_9148794446592123412/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -15,12 +15,41 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part7
POSTHOOK: type: DESCTABLE
-key string default
-value string default
-ds string
-hr string
+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
-Detailed Table Information Table(tableName:nzhang_part7, dbName:default, owner:null, createTime:1281476398, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/heyongqiang/hive-trunk-clean/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=1281476398}, 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
@@ -41,11 +70,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/heyongqiang/hive_2010-08-10_14-40-05_864_1859619194376685288/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-14-08_307_1529161512865456988/-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/heyongqiang/hive_2010-08-10_14-40-05_864_1859619194376685288/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-14-08_307_1529161512865456988/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -15,12 +15,41 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part8
POSTHOOK: type: DESCTABLE
-key string default
-value string default
-ds string
-hr string
+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:42 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_part8
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284473682
+
+# 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
-Detailed Table Information Table(tableName:nzhang_part8, dbName:default, owner:null, createTime:1281476407, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/heyongqiang/hive-trunk-clean/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=1281476407}, 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'
@@ -65,7 +94,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-40-07_257_9168405860452294864/-ext-10000
+ directory: pfile:/home/thiruvel/projects/hive/hive/build/ql/scratchdir/hive_2010-09-14_07-14-42_202_4241678664810185333/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -77,13 +106,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/nzhang_part8
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281476407
+ transient_lastDdlTime 1284473682
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: nzhang_part8
TotalFiles: 1
@@ -105,7 +134,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 2
- directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-40-07_257_9168405860452294864/-ext-10002
+ directory: pfile:/home/thiruvel/projects/hive/hive/build/ql/scratchdir/hive_2010-09-14_07-14-42_202_4241678664810185333/-ext-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -117,25 +146,25 @@ 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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/nzhang_part8
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281476407
+ transient_lastDdlTime 1284473682
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: nzhang_part8
TotalFiles: 1
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart]
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [srcpart]
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [srcpart]
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [srcpart]
+ pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart]
+ pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [srcpart]
+ pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [srcpart]
+ pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [srcpart]
Path -> Partition:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/home/thiruvel/projects/hive/hive/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
@@ -149,13 +178,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -166,17 +195,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/home/thiruvel/projects/hive/hive/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
@@ -190,13 +219,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -207,17 +236,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ pfile:/home/thiruvel/projects/hive/hive/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
@@ -231,13 +260,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -248,17 +277,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ pfile:/home/thiruvel/projects/hive/hive/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
@@ -272,13 +301,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -289,13 +318,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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281474268
+ transient_lastDdlTime 1284473678
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -307,7 +336,7 @@ STAGE PLANS:
ds
hr
replace: true
- source: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-40-07_257_9168405860452294864/-ext-10000
+ source: pfile:/home/thiruvel/projects/hive/hive/build/ql/scratchdir/hive_2010-09-14_07-14-42_202_4241678664810185333/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -318,16 +347,16 @@ 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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/nzhang_part8
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281476407
+ transient_lastDdlTime 1284473682
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: nzhang_part8
- tmp directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-40-07_257_9168405860452294864/-ext-10001
+ tmp directory: pfile:/home/thiruvel/projects/hive/hive/build/ql/scratchdir/hive_2010-09-14_07-14-42_202_4241678664810185333/-ext-10001
Stage: Stage-1
Move Operator
@@ -336,7 +365,7 @@ STAGE PLANS:
ds 2008-12-31
hr
replace: true
- source: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-40-07_257_9168405860452294864/-ext-10002
+ source: pfile:/home/thiruvel/projects/hive/hive/build/ql/scratchdir/hive_2010-09-14_07-14-42_202_4241678664810185333/-ext-10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -347,16 +376,16 @@ 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/heyongqiang/hive-trunk-clean/build/ql/test/data/warehouse/nzhang_part8
+ location pfile:/home/thiruvel/projects/hive/hive/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 1281476407
+ transient_lastDdlTime 1284473682
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: nzhang_part8
- tmp directory: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-40-07_257_9168405860452294864/-ext-10003
+ tmp directory: pfile:/home/thiruvel/projects/hive/hive/build/ql/scratchdir/hive_2010-09-14_07-14-42_202_4241678664810185333/-ext-10003
PREHOOK: query: from srcpart
@@ -409,14 +438,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/heyongqiang/hive_2010-08-10_14-40-11_367_1973645086363900348/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-14-47_080_4674138694548640892/-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/heyongqiang/hive_2010-08-10_14-40-11_367_1973645086363900348/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-14-47_080_4674138694548640892/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -15,12 +15,41 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part9
POSTHOOK: type: DESCTABLE
-key string default
-value string default
-ds string
-hr string
+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:15:19 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_part9
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284473719
+
+# 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
-Detailed Table Information Table(tableName:nzhang_part9, dbName:default, owner:null, createTime:1281476412, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/heyongqiang/hive-trunk-clean/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=1281476412}, 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'
@@ -115,12 +144,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/heyongqiang/hive_2010-08-10_14-40-15_780_650724952014850980/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-15-22_688_3998083922561230101/-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/heyongqiang/hive_2010-08-10_14-40-15_780_650724952014850980/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-15-22_688_3998083922561230101/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 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/njain/hive_2010-09-12_13-56-01_521_1064444079313286790/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_204_5200678719528751162/-mr-10000
POSTHOOK: query: select * from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-01_521_1064444079313286790/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_204_5200678719528751162/-mr-10000
PREHOOK: query: select col from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-01_868_8633104453520411771/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_410_3116016317581246388/-mr-10000
POSTHOOK: query: select col from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-01_868_8633104453520411771/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-44_410_3116016317581246388/-mr-10000
PREHOOK: query: alter table tbl1 enable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl1
@@ -43,9 +43,36 @@ PREHOOK: query: desc extended tbl1
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl1
POSTHOOK: type: DESCTABLE
-col string
+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
-Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1284324961, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324965, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1284324965}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl1 disable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl1
@@ -58,25 +85,51 @@ PREHOOK: query: desc extended tbl1
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl1
POSTHOOK: type: DESCTABLE
-col string
+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
-Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1284324961, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324965, transient_lastDdlTime=1284324965}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: select * from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-05_819_8890858681292563426/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_071_5796000117996838565/-mr-10000
POSTHOOK: query: select * from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-05_819_8890858681292563426/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_071_5796000117996838565/-mr-10000
PREHOOK: query: select col from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-05_969_128056030143576927/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_133_5745323122679121918/-mr-10000
POSTHOOK: query: select col from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-05_969_128056030143576927/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-47_133_5745323122679121918/-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)
@@ -112,19 +165,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/njain/hive_2010-09-12_13-56-10_110_1357711074681566433/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-49_993_330775998736653121/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-10_110_1357711074681566433/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-49_993_330775998736653121/-mr-10000
PREHOOK: query: select * from tbl2 where p='p2'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p2
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-10_401_4217982769570687966/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-50_113_8495177326193613878/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p2
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-10_401_4217982769570687966/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-50_113_8495177326193613878/-mr-10000
PREHOOK: query: alter table tbl2 partition (p='p1') enable offline
PREHOOK: type: ALTERPARTITION_PROTECTMODE
PREHOOK: Input: default@tbl2
@@ -139,10 +192,40 @@ PREHOOK: query: desc extended tbl2 parti
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl2 partition (p='p1')
POSTHOOK: type: DESCTABLE
-col string
-p string
+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
-Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1284324969, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324970, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1284324970})
PREHOOK: query: alter table tbl2 enable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl2
@@ -155,10 +238,41 @@ PREHOOK: query: desc extended tbl2
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl2
POSTHOOK: type: DESCTABLE
-col string
-p string
+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
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1284324969, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324971, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1284324971}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl2 enable no_drop
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl2
@@ -171,10 +285,41 @@ PREHOOK: query: desc extended tbl2
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl2
POSTHOOK: type: DESCTABLE
-col string
-p string
+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
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1284324969, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324971, PROTECT_MODE=OFFLINE,NO_DROP, transient_lastDdlTime=1284324971}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl2 drop partition (p='p3')
PREHOOK: type: ALTERTABLE_DROPPARTS
PREHOOK: Input: default@tbl2
@@ -195,10 +340,41 @@ PREHOOK: query: desc extended tbl2
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl2
POSTHOOK: type: DESCTABLE
-col string
-p string
+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
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1284324969, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324971, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1284324971}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl2 disable no_drop
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl2
@@ -211,26 +387,56 @@ PREHOOK: query: desc extended tbl2
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl2
POSTHOOK: type: DESCTABLE
-col string
-p string
+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
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1284324969, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324972, transient_lastDdlTime=1284324972}, 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/njain/hive_2010-09-12_13-56-12_162_5488456688805727075/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_381_75919177097290803/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p2
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-12_162_5488456688805727075/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_381_75919177097290803/-mr-10000
PREHOOK: query: select col from tbl2 where p='p2'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p2
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-12_384_4452747557336253545/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_472_535925465163597692/-mr-10000
POSTHOOK: query: select col from tbl2 where p='p2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p2
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-12_384_4452747557336253545/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-51_472_535925465163597692/-mr-10000
PREHOOK: query: alter table tbl2 partition (p='p1') disable offline
PREHOOK: type: ALTERPARTITION_PROTECTMODE
PREHOOK: Input: default@tbl2
@@ -245,26 +451,55 @@ PREHOOK: query: desc extended tbl2 parti
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl2 partition (p='p1')
POSTHOOK: type: DESCTABLE
-col string
-p string
+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
-Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1284324969, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/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=njain, last_modified_time=1284324975, transient_lastDdlTime=1284324975})
PREHOOK: query: select * from tbl2 where p='p1'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p1
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-15_878_9044575727084946986/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-53_931_2424791435771957392/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-15_878_9044575727084946986/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-53_931_2424791435771957392/-mr-10000
PREHOOK: query: select col from tbl2 where p='p1'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p1
-PREHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-16_089_5658301458151509169/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-54_013_1094236570501427496/-mr-10000
POSTHOOK: query: select col from tbl2 where p='p1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p1
-POSTHOOK: Output: file:/tmp/njain/hive_2010-09-12_13-56-16_089_5658301458151509169/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-18-54_013_1094236570501427496/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -31,16 +31,18 @@ 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), ]
-key string from deserializer
-value string from deserializer
+col_name data_type comment
+
+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-07-21_11-48-04_694_763065487220152863/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-16-04_020_3830957675073157960/-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-07-21_11-48-04_694_763065487220152863/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-16-04_020_3830957675073157960/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -31,16 +31,18 @@ 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), ]
-key string from deserializer
-value string from deserializer
+col_name data_type comment
+
+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/jssarma/hive_2010-07-21_11-48-15_409_223543948857251615/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-16-53_856_5575945175837293998/-mr-10000
POSTHOOK: query: SELECT columnTable.* FROM columnTable
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columntable
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-15_409_223543948857251615/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_07-16-53_856_5575945175837293998/-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=999101&r1=999100&r2=999101&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 Mon Sep 20 20:22:22 2010
@@ -7,9 +7,33 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format
POSTHOOK: type: DESCTABLE
-key string from deserializer
+col_name data_type comment
+
+key string from deserializer
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:20:03 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/rcfile_default_format
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477603
+
+# 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
-Detailed Table Information Table(tableName:rcfile_default_format, dbName:default, owner:jssarma, createTime:1279738095, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/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=1279738095}, 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
@@ -21,10 +45,34 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
POSTHOOK: type: DESCTABLE
-key string from deserializer
-value string from deserializer
+col_name data_type comment
+
+key string from deserializer
+value string from deserializer
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:20: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/rcfile_default_format_ctas
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477605
+
+# 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
-Detailed Table Information Table(tableName:rcfile_default_format_ctas, dbName:default, owner:jssarma, createTime:1279738098, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/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=1279738098}, 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
@@ -44,9 +92,33 @@ 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), ]
-key string
+col_name data_type comment
+
+key string None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:20:06 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/rcfile_default_format_txtfile
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477608
+
+# 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
-Detailed Table Information Table(tableName:rcfile_default_format_txtfile, dbName:default, owner:jssarma, createTime:1279738098, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/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:{transient_lastDdlTime=1279738100}, 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
@@ -60,7 +132,31 @@ 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), ]
-key string
-value string
+col_name data_type comment
+
+key string None
+value string None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:20:10 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/textfile_default_format_ctas
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477610
+
+# 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
-Detailed Table Information Table(tableName:textfile_default_format_ctas, dbName:default, owner:jssarma, createTime:1279738103, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/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=1279738103}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out Mon Sep 20 20:22:22 2010
@@ -7,9 +7,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a int
-b int
-c int
+col_name data_type comment
+
+a int None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a STRING
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -22,9 +24,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a string
-b int
-c int
+col_name data_type comment
+
+a string None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -37,9 +41,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a1 int
-b int
-c int
+col_name data_type comment
+
+a1 int None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -52,9 +58,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a2 int
-b int
-c int
+col_name data_type comment
+
+a2 int None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -67,9 +75,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-b int
-a int
-c int
+col_name data_type comment
+
+b int None
+a int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1'
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -82,9 +92,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-b int
-a1 int test comment1
-c int
+col_name data_type comment
+
+b int None
+a1 int test comment1
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -97,9 +109,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a2 int test comment2
-b int
-c int
+col_name data_type comment
+
+a2 int test comment2
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@kv_rename_test
@@ -112,9 +126,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-b int
-a int test comment2
-c int
+col_name data_type comment
+
+b int None
+a int test comment2
+c int None
PREHOOK: query: DROP TABLE kv_rename_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@kv_rename_test
@@ -154,9 +170,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a int
-b int
-c int
+col_name data_type comment
+
+a int None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a STRING
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -169,9 +187,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a string
-b int
-c int
+col_name data_type comment
+
+a string None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -184,9 +204,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a1 int
-b int
-c int
+col_name data_type comment
+
+a1 int None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -199,9 +221,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a2 int
-b int
-c int
+col_name data_type comment
+
+a2 int None
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -214,9 +238,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-b int
-a int
-c int
+col_name data_type comment
+
+b int None
+a int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1'
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -229,9 +255,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-b int
-a1 int test comment1
-c int
+col_name data_type comment
+
+b int None
+a1 int test comment1
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -244,9 +272,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-a2 int test comment2
-b int
-c int
+col_name data_type comment
+
+a2 int test comment2
+b int None
+c int None
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: kv_rename_test_db@kv_rename_test
@@ -259,9 +289,11 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-b int
-a int test comment2
-c int
+col_name data_type comment
+
+b int None
+a int test comment2
+c int None
PREHOOK: query: DROP TABLE kv_rename_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: kv_rename_test_db@kv_rename_test