Hi. Is there limit on number of columns in a pinot table? I have a flat JSON with 1.5k fields... Is it ok to have a table of 1.5k columns? What's the best practice for this type of JSON? thanks
m
Mayank
06/23/2023, 8:44 PM
There’s no limit in the code, but practically speaking I haven’t seen 1.5k columns (personally). If these are sparse columns, then JSON data type is the way to go.