tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JaeHwa Jung (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-284) Add table partitioning entry to Catalog
Date Mon, 18 Nov 2013 04:03:31 GMT

    [ 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)

Mime
View raw message