PREHOOK: query: create table alter_partition_format_test (key int, value string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table alter_partition_format_test (key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: desc extended alter_partition_format_test PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test POSTHOOK: type: DESCTABLE key int value string Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:njain, createTime:1289949041, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/alter_partition_format_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:{transient_lastDdlTime=1289949041}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table alter_partition_format_test set fileformat rcfile PREHOOK: type: ALTERTABLE_FILEFORMAT PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test POSTHOOK: query: alter table alter_partition_format_test set fileformat rcfile POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: desc extended alter_partition_format_test PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test POSTHOOK: type: DESCTABLE key int from deserializer value string from deserializer Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:njain, createTime:1289949041, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/alter_partition_format_test, 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:{last_modified_by=njain, last_modified_time=1289949041, transient_lastDdlTime=1289949041}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table alter_partition_format_test set location "file:/test/test/" PREHOOK: type: ALTERTABLE_LOCATION PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test POSTHOOK: query: alter table alter_partition_format_test set location "file:/test/test/" POSTHOOK: type: ALTERTABLE_LOCATION POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: desc extended alter_partition_format_test PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test POSTHOOK: type: DESCTABLE key int from deserializer value string from deserializer Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:njain, createTime:1289949041, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/test/test/, 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:{last_modified_by=njain, last_modified_time=1289949042, transient_lastDdlTime=1289949042}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: drop table alter_partition_format_test PREHOOK: type: DROPTABLE PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test POSTHOOK: query: drop table alter_partition_format_test POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: --partitioned table create table alter_partition_format_test (key int, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE POSTHOOK: query: --partitioned table create table alter_partition_format_test (key int, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: alter table alter_partition_format_test add partition(ds='2010') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@alter_partition_format_test POSTHOOK: query: alter table alter_partition_format_test add partition(ds='2010') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test@ds=2010 PREHOOK: query: desc extended alter_partition_format_test partition(ds='2010') PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test partition(ds='2010') POSTHOOK: type: DESCTABLE key int value string ds string Detailed Partition Information Partition(values:[2010], dbName:default, tableName:alter_partition_format_test, createTime:1289949042, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/alter_partition_format_test/ds=2010, 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:{transient_lastDdlTime=1289949042}) PREHOOK: query: alter table alter_partition_format_test partition(ds='2010') set fileformat rcfile PREHOOK: type: ALTERPARTITION_FILEFORMAT PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test@ds=2010 POSTHOOK: query: alter table alter_partition_format_test partition(ds='2010') set fileformat rcfile POSTHOOK: type: ALTERPARTITION_FILEFORMAT POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Input: default@alter_partition_format_test@ds=2010 POSTHOOK: Output: default@alter_partition_format_test@ds=2010 PREHOOK: query: desc extended alter_partition_format_test partition(ds='2010') PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test partition(ds='2010') POSTHOOK: type: DESCTABLE key int value string ds string Detailed Partition Information Partition(values:[2010], dbName:default, tableName:alter_partition_format_test, createTime:1289949042, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/alter_partition_format_test/ds=2010, 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:{}), parameters:{last_modified_by=njain, last_modified_time=1289949042, transient_lastDdlTime=1289949042}) PREHOOK: query: alter table alter_partition_format_test partition(ds='2010') set location "file:/test/test/ds=2010" PREHOOK: type: ALTERPARTITION_LOCATION PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test@ds=2010 POSTHOOK: query: alter table alter_partition_format_test partition(ds='2010') set location "file:/test/test/ds=2010" POSTHOOK: type: ALTERPARTITION_LOCATION POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Input: default@alter_partition_format_test@ds=2010 POSTHOOK: Output: default@alter_partition_format_test@ds=2010 PREHOOK: query: desc extended alter_partition_format_test partition(ds='2010') PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test partition(ds='2010') POSTHOOK: type: DESCTABLE key int value string ds string Detailed Partition Information Partition(values:[2010], dbName:default, tableName:alter_partition_format_test, createTime:1289949042, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/test/test/ds=2010, 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:{}), parameters:{last_modified_by=njain, last_modified_time=1289949043, transient_lastDdlTime=1289949043}) PREHOOK: query: desc extended alter_partition_format_test PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test POSTHOOK: type: DESCTABLE key int value string ds string Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:njain, createTime:1289949042, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/alter_partition_format_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:[FieldSchema(name:ds, type:string, comment:null)], parameters:{transient_lastDdlTime=1289949042}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table alter_partition_format_test set fileformat rcfile PREHOOK: type: ALTERTABLE_FILEFORMAT PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test POSTHOOK: query: alter table alter_partition_format_test set fileformat rcfile POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: desc extended alter_partition_format_test PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test POSTHOOK: type: DESCTABLE key int from deserializer value string from deserializer ds string Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:njain, createTime:1289949042, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/alter_partition_format_test, 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:[FieldSchema(name:ds, type:string, comment:null)], parameters:{last_modified_by=njain, last_modified_time=1289949043, transient_lastDdlTime=1289949043}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table alter_partition_format_test set location "file:/test/test/" PREHOOK: type: ALTERTABLE_LOCATION PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test POSTHOOK: query: alter table alter_partition_format_test set location "file:/test/test/" POSTHOOK: type: ALTERTABLE_LOCATION POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test PREHOOK: query: desc extended alter_partition_format_test PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended alter_partition_format_test POSTHOOK: type: DESCTABLE key int from deserializer value string from deserializer ds string Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:njain, createTime:1289949042, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/test/test/, 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:[FieldSchema(name:ds, type:string, comment:null)], parameters:{last_modified_by=njain, last_modified_time=1289949043, transient_lastDdlTime=1289949043}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: drop table alter_partition_format_test PREHOOK: type: DROPTABLE PREHOOK: Input: default@alter_partition_format_test PREHOOK: Output: default@alter_partition_format_test POSTHOOK: query: drop table alter_partition_format_test POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@alter_partition_format_test POSTHOOK: Output: default@alter_partition_format_test