Eric Lin created HIVE-13780:
-------------------------------

             Summary: Allow user to update AVRO table schema via command even 
if table's definition was defined through schema file
                 Key: HIVE-13780
                 URL: https://issues.apache.org/jira/browse/HIVE-13780
             Project: Hive
          Issue Type: Improvement
          Components: CLI
    Affects Versions: 2.0.0
            Reporter: Eric Lin
            Priority: Minor


If a table is defined as below:

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

if user tries to run command:

{code}
ALTER TABLE test CHANGE COLUMN col1 col1 STRING COMMENT 'test comment';
{code}

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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to