[
https://issues.apache.org/jira/browse/TAJO-284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13825190#comment-13825190
]
JaeHwa Jung commented on TAJO-284:
----------------------------------
OK. I understood your opinion at last.
I modified the design again 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 value 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|2|
h5. PARTITION #2
||Column Name||Value||
|PARTITION_ID|11|
|PARTITION_NAME|member_q2|
|TID|1|
|TYPE|1|
|COLUMNS|20|
|EXPRESSIONS|5|
h5. PARTITION #3
||Column Name||Value||
|PARTITION_ID|12|
|PARTITION_NAME|member_q3|
|TID|1|
|TYPE|1|
|COLUMNS|20|
|EXPRESSIONS|MAXVALUE|
\\
A list partition sample is as follows:
h5. Given query
{code:xml}
CREATE TABLE areas ( area_name text, area_id int)
PARTITION BY LIST (area_name)
(
PARTITION partition_area_q1 VALUES ('Seoul', '서울'),
PARTITION partition_area_q2 VALUES ('Busan', '부산')
);
{code}
h5. PARTITION #1
||Column Name||Value||
|PARTITION_ID|20|
|PARTITION_NAME|partition_area_q1|
|TID|2|
|TYPE|2|
|COLUMNS|22|
|EXPRESSIONS|'Seoul', '서울'|
h5. PARTITION #2
||Column Name||Value||
|PARTITION_ID|21|
|PARTITION_NAME|partition_area_q2|
|TID|2|
|TYPE|2|
|COLUMNS|22|
|EXPRESSIONS|'Busan', '부산'|
> 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)
