Marco
12/17/2024, 8:12 PM"fields": [
...
{
"name": "values",
"type": {
"type": "map",
"values": [
"string",
"null"
]
}
}
]
Example how the data looks like:
{
...
"values": {
"Value": "123",
"Field": "CustomerID",
"Description": "test1",
"ListName": "1"
}
}
Pinot table schema:
"dimensionFieldSpecs": [
{
...
"name": "values_string",
"dataType": "STRING"
}
]
Everything works until I add:
"ingestionConfig": {
"transformConfigs": [
{
"columnName": "values_string",
"transformFunction": "TOJSONMAPSTR(values)"
}
}
Then i get the error:
Invalid table config: Lists_REALTIME with error: Invalid transform function 'TOJSONMAPSTR(values)' for column 'values_string'
Any idea what am I doing wrong?Marco
12/18/2024, 1:29 PM