Hi Folks. You can now query Pinot via Presto with ...
# generald
Devesh
10/26/2019, 6:48 AMHi Folks. You can now query Pinot via Presto with full pushdown support. Find more details at https://github.com/prestodb/presto/blob/master/presto-docs/src/main/sphinx/connector/pinot.rst. This just got merged into the trunk of prestodb/presto repo. There are no plans to backport this to prestosql currently. Thanks !
👏 4
👍 9
h
Himanshu Rathore
10/26/2019, 4:20 PMAny specific reason for not porting to PrestoSQL ? It is more widely used and preferred by cloud provider's like quoble, stardust, google
d
Devesh
10/26/2019, 5:07 PMWell I work at Uber, and we use prestodb :) so no specific motivation for me to do charity work on prestosql stuff.
a
Alex
10/26/2019, 6:10 PM@Himanshu Rathore PrestoSql currently lacks aggregation pushdowns
Alex
10/26/2019, 6:11 PMand implementation almost certainly will be different from PrestoDb, as there is a huge difference in the architectural view on how it should be done.
d
Devesh
10/26/2019, 6:39 PMActually .. if someone is interested we can share a fork that Uber used off 217 that does aggregation pushdown: it is probably not going to be accepted by prestosql since we had to build a new pushdown framework into prestosql. This work was done pre-fork off release 217. But it will take some work to make it work with prestosql now but At least this approach is similar to prestosql’s pushdown IR thinking
a
Alex
10/26/2019, 7:08 PMthat would be great!
c
Chinmay Soman
10/26/2019, 7:10 PMSigh ... Presto is such a mess
a
Alex
10/26/2019, 7:11 PMwell, there is an opinion that Facebook is a mess 🙂