Hi Team, Is there any support for UNION/UNION ALL type of queries in Pinot? Tried few but no luck. Sample query:  select 'Poor' as grade union all  select 'Good' as grade

No I don't think union queries are supported. Not sure if it's something that's been asked for before, @User might know

We did think about it but in a different context - ingest from multiple Kafka topics in two Pinot tables but provide a logical abstraction on top of them