Hi all, I wanted to confirm whether multiple colum...
# general
e
Hi all, I wanted to confirm whether multiple columns can be specified as
sortedColumn
in a table spec? The docs[1] certainly seem to indicate that this might be possible, but I’m not certain. Follow up question if the answer is “Yes”: if I were to add a second column to a table with an existing
sortedColumn
config and reload segments, would that cause the newly added second sortedColumn to take effect? [1] https://docs.pinot.apache.org/basics/indexing/forward-index#sorted-forward-index-with-run-length-encoding
The answer was in the docs (above link) all along: >
Copy code
Additionally, for online tables, even though this property is specified as a JSON array, at most one column should be included. Using an array with more than one column is incorrect and will not result in segments being sorted by all the columns listed in the array.