回复： can we add partition or split partition on range partitioned tables

Posted by 喜之郎 on Aug 14, 2018; 2:15am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/can-we-add-partition-or-split-partition-on-range-partitioned-tables-tp59488p59529.html

Thanks for your reply.
I have refered this document before, But I can not find how to add partition for range table, I don't know how to assign
new range info.
for example, a table have had a pange info "'RANGE_INFO'='1, 100, 200, 300'", then I want to add a partition with range between 300 and 400, how to do it?


I checked the carbondata code, I can only find add partition to List table.








------------------ 原始邮件 ------------------
发件人: "Lu Cao"<[hidden email]>;
发送时间: 2018年8月14日(星期二) 上午9:34
收件人: "dev"<[hidden email]>;

主题: Re: can we add partition or split partition on range partitioned tables



Hi,
By default the value larger than max boundary you defined will fall into
the default partition. You can also use ALTER TABLE statement to add a
partition.
Pls refer to the documents in carbondata official site
http://carbondata.apache.org/data-management-on-carbondata.html

Regards,
Lionel

On Mon, Aug 13, 2018 at 2:43 PM, 喜之郎 <[hidden email]> wrote:

> hi community,
>  carbon have a range partition feature, for example：
> CREATE TABLE test_range (
> _col_a int)
> partitioned by (productid int)
> STORED BY 'carbondata'
> TBLPROPERTIES ('partition_type'='RANGE', 'RANGE_INFO'='1, 100, 200, 300')
>
>
>
> can we add a partition which store productid between  300 and 400,
> if we can, how to write this add partition sql?