@Elon What's the usage you have in mind? We have transform functions interface, and it might be really easy to add.
e
Elon
12/08/2019, 7:09 PM
Hi @Mayank, the usage was for using the HadoopPinotFS and including the gcs-connector jar or more preferably, using the GcsPinotFS (something I'm working on now, should have a pr ready in the next day or 2).
m
Mayank
12/08/2019, 7:12 PM
Oh, I interpreted it as you were looking for something like
select toUpper(foo) from table where....
Is that not the case?
Mayank
12/08/2019, 7:17 PM
BTW, looking forward to GcsPinotFS PR.
k
Kishore G
12/08/2019, 7:17 PM
I think @Elon already submitted a PR for uppercase
Ah, thanks, I didn't realize that was what you were asking. So in the pinot presto connector for prestosql I implemented filter pushdown so the filters get added to the "dynamic" pql there as well - this is a workaround until prestosql implements aggregation pushdown. I was referring to something else: we are implementing GcsPinotFS and also trying to use gcs-connector for HadoopPinotFS