Hi Julian, The current idea is through com.facebook.presto.spi. 1. Can be achieved through plugs provided by presto. For example [1]. 2. You can construct Connector directly through com.facebook.presto.spi.ConnectorFactory [2].
Best, Forward [1] https://www.codota.com/code/java/methods/com.facebook.presto.spi.Plugin/getConnectorFactories [2] https://www.programcreek.com/java-api-examples/?code=y-lan/presto/presto-master/presto-raptor/src/main/java/com/facebook/presto/raptor/RaptorPlugin.java Julian Hyde <[email protected]> 于2020年1月10日周五 上午2:03写道： > Sounds like you are planning to target Presto’s internal engine rather > than Presto the database. To clarify, can you give an example of the code > that you would generate and send to Presto for a simple SQL query? > > Julian > > > > On Jan 9, 2020, at 5:07 AM, Forward Xu <[email protected]> wrote: > > > > Hi, Stamatis > > > > Because we have a number of internal clusters already using and > installing > > presto. And we want use calcite to optimize the parser and push it down > to > > presto, spark and other calculation engines or olaps. Utilize the sql > > optimization function of calite in combination with distributed computing > > engines or distributed olaps such as presto. In this way, each > performance > > can be exerted. > > > > Best, > > Forward > > > > Stamatis Zampetakis <[email protected]> 于2020年1月9日周四 下午8:51写道： > > > >> Hi, > >> > >> Presto seems to have many similarities with Calcite itself. > >> As you mentioned, Presto is not really a database but a distributed SQL > >> framework to query heterogeneous data sources. > >> Presto connectors are in some sense similar to Calcite adapters and if > the > >> Enumerable convention was capable of performing distributed joins etc., > >> then the similarities would be even bigger. > >> > >> To the best of my knowledge, the majority of our users adopt Calcite > either > >> to query multiple data sources in a unified way or to provide SQL query > >> processing capabilities to data sources that do not already have. Presto > >> seems to have similar goals, thus, I am not sure who will benefit from > this > >> new adapter. > >> > >> I never used Presto myself so I may have missed some important points. > Can > >> you share some use-cases about who may use this adapter and how? > >> > >> Best, > >> Stamatis > >> > >> > >> On Wed, Jan 8, 2020 at 2:44 PM Forward Xu <[email protected]> > wrote: > >> > >>> Hi everybody, > >>> > >>> I'd like to kick off a discussion on Implement Presto adapter in > calcite. > >>> > >>> We know that presto is also a powerful SQL query tool, which is widely > >> used > >>> with the olap of big data. So I want to add an adapter for presto to > >>> calite. > >>> > >>> Would love to hear your thoughts. > >>> > >>> Best, > >>> Forward > >>> > >> > >
