Hi, is there some default limit for string dimensi...
# generalc
Carl
06/22/2021, 4:21 PMHi, is there some default limit for string dimensions field in Pinot, we are seeing some partial string returned from field queries.
m
Mayank
06/22/2021, 4:30 PM
Yes I think it defaults to 512 bytes. But you can overwrite it in the schema.
Mayank
06/22/2021, 4:30 PM
Will update the docs
Mayank
06/22/2021, 4:31 PM
Something like:
Copy code
{
"dataType": "STRING",
"maxLength": 1000,
"name": "textDim1"
},c
Carl
06/22/2021, 4:33 PMGot it, thank you.
Carl
06/22/2021, 4:34 PMCan we update this maxlength on the live data schema? Or we have to recreate the table?
m
Mayank
06/22/2021, 4:35 PM
If you want to fix data that is pushed, you will have to backfill.