hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r941131 - in /hadoop/hive/trunk: CHANGES.txt metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java ql/src/test/queries/clientpositive/alter1.q ql/src/test/results/clientpositive/alter1.q.out
Date Wed, 05 May 2010 01:33:30 GMT
Author: namit
Date: Wed May  5 01:33:30 2010
New Revision: 941131

URL: http://svn.apache.org/viewvc?rev=941131&view=rev
Log:
HIVE-1329. alter table to external does not change table_type to external
(John Sichi via namit)


Modified:
    hadoop/hive/trunk/CHANGES.txt
    hadoop/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
    hadoop/hive/trunk/ql/src/test/queries/clientpositive/alter1.q
    hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out

Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=941131&r1=941130&r2=941131&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Wed May  5 01:33:30 2010
@@ -407,6 +407,9 @@ Trunk -  Unreleased
     differnet format
     (Namit Jain via Ning Zhang)
 
+    HIVE-1329. alter table to external does not change table_type to external
+    (John Sichi via namit)
+
 Release 0.5.0 -  Unreleased
 
   INCOMPATIBLE CHANGES

Modified: hadoop/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java?rev=941131&r1=941130&r2=941131&view=diff
==============================================================================
--- hadoop/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
(original)
+++ hadoop/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
Wed May  5 01:33:30 2010
@@ -641,12 +641,28 @@ public class ObjectStore implements RawS
       throw new InvalidObjectException("Database " + tbl.getDbName()
           + " doesn't exsit.");
     }
+
+    // If the table has property EXTERNAL set, update table type
+    // accordingly
+    String tableType = tbl.getTableType();
+    boolean isExternal = "TRUE".equals(tbl.getParameters().get("EXTERNAL"));
+    if (TableType.MANAGED_TABLE.toString().equals(tableType)) {
+      if (isExternal) {
+        tableType = TableType.EXTERNAL_TABLE.toString();
+      }
+    }
+    if (TableType.EXTERNAL_TABLE.toString().equals(tableType)) {
+      if (!isExternal) {
+        tableType = TableType.MANAGED_TABLE.toString();
+      }
+    }
+
     return new MTable(tbl.getTableName().toLowerCase(), mdb,
         convertToMStorageDescriptor(tbl.getSd()), tbl.getOwner(), tbl
             .getCreateTime(), tbl.getLastAccessTime(), tbl.getRetention(),
         convertToMFieldSchemas(tbl.getPartitionKeys()), tbl.getParameters(),
         tbl.getViewOriginalText(), tbl.getViewExpandedText(),
-        tbl.getTableType());
+        tableType);
   }
 
   private List<MFieldSchema> convertToMFieldSchemas(List<FieldSchema> keys) {
@@ -940,6 +956,7 @@ public class ObjectStore implements RawS
       oldt.setDatabase(newt.getDatabase());
       oldt.setRetention(newt.getRetention());
       oldt.setPartitionKeys(newt.getPartitionKeys());
+      oldt.setTableType(newt.getTableType());
 
       // commit the changes
       success = commitTransaction();

Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/alter1.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/alter1.q?rev=941131&r1=941130&r2=941131&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/alter1.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/alter1.q Wed May  5 01:33:30 2010
@@ -6,6 +6,11 @@ describe extended alter1;
 alter table alter1 set tblproperties ('a'='1', 'c'='4', 'd'='3');
 describe extended alter1;
 
+alter table alter1 set tblproperties ('EXTERNAL'='TRUE');
+describe extended alter1;
+alter table alter1 set tblproperties ('EXTERNAL'='FALSE');
+describe extended alter1;
+
 alter table alter1 set serdeproperties('s1'='9');
 describe extended alter1;
 alter table alter1 set serdeproperties('s1'='10', 's2' ='20');

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out?rev=941131&r1=941130&r2=941131&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out Wed May  5 01:33:30
2010
@@ -14,7 +14,7 @@ POSTHOOK: type: DESCTABLE
 a	int	
 b	int	
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1,
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:{})	
+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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=1272933245}, viewOriginalText:null, viewExpandedText:null,
tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='3')
 PREHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='3')
@@ -28,7 +28,7 @@ POSTHOOK: type: DESCTABLE
 a	int	
 b	int	
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1,
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,c=3,last_modified_time=1253779698,a=1})	
+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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=jsichi,c=3,last_modified_time=1272933245,a=1,transient_lastDdlTime=1272933245},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='4', 'd'='3')
 PREHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='4', 'd'='3')
