can we add partition or split partition on range partitioned tables

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

can we add partition or split partition on range partitioned tables

喜之郎
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?
Reply | Threaded
Open this post in threaded view
|

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

lionel061201
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?
Reply | Threaded
Open this post in threaded view
|

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

喜之郎
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?
Reply | Threaded
Open this post in threaded view
|

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

lionel061201
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?
>
Reply | Threaded
Open this post in threaded view
|

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

喜之郎
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?
>