You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/10/13 06:26:38 UTC
svn commit: r1021992 [3/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/...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter2.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter2.q.out Wed Oct 13 04:26:34 2010
@@ -7,39 +7,11 @@ PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:11 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/alter2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472811
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:default, owner:thiruvel, createTime:1286799434, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2, 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:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799434}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: show partitions alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions alter2
@@ -55,39 +27,11 @@ PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:11 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/alter2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472811
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:default, owner:thiruvel, createTime:1286799434, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2, 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:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799434}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: show partitions alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions alter2
@@ -104,39 +48,11 @@ PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:11 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/alter2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472811
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:default, owner:thiruvel, createTime:1286799434, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2, 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:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799434}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: show partitions alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions alter2
@@ -160,40 +76,11 @@ PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:13 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/alter2
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284472813
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:default, owner:thiruvel, createTime:1286799436, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2, 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:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286799436}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: show partitions alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions alter2
@@ -209,40 +96,11 @@ PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:13 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/alter2
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284472813
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:default, owner:thiruvel, createTime:1286799436, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2, 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:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286799436}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: show partitions alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions alter2
@@ -259,40 +117,11 @@ PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:13 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/alter2
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284472813
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:default, owner:thiruvel, createTime:1286799436, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2, 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:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286799436}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: show partitions alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions alter2
@@ -346,39 +175,11 @@ PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: alter2_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:14 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/alter2_db.db/alter2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472814
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:alter2_db, owner:thiruvel, createTime:1286799436, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2_db.db/alter2, 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:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799436}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: SHOW PARTITIONS alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS alter2
@@ -394,39 +195,11 @@ PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: alter2_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:14 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/alter2_db.db/alter2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472814
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:alter2_db, owner:thiruvel, createTime:1286799436, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2_db.db/alter2, 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:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799436}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: SHOW PARTITIONS alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS alter2
@@ -443,39 +216,11 @@ PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: alter2_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:14 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/alter2_db.db/alter2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472814
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:alter2_db, owner:thiruvel, createTime:1286799436, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2_db.db/alter2, 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:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1286799436}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: SHOW PARTITIONS alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS alter2
@@ -499,40 +244,11 @@ PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: alter2_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:15 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/alter2_db.db/alter2
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284472815
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:alter2_db, owner:thiruvel, createTime:1286799437, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2_db.db/alter2, 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:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286799437}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: SHOW PARTITIONS alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS alter2
@@ -548,40 +264,11 @@ PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: alter2_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:15 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/alter2_db.db/alter2
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284472815
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:alter2_db, owner:thiruvel, createTime:1286799437, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2_db.db/alter2, 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:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286799437}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: SHOW PARTITIONS alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS alter2
@@ -598,40 +285,11 @@ PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Partition Information
-col_name data_type comment
-
-insertdate string None
-
-# Detailed Table Information
-Database: alter2_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 07:00:15 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/alter2_db.db/alter2
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284472815
-
-# 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
+a int
+b int
+insertdate string
+Detailed Table Information Table(tableName:alter2, dbName:alter2_db, owner:thiruvel, createTime:1286799437, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter2_db.db/alter2, 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:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286799437}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: SHOW PARTITIONS alter2
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS alter2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out Wed Oct 13 04:26:34 2010
@@ -30,11 +30,11 @@ POSTHOOK: Lineage: alter3 PARTITION(pcol
PREHOOK: query: select * from alter3 where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter3@pcol1=test_part/pcol2=test_part
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-08-57_327_5944493503891814458/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-43_120_655298079586119550/-mr-10000
POSTHOOK: query: select * from alter3 where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter3@pcol1=test_part/pcol2=test_part
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-08-57_327_5944493503891814458/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-43_120_655298079586119550/-mr-10000
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_part
2 test_part test_part
@@ -57,93 +57,29 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter3_renamed
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
-col_name data_type comment
-
-col1 string None
-
-# Partition Information
-col_name data_type comment
-
-pcol1 string None
-pcol2 string None
-
-# Detailed Table Information
-Database: default
-Owner: nzhang
-CreateTime: Mon Sep 20 23:08:51 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/alter3_renamed
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 1
- numFiles 1
- last_modified_by nzhang
- last_modified_time 1285049337
- transient_lastDdlTime 1285049337
- numRows 6
- totalSize 171
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col1 string
+pcol1 string
+pcol2 string
+Detailed Table Information Table(tableName:alter3_renamed, dbName:default, owner:thiruvel, createTime:1286799819, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=thiruvel, last_modified_time=12
86799823, transient_lastDdlTime=1286799823, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: describe extended alter3_renamed partition (pCol1='test_part', pcol2='test_part')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter3_renamed partition (pCol1='test_part', pcol2='test_part')
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
-col_name data_type comment
-
-col1 string None
-
-# Partition Information
-col_name data_type comment
-
-pcol1 string None
-pcol2 string None
-
-# Detailed Partition Information
-Partition Value: [test_part, test_part]
-Database: default
-Table: alter3_renamed
-CreateTime: Mon Sep 20 23:08:56 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/alter3_renamed/pcol1=test_part/pcol2=test_part
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285049337
- numRows 6
- totalSize 171
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col1 string
+pcol1 string
+pcol2 string
+Detailed Partition Information Partition(values:[test_part, test_part], dbName:default, tableName:alter3_renamed, createTime:1286799822, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter3_renamed/pcol1=test_part/pcol2=test_part, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286799823, numRows=6, totalSize=171})
PREHOOK: query: select * from alter3_renamed where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter3_renamed@pcol1=test_part/pcol2=test_part
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-08-58_285_926659329473097768/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-43_693_1804116675095780122/-mr-10000
POSTHOOK: query: select * from alter3_renamed where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter3_renamed@pcol1=test_part/pcol2=test_part
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-08-58_285_926659329473097768/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-43_693_1804116675095780122/-mr-10000
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_part
2 test_part test_part
@@ -182,46 +118,11 @@ POSTHOOK: query: describe extended alter
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
-col_name data_type comment
-
-col1 string None
-
-# Partition Information
-col_name data_type comment
-
-pcol1 string None
-pcol2 string None
-
-# Detailed Table Information
-Database: default
-Owner: nzhang
-CreateTime: Mon Sep 20 23:08:51 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/alter3_like_renamed
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 1
- EXTERNAL FALSE
- numFiles 1
- last_modified_by nzhang
- last_modified_time 1285049344
- transient_lastDdlTime 1285049344
- numRows 6
- totalSize 171
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col1 string
+pcol1 string
+pcol2 string
+Detailed Table Information Table(tableName:alter3_like_renamed, dbName:default, owner:thiruvel, createTime:1286799819, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, EXTERNAL=FALSE, numFiles=1, last_modified_by=thiru
vel, last_modified_time=1286799827, transient_lastDdlTime=1286799827, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: -- Cleanup
DROP TABLE alter3_src
PREHOOK: type: DROPTABLE
@@ -332,11 +233,11 @@ POSTHOOK: Lineage: alter3_like PARTITION
PREHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part' AND pcol2='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: alter3_db@alter3@pcol1=test_part/pcol2=test_part
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-09-12_328_7205460480200294317/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-51_957_7684203129075677029/-mr-10000
POSTHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part' AND pcol2='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: alter3_db@alter3@pcol1=test_part/pcol2=test_part
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-09-12_328_7205460480200294317/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-51_957_7684203129075677029/-mr-10000
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
@@ -365,45 +266,11 @@ POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
-col_name data_type comment
-
-col1 string None
-
-# Partition Information
-col_name data_type comment
-
-pcol1 string None
-pcol2 string None
-
-# Detailed Table Information
-Database: alter3_db
-Owner: nzhang
-CreateTime: Mon Sep 20 23:09:06 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/alter3_db.db/alter3_renamed
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 1
- numFiles 1
- last_modified_by nzhang
- last_modified_time 1285049352
- transient_lastDdlTime 1285049352
- numRows 6
- totalSize 171
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col1 string
+pcol1 string
+pcol2 string
+Detailed Table Information Table(tableName:alter3_renamed, dbName:alter3_db, owner:thiruvel, createTime:1286799828, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=thiruvel, last_m
odified_time=1286799832, transient_lastDdlTime=1286799832, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part', pcol2='test_part')
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part', pcol2='test_part')
@@ -411,49 +278,19 @@ POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
-col_name data_type comment
-
-col1 string None
-
-# Partition Information
-col_name data_type comment
-
-pcol1 string None
-pcol2 string None
-
-# Detailed Partition Information
-Partition Value: [test_part, test_part]
-Database: alter3_db
-Table: alter3_renamed
-CreateTime: Mon Sep 20 23:09:11 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed/pcol1=test_part/pcol2=test_part
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285049352
- numRows 6
- totalSize 171
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col1 string
+pcol1 string
+pcol2 string
+Detailed Partition Information Partition(values:[test_part, test_part], dbName:alter3_db, tableName:alter3_renamed, createTime:1286799831, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed/pcol1=test_part/pcol2=test_part, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286799831, numRows=6, totalSize=171})
PREHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part' AND pcol2='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part/pcol2=test_part
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-09-13_149_6501372199049102565/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-52_273_1411551756570868359/-mr-10000
POSTHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part' AND pcol2='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part/pcol2=test_part
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-09-13_149_6501372199049102565/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-23-52_273_1411551756570868359/-mr-10000
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
@@ -500,43 +337,8 @@ POSTHOOK: Lineage: alter3 PARTITION(pcol
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
-col_name data_type comment
-
-col1 string None
-
-# Partition Information
-col_name data_type comment
-
-pcol1 string None
-pcol2 string None
-
-# Detailed Table Information
-Database: alter3_db
-Owner: nzhang
-CreateTime: Mon Sep 20 23:09:06 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/alter3_db.db/alter3_like_renamed
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 1
- EXTERNAL FALSE
- numFiles 1
- last_modified_by nzhang
- last_modified_time 1285049360
- transient_lastDdlTime 1285049360
- numRows 6
- totalSize 171
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col1 string
+pcol1 string
+pcol2 string
+Detailed Table Information Table(tableName:alter3_like_renamed, dbName:alter3_db, owner:thiruvel, createTime:1286799828, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter3_db.db/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, EXTERNAL=FALSE, numFiles=1, last_mo
dified_by=thiruvel, last_modified_time=1286799835, transient_lastDdlTime=1286799835, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out Wed Oct 13 04:26:34 2010
@@ -7,34 +7,10 @@ PREHOOK: query: DESCRIBE EXTENDED set_bu
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED set_bucketing_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:07: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/set_bucketing_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284476844
-
-# 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: 10
-Bucket Columns: [key]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key int
+value string
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:default, owner:thiruvel, createTime:1286800231, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/set_bucketing_test, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:10, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[key], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286800231}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE set_bucketing_test NOT CLUSTERED
PREHOOK: type: null
PREHOOK: Input: default@set_bucketing_test
@@ -47,36 +23,10 @@ PREHOOK: query: DESCRIBE EXTENDED set_bu
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED set_bucketing_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:07: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/set_bucketing_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476844
- transient_lastDdlTime 1284476844
-
-# 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 int
+value string
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:default, owner:thiruvel, createTime:1286800231, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/set_bucketing_test, 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=1286800231, transient_lastDdlTime=1286800231}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: -- Cleanup
DROP TABLE set_bucketing_test
PREHOOK: type: DROPTABLE
@@ -124,34 +74,10 @@ PREHOOK: query: DESCRIBE EXTENDED set_bu
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED set_bucketing_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Detailed Table Information
-Database: alter4_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:07: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/alter4_db.db/set_bucketing_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284476844
-
-# 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: 10
-Bucket Columns: [key]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key int
+value string
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:alter4_db, owner:thiruvel, createTime:1286800232, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter4_db.db/set_bucketing_test, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:10, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[key], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286800232}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE set_bucketing_test NOT CLUSTERED
PREHOOK: type: null
PREHOOK: Input: alter4_db@set_bucketing_test
@@ -164,36 +90,10 @@ PREHOOK: query: DESCRIBE EXTENDED set_bu
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED set_bucketing_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Detailed Table Information
-Database: alter4_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:07: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/alter4_db.db/set_bucketing_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476845
- transient_lastDdlTime 1284476845
-
-# 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 int
+value string
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:alter4_db, owner:thiruvel, createTime:1286800232, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter4_db.db/set_bucketing_test, 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=1286800232, transient_lastDdlTime=1286800232}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: DROP TABLE set_bucketing_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: alter4_db@set_bucketing_test