ok, it works. thanks
------------------ ???????? ------------------ ??????: "Lu Cao"<[email protected]>; ????????: 2018??8??14??(??????) ????10:27 ??????: "dev"<[email protected]>; ????: 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, ?????? <[email protected]> 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"<[email protected]>; > ????????: 2018??8??14??(??????) ????9:34 > ??????: "dev"<[email protected]>; > > ????: 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, ?????? <[email protected]> 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? >
