Hi folks, we want to redact a part of a string column that contains text as CSV. For example:

val1,val2,token,val3

to

val1,val2,[redacted],val3

My Google-fu hasn’t been of much help. How can I do this though the query console?

Do you mean you're writing a query or?

Yes, I am writing a query.

There are some string functions, not sure if any of those would do the trick? https://docs.pinot.apache.org/users/user-guide-query/supported-transformations#string-functions How do you know what to redact?

Thanks @User, we have a regex.

maybe you can use

regexpExtract(String value, String regexp)

@User Can we query Pinot through an API?

Thanks Mark

Thanks Mark this is really helpful.