You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by goun na <go...@gmail.com> on 2016/01/25 06:44:27 UTC

Drop columns in ORC managed table

Hi users,

The following drop column syntax does not work.

> alter table test_db.test_table drop column col_1;
FAILED: ParseException line 1:41 mismatched input 'column' expecting
PARTITION near 'drop' in drop partition statement

According to Hive manual, REPLACE COLUMNS can be used to drop columns and
it will remove columns in schema. Is it the best way to drop columns in ORC
managed table? I would like to see changes in both schema and data.

Thanks,
Goun