Feasibility of altering table partition

CrateDB
1

Hello Team,
Can you let me know if it is feasible to alter table’s partition if table has millions of partitioned data ?
If it is possible than what happen with old partitioned data.
Thanks in advance.

2

Hi @kkhatri

What do you mean by altering the partition?
Changing the number of shards typically shouldn’t be a problem.

3

Not for shards.
let me give scenario.
I have one table which has partition with Year,Month,Week.
Now i want to make partition on Year,Month,Week,Day (by adding Day column in partition).

Is this possible ?

Thanks.

4

@kkhatri

No changing the partition keys is not possible on an existing table. But you could increase the number of shards for a partition (e.g. if partitions get too big in size).

also if you want to partition by week/day you probably should use date_trunc('week',timestamp)
https://crate.io/docs/crate/reference/en/4.5/general/builtins/scalar-functions.html#date-trunc-interval-timezone-timestamp
https://crate.io/docs/crate/reference/en/4.5/general/ddl/partitioned-tables.html#creation

5

Thanks for your input and valuable time.

1 Like