Hadoop Hive How to drop a table

Question

I run this to drop the table:

ALTER TABLE table_name drop  col_name;

but I am getting the following error:

Error occurred executing hive query: OK FAILED: ParseException line 1:35 mismatched input 'user_id1' expecting PARTITION near 'drop' in drop partition statement

Answer 1

You cannot drop column directly from a table. This is how you should do it:

 ALTER TABLE emp REPLACE COLUMNS( name string, dept string);