Add Column to Hive External Table Error

Asked Dec 01 '16 at 20:17

Active Jun 22 '22 at 15:27

Viewed 2,100 times

Trying to add a column to an external table in HIVE but get the error below. This table currently has a thousand partitions registered and I want' to avoid re-creating the table and then running MSCK REPAIR which would take a very long time to complete. Also, the table uses OpenCSVSerde format. How can I add a column

    hive> ALTER TABLE schema.Table123 ADD COLUMNS (Column1000 STRING);

    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. java.lang.IllegalArgumentException: Error: type expected at the position 0 of '<derived from deserializer>' but '<' is found.

edited Sep 22 '17 at 17:48

Community

asked Dec 01 '16 at 20:17

user3250672

1

Hive alter statements does not support SCHEMA_NAME.TABLE_NAME. You have use them separately as @Rijul mentioned. – Mukesh S Dec 02 '16 at 07:56
Does not work, still get the same error. Not sure if this has something to do with the OpenCSVSerde? – user3250672 Dec 13 '16 at 03:42
**@Mukesh S** I'm able to run it with **schema** name as `ALTER TABLE \`schema\`.\`table\`..` – y2k-shubham May 25 '18 at 05:58

Add Column to Hive External Table Error

0 Answers0

Linked