Hyunsik Choi created TAJO-744:
---------------------------------
Summary: ALTER TABLE ADD/DROP PARTITION statement
Key: TAJO-744
URL: https://issues.apache.org/jira/browse/TAJO-744
Project: Tajo
Issue Type: New Feature
Components: catalog
Affects Versions: 1.0-incubating
Reporter: Hyunsik Choi
Fix For: 1.0-incubating
Currently, Tajo does not manage partitioned directly. In Tajo, each partition
is just a directory. For each query, a logical planner traverses matched
directories in HDFS according to partition predicates.
This approach is not efficient especially in the environment where the number
of partitions are very large. It also makes partition management hard.
Tajo should manage partitions directly by using ALTER TABLE ADD/DROP PARTITION
statements. A number of partition entries should be stored in the underlying
database that catalog uses.
{code:title=Synopsis of ALTER TABLE ADD/DROP PARTITION}
ALTER TABLE table_name [IF NOT EXISTS] ADD COLUMN PARTITION (key1 = 'val2',
key2 = 'val2', ...) WITH ('prop_key' = 'prop_val', ...) LOCATION '...';
ALTER TABLE table_name [IF EXISTS] DROP COLUMN PARTITION (key1
[=|<|<=|>|>=|!=] 'val1');
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
