query: DROP TABLE TEST3a query: DROP TABLE TEST3b query: DROP TABLE TEST3c query: CREATE TABLE TEST3a(A INT, B DOUBLE) STORED AS TEXTFILE query: DESCRIBE TEST3a a int b double query: CREATE TABLE TEST3b(A ARRAY, B DOUBLE, C MAP) STORED AS TEXTFILE query: DESCRIBE TEST3b a array b double c map query: SHOW TABLES src src1 src_json src_sequencefile src_thrift srcbucket srcpart test3a test3b query: EXPLAIN ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE) ABSTRACT SYNTAX TREE: (TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_DOUBLE))) STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Alter Table Operator: Alter Table type: add columns new columns: X double old name: TEST3b query: ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE) query: DESCRIBE TEST3b a array b double c map x double query: EXPLAIN ALTER TABLE TEST3b RENAME TO TEST3c ABSTRACT SYNTAX TREE: (TOK_ALTERTABLE_RENAME TEST3b TEST3c) STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Alter Table Operator: Alter Table type: rename new name: TEST3c old name: TEST3b query: ALTER TABLE TEST3b RENAME TO TEST3c query: DESCRIBE TEST3c a array b double c map x double query: SHOW TABLES src src1 src_json src_sequencefile src_thrift srcbucket srcpart test3a test3c query: EXPLAIN ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE) ABSTRACT SYNTAX TREE: (TOK_ALTERTABLE_REPLACECOLS TEST3c (TOK_TABCOLLIST (TOK_TABCOL R1 TOK_INT) (TOK_TABCOL R2 TOK_DOUBLE))) STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Alter Table Operator: Alter Table type: replace columns new columns: R1 int, R2 double old name: TEST3c query: ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE) query: DESCRIBE EXTENDED TEST3c r1 int r2 double Detailed Table Information Table(tableName:test3c,dbName:default,owner:athusoo,createTime:1241278187,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:double,comment:null)],location:file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/test3b,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=athusoo,last_modified_time=1241278187}) query: DROP TABLE TEST3a query: DROP TABLE TEST3b query: DROP TABLE TEST3c