Jaehwa Jung created TAJO-2101:
---------------------------------
Summary: Support add multiple partitions in a single ALTER TABLE
statement
Key: TAJO-2101
URL: https://issues.apache.org/jira/browse/TAJO-2101
Project: Tajo
Issue Type: Sub-task
Components: Catalog, Planner/Optimizer
Reporter: Jaehwa Jung
Assignee: Jaehwa Jung
If TAJO-1891 commit, users can add partition to table using {{ALTER TABLE}}
statement. But if users want to add many partitions, they should use following
form:
{code:xml}
ALTER TABLE table_name ADD PARTITION (partCol = 'value1') location 'location1';
ALTER TABLE table_name ADD PARTITION (partCol = 'value2') location 'location2';
...
ALTER TABLE table_name ADD PARTITION (partCol = 'valueN') location 'locationN';
{code}
In general case, above approach doesn't matter. But if there are lots of
partitions, for example, more than hundreds of partitions, it may raise loss of
catalog because single statement calls single call of catalog api. Also users
may feel inconvenience for using sing statement. We need to allow following
form:
{code:xml}
ALTER TABLE page_view ADD PARTITION (dt='2016-03-01', country='kr') location
'location1'
PARTITION (dt='2016-03-02', country='kr') location 'location2';
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
