Case Statements in Batch spec

Hi,
I’m trying to collapse a few columns into one column during ingest. Specifically, trying to convert a bunch of bool columns into a single dimension:

case when column1 = true then ‘Value 1’

when column2 = true then ‘Value 2’

else ‘Value 3’

end as newDimColumn

Is there a way to specify this in the batch spec?

Thanks!

I think you may be able to do this with an undocumented 0.12.0 feature: https://github.com/druid-io/druid/pull/4890