@San Kumar please refer to the documentation, it cover all the questions you asked. https://docs.pinot.apache.org/configuration-reference/table