Hi, calcite developers. I met a question about es-adapter and still cannot
resove it: .
1) calcite version :1.18.0
2) ES version : 5.4.1（I know that in calcite-1.18.0 is 6.4.2）
3) test sql : select count(*) from test
4) elasticsearch-model.json as follow:
{
"version": "1.0","defaultSchema": "elasticsearch", "schemas": [ { "type":
"custom", "name": "test", "factory":
"org.apache.calcite.adapter.elasticsearch.ElasticsearchSchemaFactory",
"operand": {
"coordinates": "{'xx.xx.xx.xx': 9205}",
"userConfig": "{'bulk.flush.max.actions': 10, 'bulk.flush.max.size.mb': 1}",
"index": "test" } } ] }
5) test-code:
try {
Class.forName("org.apache.calcite.jdbc.Driver");
} catch (ClassNotFoundException e) {
Throw new RuntimeException(e);
}
Properties pp = new Properties();
pp.put("lex", "JAVA");
Connection conn = null;
try {
conn =
DriverManager.getConnection("jdbc:calcite:model=D:\\calcite\\pre-git\\calcite-test\\conf\\elasticsearch-model.json",
pp);
Statement ss = conn.createStatement();
String sql = "select count(*) from test";
ResultSet result = ss.escuteQuery(sql);
output(resultSet, System.out);
} catch() {
Throw new RuntimeException("======get data failed" , e);
}
6) excaptions :
org.apache.calcite.sql.validate.SqlValidatorException:Object 'test' not found
Exception in thread "main" java.lang.RuntimeException: ======get data failed
.........
caused by:org.apache.calcite.runtime.CalciteContestException: From line 1,
column 22 to line 1, column 25: Object 'test' not found<4 internal calls>
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:787)
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:772)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4788)
at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:172)
.........
7) other confusions:
[1] I know that in elasticsearch apdator, test case is done by
EmbeddedElasticsearch, why not add one standard JDBC test case?
[2] model.json in http://calcite.apache.org/docs/elasticsearch_adapter.html
need to be update,should add "userConfig", or else will be failed.
any reply will be appreciated
Maria.
