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

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

ok, it works. thanks




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

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



Just add the new boundary '400' like the list partition. CarbonData will
auto merge the range list and split the data file(if exist...)

ALTER TABLE [db_name].table_name ADD PARTITION('400')

If you want to add a value less than the max boundary(e.g.  150), then you
should use 'alter table split partition' statement.
You can check 'TestAlterPartitionTable.scala' for more examples.

Regards,
Lionel

On Tue, Aug 14, 2018 at 10:15 AM, 喜之郎 <[hidden email]> wrote:

> 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?
>