I did some google search to try to figure out how to run query query interactive in calcite's SULLEN, but did not find useful information. I'm turing to this list for help.
Basically, I want to run queries interactive in calcite. The way I currently used is to add a JUnit test case, and run the JUnit. This is a bit cumbersome. Then, I found calcite has a script of "sqlline" in the root directory. Here is the connection of saline: qlline version 1.1.7 sqlline> !connect jdbc:calcite: admin admin 0: jdbc:calcite:> !list 1 active connection: #0 open jdbc:calcite: If I run a simple query like the following, sqlline complains TABLE not found. 0: jdbc:calcite:> select * from "hr"."emps"; Jan 08, 2015 10:59:37 AM org.apache.calcite.sql.validate.SqlValidatorException <init> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'hr.emps' not found Jan 08, 2015 10:59:37 AM org.apache.calcite.runtime.CalciteException <init> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 25: Table 'hr.emps' not found Error: while executing SQL: select * from "hr"."emps" (state=,code=0) Questions I have: 1. How to list all the available schemas /databases/ tables in calcite's sqlline? 2. Is it possible to run queries interactive through sqlline? Thanks for any help!
