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
