PREHOOK: query: DROP TABLE TEST3a PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE TEST3a POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE TEST3b PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE TEST3b POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE TEST3c PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE TEST3c POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE TEST3a(A INT, B DOUBLE) STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE TEST3a(A INT, B DOUBLE) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@TEST3a PREHOOK: query: DESCRIBE TEST3a PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE TEST3a POSTHOOK: type: DESCTABLE a int b double PREHOOK: query: CREATE TABLE TEST3b(A ARRAY, B DOUBLE, C MAP) STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE TEST3b(A ARRAY, B DOUBLE, C MAP) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@TEST3b PREHOOK: query: DESCRIBE TEST3b PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE TEST3b POSTHOOK: type: DESCTABLE a array b double c map 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 test3a test3b PREHOOK: query: EXPLAIN ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE) PREHOOK: type: ALTERTABLE_ADDCOLS POSTHOOK: query: EXPLAIN ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE) POSTHOOK: type: ALTERTABLE_ADDCOLS 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 PREHOOK: query: ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE) PREHOOK: type: ALTERTABLE_ADDCOLS POSTHOOK: query: ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE) POSTHOOK: type: ALTERTABLE_ADDCOLS POSTHOOK: Input: default@test3b POSTHOOK: Output: default@test3b PREHOOK: query: DESCRIBE TEST3b PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE TEST3b POSTHOOK: type: DESCTABLE a array b double c map x double PREHOOK: query: EXPLAIN ALTER TABLE TEST3b RENAME TO TEST3c PREHOOK: type: ALTERTABLE_RENAME POSTHOOK: query: EXPLAIN ALTER TABLE TEST3b RENAME TO TEST3c POSTHOOK: type: ALTERTABLE_RENAME 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 PREHOOK: query: ALTER TABLE TEST3b RENAME TO TEST3c PREHOOK: type: ALTERTABLE_RENAME POSTHOOK: query: ALTER TABLE TEST3b RENAME TO TEST3c POSTHOOK: type: ALTERTABLE_RENAME POSTHOOK: Input: default@test3b POSTHOOK: Output: default@TEST3c PREHOOK: query: DESCRIBE TEST3c PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE TEST3c POSTHOOK: type: DESCTABLE a array b double c map x double 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 test3a test3c PREHOOK: query: EXPLAIN ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE) PREHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: query: EXPLAIN ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE) POSTHOOK: type: ALTERTABLE_REPLACECOLS 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 PREHOOK: query: ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE) PREHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: query: ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@test3c POSTHOOK: Output: default@test3c PREHOOK: query: DESCRIBE EXTENDED TEST3c PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED TEST3c POSTHOOK: type: DESCTABLE r1 int r2 double Detailed Table Information Table(tableName:test3c, dbName:default, owner:njain, createTime:1269906076, 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/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/test3c, 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,last_modified_time=1269906077,transient_lastDdlTime=1269906077}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: DROP TABLE TEST3a PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE TEST3a POSTHOOK: type: DROPTABLE POSTHOOK: Output: default@test3a PREHOOK: query: DROP TABLE TEST3b PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE TEST3b POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE TEST3c PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE TEST3c POSTHOOK: type: DROPTABLE POSTHOOK: Output: default@test3c