Hi ,
Do you mean to say, I need to change the model.json file present in the
examples directory. I have edited the existing model.json file present in
the example/csv/target/test-classes to include the postgres schema . But I
am not able to connect . Below is the edited json just to include postgres
-
{
"version": "1.0",
"defaultSchema": "SALES Samplepostgres",
"schemas": [
{
"name": "SALES",
"type": "custom",
"factory": "org.apache.calcite.adapter.csv.CsvSchemaFactory",
"operand": {
"directory": "sales"
}
},
{
"name": "Samplepostgres",
"type": "custom",
"factory": "org.apache.calcite.adapter.jdbc.JdbcSchema$Fac{
"version": "1.0",
"defaultSchema": "SALES Samplepostgres",
"schemas": [
{
"name": "SALES",
"type": "custom",
"factory": "org.apache.calcite.adapter.csv.CsvSchemaFactory",
"operand": {
"directory": "sales"
}
},
{
"name": "Samplepostgres",
"type": "custom",
"factory": "org.apache.calcite.adapter.jdbc.JdbcSchema$Factory",
"operand": {
"jdbcDriver": "org.postgresql.Driver",
"jdbcUrl": "jdbc:postgresql://localhost/bigdawg_catalog",
"jdbcUser": "pguser",
"jdbcPassword": "test"
}
}
]
}
tory",
"operand": {
"jdbcDriver": "org.postgresql.Driver",
"jdbcUrl": "jdbc:postgresql://localhost/bigdawg_catalog",
"jdbcUser": "pguser",
"jdbcPassword": "test"
}
}
]
}
Could you please let me know if it is correct. I am getting an error -
sqlline version 1.3.0
sqlline> select * from table3;
No current connection
The table table3 is present in the postgres database.
Thanks,
Ashwin
On Mon, Oct 2, 2017 at 7:59 PM, Julian Hyde <[email protected]> wrote:
> 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
> >>
> >>
>
>
