[HIVE-13780] Allow user to update AVRO table schema via command even if table's definition was defined through schema file

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.3.0
• Component/s: CLI
• Assignee: Ádám Szita Assign to me
• Reporter: Eric Lin
• Created: 18/May/16 01:44
• Updated: 21/Jul/17 17:45
• Resolved: 14/Mar/17 21:43

Description

If a table is defined as below:

CREATE TABLE test
STORED AS AVRO 
TBLPROPERTIES ('avro.schema.url'='/tmp/schema.json');

if user tries to run command:

ALTER TABLE test CHANGE COLUMN col1 col1 STRING COMMENT 'test comment';

The query will return without any warning, but has no affect to the table.

It would be good if we can allow user to ALTER table (add/change column, update comment etc) even though the schema is defined through schema file.

Issue Links

• links to: ReviewBoard