Hello I am having an issue using "transformFuncti...
# general
m
Hello I am having an issue using "transformFunction": "TOJSONMAPSTR(values)" when using documentation: https://docs.pinot.apache.org/configuration-reference/functions/tojsonmapstr Avro schema:
Copy code
"fields": [
  ...
  {
    "name": "values",
    "type": {
      "type": "map",
      "values": [
        "string",
        "null"
      ]
    }
  }
]
Example how the data looks like:
Copy code
{
  ...
  "values": {
    "Value": "123",
    "Field": "CustomerID",
    "Description": "test1",
    "ListName": "1"
  }
}
Pinot table schema:
Copy code
"dimensionFieldSpecs": [
 {
   ...
   "name": "values_string",
   "dataType": "STRING"
 }
]
Everything works until I add:
Copy code
"ingestionConfig": {     
      "transformConfigs": [
        {
          "columnName": "values_string",
          "transformFunction": "TOJSONMAPSTR(values)"
        }
      }
Then i get the error:
Copy code
Invalid table config: Lists_REALTIME with error: Invalid transform function 'TOJSONMAPSTR(values)' for column 'values_string'
Any idea what am I doing wrong?
Fixed with "transformFunction": "TOJSONMAPSTR(\"values\")"