Hello,
I recently watched the video of Stamatis Zampetakis ' An introduction to query
processing and Apache Calcite'. I followed the example provided in the video
tutorial and then I created a sample database of two tables to test the code.
First table contains sample employee data and second table contains department
data . I created a query in the parser as showed. My question is the following.
If i want to create two databases, so if I want to add one more database how
do I proceed with that? Do I need to have two schemas? I have checked that
there is a way adding a subschema into a schema but because I am new with Java
and Calcite a little help or advice would be great.
I followed this GitHub link given by the video creator.
https://github.com/zabetak/calcite/blob/demo-january-2021/core/src/test/java/org/apache/calcite/examples/foodmart/java/EndToEndExampleBindable.java
The only thing that is different is the objects since I created my own sample
database and the query.
Looking forward to your reply,
Kind Regards,Panagiota Chatzi, Ph.D.
