Search code examples
partitioningcrate

Partitioning tables after creation using Crate

I was wondering if it's possible to do partitioning after table creation.

I'm trying to import ~2 million entries in a table (cluster), and if I partition the table before adding entries I get memory exceptions.

Solution

  • It is not possible to partition a table after its creation.

    2M records is not a lot of data, but if you have problems importing data into a partitioned table (e.g. if you have a lot of partitions), you could import data per partition:

    COPY table_name PARTITION (partition_column=column_name) WITH (option=value);

    See COPY FROM.