Object not found - while querying a type in elastisearch

[AshwinKumar AshwinKumar]

Hi Team,

I have created a model.json file with two connection instances for postgres
and elastisearch . PFB the file -

{
  "version": "1.0",
  "defaultSchema": "postgrestestelasti",
  "schemas": [
    {
      "name": "postgrestest",
      "type": "custom",
      "factory": "org.apache.calcite.adapter.jdbc.JdbcSchema$Factory",
      "operand": {
        //"jdbcDriver": "com.mysql.jdbc.Driver",
       // "jdbcUrl": "jdbc:mysql://localhost/foodmart",
        "jdbcDriver": "org.postgresql.Driver",
        "jdbcUrl": "jdbc:postgresql://localhost/bigdawg_catalog",
        "jdbcUser": "pguser",
        "jdbcPassword": "test"
      }
    },
    {
      "type": "custom",
      "name": "elasticsearch",
      "factory":
"org.apache.calcite.adapter.elasticsearch2.Elasticsearch2SchemaFactory",
      "operand": {
        "coordinates": "{'127.0.0.1': 9300}",
        "userConfig": "{'bulk.flush.max.actions': 10,
'bulk.flush.max.size.mb': 1}",
        "index": "megacorp"
      }
    }
  ]
}


The connection is working fine. But when I query a type called EMPLOYEES
(which I have created in the index megacorp)  , It throws the below error -

The query is - select * from EMPLOYEES;

error -

select * from "EMPLOYEES";
2017-10-04 03:54:46,696 [main] ERROR -
org.apache.calcite.sql.validate.SqlValidatorException: Object 'EMPLOYEES'
not found
2017-10-04 03:54:46,701 [main] ERROR -
org.apache.calcite.runtime.CalciteContextException: From line 1, column 15
to line 1, column 25: Object 'EMPLOYEES' not found
Error: Error while executing SQL "select * from "EMPLOYEES"": From line 1,
column 15 to line 1, column 25: Object 'EMPLOYEES' not found (state=,code=0)

Could you please let me know what is the issue here.

Note - please ignore the path for the modelPost.json file as I have it in
cassandra folder. This is just a test model file.


Thanks,
Ashwin