@@ -42,7 +42,35 @@ POSTHOOK: type: DESCTABLE
 a	int	
 b	int	
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1,
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:{d=3,last_modified_by=njain,c=4,last_modified_time=1253779698,a=1})	
+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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:{d=3,last_modified_by=jsichi,c=4,last_modified_time=1272933245,a=1,transient_lastDdlTime=1272933245},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
+PREHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='TRUE')
+PREHOOK: type: ALTERTABLE_PROPERTIES
+POSTHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='TRUE')
+POSTHOOK: type: ALTERTABLE_PROPERTIES
+POSTHOOK: Input: default@alter1
+POSTHOOK: Output: default@alter1
+PREHOOK: query: describe extended alter1
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended alter1
+POSTHOOK: type: DESCTABLE
+a	int	
+b	int	
+	 	 
+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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:{d=3,EXTERNAL=TRUE,last_modified_by=jsichi,c=4,last_modified_time=1272933245,a=1,transient_lastDdlTime=1272933245},
viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
+PREHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='FALSE')
+PREHOOK: type: ALTERTABLE_PROPERTIES
+POSTHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='FALSE')
+POSTHOOK: type: ALTERTABLE_PROPERTIES
+POSTHOOK: Input: default@alter1
+POSTHOOK: Output: default@alter1
+PREHOOK: query: describe extended alter1
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended alter1
+POSTHOOK: type: DESCTABLE
+a	int	
+b	int	
+	 	 
+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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:{d=3,EXTERNAL=FALSE,last_modified_by=jsichi,c=4,last_modified_time=1272933246,a=1,transient_lastDdlTime=1272933246},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 set serdeproperties('s1'='9')
 PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
 POSTHOOK: query: alter table alter1 set serdeproperties('s1'='9')
@@ -56,7 +84,7 @@ POSTHOOK: type: DESCTABLE
 a	int	
 b	int	
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1,
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:{s1=9,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[],
parameters:{d=3,last_modified_by=njain,c=4,last_modified_time=1253779698,a=1})	
+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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:{s1=9,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[],
parameters:{d=3,EXTERNAL=FALSE,last_modified_by=jsichi,c=4,last_modified_time=1272933246,a=1,transient_lastDdlTime=1272933246},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 set serdeproperties('s1'='10', 's2' ='20')
 PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
 POSTHOOK: query: alter table alter1 set serdeproperties('s1'='10', 's2' ='20')
@@ -70,7 +98,7 @@ POSTHOOK: type: DESCTABLE
 a	int	
 b	int	
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1,
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:{s2=20,s1=10,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{d=3,last_modified_by=njain,c=4,last_modified_time=1253779698,a=1})

+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null),
FieldSchema(name:b, type:int, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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:{s2=20,s1=10,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{d=3,EXTERNAL=FALSE,last_modified_by=jsichi,c=4,last_modified_time=1272933246,a=1,transient_lastDdlTime=1272933246},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.TestSerDe' with
serdeproperties('s1'='9')
 PREHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.TestSerDe' with
serdeproperties('s1'='9')
@@ -84,7 +112,7 @@ POSTHOOK: type: DESCTABLE
 a	string	from deserializer
 b	string	from deserializer
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string,
comment:from deserializer), FieldSchema(name:b, type:string, comment:from deserializer)],
location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1, 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.TestSerDe,
parameters:{s2=20,s1=9,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{d=3,last_modified_by=njain,c=4,last_modified_time=1253779698,a=1})

+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:from
deserializer), FieldSchema(name:b, type:int, comment:from deserializer)], location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1,
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.TestSerDe,
parameters:{s2=20,s1=9,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{d=3,EXTERNAL=FALSE,last_modified_by=jsichi,c=4,last_modified_time=1272933246,a=1,transient_lastDdlTime=1272933246},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
 PREHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
@@ -98,7 +126,7 @@ POSTHOOK: type: DESCTABLE
 a	string	from deserializer
 b	string	from deserializer
 	 	 
-Detailed Table Information	Table(tableName:alter1, dbName:default, owner:njain, createTime:1253779697,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string,
comment:from deserializer), FieldSchema(name:b, type:string, comment:from deserializer)],
location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/alter1, 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:{s2=20,s1=9,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{d=3,last_modified_by=njain,c=4,last_modified_time=1253779698,a=1})

+Detailed Table Information	Table(tableName:alter1, dbName:default, owner:jsichi, createTime:1272933245,
lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string,
comment:from deserializer), FieldSchema(name:b, type:string, comment:from deserializer)],
location:file:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/alter1, 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:{s2=20,s1=9,serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{d=3,EXTERNAL=FALSE,last_modified_by=jsichi,c=4,last_modified_time=1272933246,a=1,transient_lastDdlTime=1272933246},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 PREHOOK: query: alter table alter1 replace columns (a int, b int, c string)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: query: alter table alter1 replace columns (a int, b int, c string)



Mime
View raw message