[DRILL-7168] Implement ALTER SCHEMA ADD / REMOVE COLUMN / PROPERTY commands

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.17.0
• Labels: doc-impacting ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Arina Ielchiieva
• Reviewer: Vova Vysotskyi
• Created: 11/Apr/19 16:21
• Updated: 10/Sep/19 12:53
• Resolved: 10/Sep/19 12:53

Description

By Paul.Rogers:

Sooner or later users are going to ask for a command to update just the properties, or just add or remove a column, without having to spell out the entire new schema. ALTER TABLE SCHEMA ADD/REMOVE COLUMN/PROPERTY ...

Syntax:

alter schema  
(for table dfs.tmp.nation | path '/tmp/schema.json')
add [or replace]
[columns (col1 int, col2 varchar)]
[properties ('prop1'='val1', 'prop2'='val2')]

Add command will fail if column or property with the same name exists, unless OR REPLACE keywords are indicated.
Add command will fail, if schema file does not exit.

alter schema
(for table dfs.tmp.nation | path '/tmp/schema.json')
remove
[columns (`col1`, `col2`)]
[properties ('prop1', 'prop2')]

Remove command won't fail if column or property does not exist but will fail if schema file is absent.

Issue Links

• links to: GitHub Pull Request #1850