How can I download the table data as CSV? From UI only 10 records are exported.

If you are looking for exporting all data out of Pinot, that is not a good use case for it. As for UI, you can increase the records returned by using

limit

thanks 🙂 . It seems, if we don't restrict results with a limit, only 10 records are shown on UI.

Alternatively, you can use Java or Python APIs to extract the data in Pinot. For example, you can write a simple Python script to query a Pinot table and write the output into a CSV file. https://docs.pinot.apache.org/users/clients/python

it's really helpful. thanks a lot 🙂