Hi, Did anyone know How to add new Json column name to the existing table

@Vuppala Suresh Kumar You should be able to simply add the new column to your schema via edit schema API, reload all your segments and you should be good to go.

We want to add transform function as well, How can we do that? @saurabh dubey @Mayank

"ingestionConfig": {
            "transformConfigs": [
                {
                    "columnName": "gps_tracking_devices",
                    "transformFunction": "jsonFormat(\"gps_tracking_devices_json\")"
                },
                {
                    "columnName": "vehicles",
                    "transformFunction": "jsonFormat(\"vehicles_json\")"
                },
                {
                    "columnName": "drivers",
                    "transformFunction": "jsonFormat(\"drivers_json\")"
                }

When adding a New column you should be able to add transform function to it. However, adding transform function to existing column is considered a backward incompatible change and is not allowed

1. Added new column with data type JSON in schema using schema POST API call 2. Added transform function in table config PUT api call 3. Reloaded the segements But now data not get reloaded.

Is this a real-time table? If so, are there segments that are committed yet, or did you including reload of consuming segments

Yes, real time table and existing segments

Hmm, that doesn’t make sense. Do you have server logs?

@Mayank you need zookeeper logs right?

@Piyush Chauhan We'd need pinot-server logs post reload is initiated