Hi Hemant,
What version of Calcite are you using? That would be helpful for someone
to try looking into this further.
- Josh
Hemant Saxena wrote:
Hello,
I am trying out the MongoDB adapter tutorial mentioned here
https://calcite.apache.org/docs/howto.html#mongodb-adapter
Data is successfully loaded to MongoDB, db.zips.find().limit(3) return
three entries.
However, when I connect to MongoDB zips schema as shown in the tutorial and
run '!tables' command I see the following output:
+-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT |
TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
| | metadata | COLUMNS | SYSTEM_TABLE | |
| | | | |
2016-05-08 11:13:41,627 [main] ERROR -
org.apache.calcite.sql.validate.SqlValidatorException: Table
'mongo_raw.zips' not found
2016-05-08 11:13:41,629 [main] ERROR -
org.apache.calcite.runtime.CalciteContextException: From line 2, column 213
to line 2, column 230: Table 'mongo_raw.zips' not found
org.apache.calcite.runtime.CalciteContextException: From line 2, column 213
to line 2, column 230: Table 'mongo_raw.zips' not found
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
. . .
. . .
Any help on this will be appreciated.
Thanks,
Hemant
