PREHOOK: query: create table alter2(a int, b int) partitioned by (insertdate string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table alter2(a int, b int) partitioned by (insertdate string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter2
PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@alter2
POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2@insertdate=2008-01-01
PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@alter2
POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2@insertdate=2008-01-02
PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
insertdate=2008-01-02
PREHOOK: query: drop table alter2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter2
PREHOOK: Output: default@alter2
POSTHOOK: query: drop table alter2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2
PREHOOK: query: create external table alter2(a int, b int) partitioned by (insertdate string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create external table alter2(a int, b int) partitioned by (insertdate string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter2
PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@alter2
POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2@insertdate=2008-01-01
PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@alter2
POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2@insertdate=2008-01-02
PREHOOK: query: describe extended alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
insertdate=2008-01-02
PREHOOK: query: -- Cleanup
DROP TABLE alter2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter2
PREHOOK: Output: default@alter2
POSTHOOK: query: -- Cleanup
DROP TABLE alter2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
src
src1
src_json
src_sequencefile
src_thrift
srcbucket
srcbucket2
srcpart
PREHOOK: query: -- Using non-default Database

CREATE DATABASE alter2_db
PREHOOK: type: CREATEDATABASE
POSTHOOK: query: -- Using non-default Database

CREATE DATABASE alter2_db
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: USE alter2_db
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: USE alter2_db
POSTHOOK: type: SWITCHDATABASE
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
PREHOOK: query: CREATE TABLE alter2(a int, b int) PARTITIONED BY (insertdate string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE alter2(a int, b int) PARTITIONED BY (insertdate string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: alter2_db@alter2
PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
PREHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-01') LOCATION '2008/01/01'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: alter2_db@alter2
POSTHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-01') LOCATION '2008/01/01'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: alter2_db@alter2
POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-01
PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
PREHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-02') LOCATION '2008/01/02'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: alter2_db@alter2
POSTHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-02') LOCATION '2008/01/02'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: alter2_db@alter2
POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-02
PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
insertdate=2008-01-02
PREHOOK: query: DROP TABLE alter2
PREHOOK: type: DROPTABLE
PREHOOK: Input: alter2_db@alter2
PREHOOK: Output: alter2_db@alter2
POSTHOOK: query: DROP TABLE alter2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: alter2_db@alter2
POSTHOOK: Output: alter2_db@alter2
PREHOOK: query: CREATE EXTERNAL TABLE alter2(a int, b int) PARTITIONED BY (insertdate string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE EXTERNAL TABLE alter2(a int, b int) PARTITIONED BY (insertdate string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: alter2_db@alter2
PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
PREHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-01') LOCATION '2008/01/01'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: alter2_db@alter2
POSTHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-01') LOCATION '2008/01/01'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: alter2_db@alter2
POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-01
PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
PREHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-02') LOCATION '2008/01/02'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: alter2_db@alter2
POSTHOOK: query: ALTER TABLE alter2 ADD PARTITION (insertdate='2008-01-02') LOCATION '2008/01/02'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: alter2_db@alter2
POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-02
PREHOOK: query: DESCRIBE EXTENDED alter2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter2
POSTHOOK: type: DESCTABLE
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
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
insertdate=2008-01-02
PREHOOK: query: DROP TABLE alter2
PREHOOK: type: DROPTABLE
PREHOOK: Input: alter2_db@alter2
PREHOOK: Output: alter2_db@alter2
POSTHOOK: query: DROP TABLE alter2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: alter2_db@alter2
POSTHOOK: Output: alter2_db@alter2
PREHOOK: query: USE default
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: USE default
POSTHOOK: type: SWITCHDATABASE
PREHOOK: query: DROP DATABASE alter2_db
PREHOOK: type: DROPDATABASE
POSTHOOK: query: DROP DATABASE alter2_db
POSTHOOK: type: DROPDATABASE