Hello Team,
atm iam trying to execute some queries in java.
my code:
Class.forName("org.apache.calcite.jdbc.Driver");info = new
Properties();info.setProperty("lex", "SQL_SERVER");
connection = DriverManager.getConnection("jdbc:calcite:database/config.json",
info);statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select count(*) from
mongoDB.zips");//
or select count(*) from zips
my config.json:
{ version: '1.0', defaultSchema: 'mongo', schemas: [ { type:
'custom', name: 'mongoDB', factory:
'org.apache.calcite.adapter.mongodb.MongoSchemaFactory', operand: {
host: 'localhost', database: 'darwin_test',
} } ]}
i encounter Caused by: org.apache.calcite.sql.validate.SqlValidatorException:
Table 'mongoDB.zips' not found. The query works fine with sqlline.bat and the
same config (config.json). Am I making any obvious mistake?Thank youJulian
