Drop columns in ORC managed table

[goun na]

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