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? |
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? |
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? |
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? > |
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? > |
Free forum by Nabble | Edit this page |