Apache Pinot

Hi little getting started question as I need more preprocesing on my fields. I’m facing a data error where I need to replace a few empty string to default date let say 2999. I’m ingestion the majority of my data using JSONPATH and I can’t directly use groovy as my cols names contains “.” anyone have face this kind of issue ? By empty I mean the field exist in my json so it’s not interpreted as null

I don't think there's a way too handle the empty string case, only null values.

<@U032F374KJR> I think I met similar question before. I tried the following way to get value of column contains “.”. For example, in this way, to get the value from jsonkey.labels.booking.count.
```"transformFunction": "jsonPathString(jsonKey, '$.labels[\"booking.count\"]')"```

Hi thanks for both of your feedback. But Alice I’m talking about values of the colomns which are empty.

I’ve found a way by modifying the JSONSTRING fonction the one with the default value. So if the `StringValueOf(Object).isBlank()` I send back the default value. Allowing me to return a parsable value to the fromDateTime. Don’t know if its a specific need or something to share with the community by a PR :wink: