[
https://issues.apache.org/jira/browse/TAJO-284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13825092#comment-13825092
]
JaeHwa Jung commented on TAJO-284:
----------------------------------
Thanks Hyunsik.
I modified the design as follows:
h5. PARTITION
||Column Name||Column Type||Remark||
|PARTITION_ID|int(11)| |
|PARTITION_NAME|varchar(255)|if there isn't a given partition name, Tajo needs
to name automatically. |
|TID|int(11)| |
|TYPE|char(1)|0:HASH, 1:RANGE, 2:LIST, 3:COLUMN, and so on|
|COLUMNS|varchar(255)|partition column id list which separated by comma|
|EXPRESSIONS|text|a each partition definition phase at a given query|
\\
A range partition sample is as follows:
h5. Given query
{code:xml}
CREATE TABLE sales ( member_id int, sale_amt int)
PARTITION BY RANGE (member_id)
(
PARTITION member_q1 VALUES LESS THAN (2),
PARTITION member_q2 VALUES LESS THAN (5),
PARTITION member_q3 VALUES LESS THAN (MAXVALUE)
);
{code}
h5. PARTITION #1
||Column Name||Value||
|PARTITION_ID|10|
|PARTITION_NAME|member_q1|
|TID|1|
|TYPE|1|
|COLUMNS|20|
|EXPRESSIONS|PARTITION member_q1 VALUES LESS THAN (2)|
h5. PARTITION #2
||Column Name||Value||
|PARTITION_ID|11|
|PARTITION_NAME|member_q1|
|TID|1|
|TYPE|1|
|COLUMNS|20|
|EXPRESSIONS|PARTITION member_q2 VALUES LESS THAN (5)|
h5. PARTITION #3
||Column Name||Value||
|PARTITION_ID|13|
|PARTITION_NAME|member_q1|
|TID|1|
|TYPE|1|
|COLUMNS|20|
|EXPRESSIONS| PARTITION member_q3 VALUES LESS THAN (MAXVALUE)|
> Add table partitioning entry to Catalog
> ---------------------------------------
>
> Key: TAJO-284
> URL: https://issues.apache.org/jira/browse/TAJO-284
> Project: Tajo
> Issue Type: Sub-task
> Components: catalog
> Reporter: Hyunsik Choi
> Assignee: JaeHwa Jung
> Fix For: 0.8-incubating
>
>
> To support table partitioning, Tajo catalog should supports the table
> partitioning. Each partition entry should include partition table id,
> partition key ids, partition types (i.e., hash, range, list, and key),
> partition number, min, max, and hash id.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
