Partitioning on TEXT type

CrateDB
1

Hi Everyone,
I want to create a partition on Text datatype.
eg:- If column stores Vehicle_no data and we want to create a partition on that column?
Is it possible to create a partition on text datatype?
If Yes how can we create a partition on it

Thanks
Vinayak katkar

2

Hi,
A table can be partitioned on a text column, no problem, for instance:

CREATE TABLE parttable1 (
   textfield TEXT, 
   someotherfield INT
) PARTITIONED BY (textfield);

That said, consider if the partitioning should perhaps be on a generated column derived from the original string, something like the first n characters perhaps?

2 Likes
3

Thanks Got it .
there is an issue in my table creation scripts and now changed as per your suggestion and its solve
thanks for your assists

Thanks
Vinayak Katkar

1 Like