@Roberto Sancho can't be dropped , you can create a new table from select query without the extra column using CTAS or 'Create table as select' http://www.dummies.com/how-to/content/how-to-use-hives-create-table-as-select-ctas.html Altering and Dropping Tables Table names can be changed and columns can be added or replaced: hive> ALTER TABLE events RENAME TO 3koobecaf;
hive> ALTER TABLE pokes ADD COLUMNS (new_col INT);
hive> ALTER TABLE invites ADD COLUMNS (new_col2 INT COMMENT 'a comment');
hive> ALTER TABLE invites REPLACE COLUMNS (foo INT, bar STRING, baz INT COMMENT 'baz replaces new_col2');
Note that REPLACE COLUMNS replaces all existing columns and only changes the table's schema, not the data. The table must use a native SerDe. REPLACE COLUMNS can also be used to drop columns from the table's schema: hive> ALTER TABLE invites REPLACE COLUMNS (foo INT COMMENT 'only keep the first column');
... View more
