Is there a string length limitation for a string c...
# troubleshooting
t
Is there a string length limitation for a string column. I’m seeing my data being truncated to 575 characters.
Am I supposed explicitly set a larger limit here?
image.png
m
Yes
Can you also describe what operations you want to do on this column?
For example, if you would like to perform regex search, then perhaps text column type is better than string
t
this column is to store a json blob
we most likely won’t need to query the contents of the json either
m
Ok, in that case you should make this no-dict column, as I guess the cardinality will be high
t
where in the documentation can i read about this?
Copy code
{
  "name": "annotations_json_str",
  "dataType": "STRING",
  "maxLength": 250000
}
the maxLength is something i’m going to add
n
noDictionary can be set in the table config’s indexing config: https://docs.pinot.apache.org/configuration-reference/table#table-index-config
m
Perhaps we should also think about default to no-dictionary in such cases
👍 1