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
A table can be partitioned on a text column, no problem, for instance:
CREATE TABLE parttable1 (
) 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?
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