Easiest thing is to create a JSON model file with two schemas in it. https://calcite.apache.org/docs/model.html <https://calcite.apache.org/docs/model.html>
https://calcite.apache.org/docs/adapter.html <https://calcite.apache.org/docs/adapter.html> > On Oct 2, 2017, at 11:48 AM, AshwinKumar AshwinKumar <[email protected]> > wrote: > > Could you please give me some pointers for where can I get some > documentation or links on how to connect elastisearch and postgres in same > query. > As we know Elastisearch has a separate adapter and postgres comes under > jdbc adapter. Do we need to create a root schema using jdbc adapter for > elastisearch instance. > > Thanks, > Ashwin > > On Mon, Oct 2, 2017 at 2:44 PM, Julian Hyde <[email protected]> wrote: > >> Yes, you should be able to combine any data source with any other data >> source in a query. >> >> Julian >> >>> On Oct 2, 2017, at 11:40 AM, AshwinKumar AshwinKumar < >> [email protected]> wrote: >>> >>> Hello Team, >>> >>> I had a question regarding connecting Elastisearch and Postgres Database >> in >>> a single query. Could you please let me know If we can query a >> elastisearch >>> type(table) and a postgres table in the same query. >>> >>> Thanks, >>> Ashwin >> >>
