I think you meant to write “tab1.id = tab2.id”.
Based on your description I think there are a couple of things going wrong in
the JDBC adapter. It should be putting the tables from different MySQL
databases into different calcite schemas. (A calcite schema is a namespace. It
may map onto a da
Hi,
I have a couple of questions on calcite.
1. Assuming that I have a MySQL server which has two user databases: db1
and db2. If I wish to run a query "select * from db1.tab1 inner join db2.tab2
on db1.id = db2.id", do I need to add both databases in the root schema?
2.
3. Secondly, e
