Delete comment from: Julian Hyde on Streaming Data, Open Source OLAP. And stuff.
Hello,
it seems to problem with Mongo 2.6
0: jdbc:optiq:model=mongodb/target/test-class> !tables
+-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT | TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
com.mongodb.MongoException: not authorized for query on admin.system.namespaces
at com.mongodb.MongoException.parse(MongoException.java:82)
at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:292)
at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:273)
at com.mongodb.DB.getCollectionNames(DB.java:399)
at net.hydromatic.optiq.impl.mongodb.MongoSchema.getTableMap(MongoSchema.java:56)
at net.hydromatic.optiq.impl.AbstractSchema.getTableNames(AbstractSchema.java:79)
at net.hydromatic.optiq.jdbc.OptiqSchema$3.build(OptiqSchema.java:94)
at net.hydromatic.optiq.jdbc.OptiqSchema$3.build(OptiqSchema.java:91)
at net.hydromatic.optiq.jdbc.OptiqSchema$AbstractCached.get(OptiqSchema.java:664)
at net.hydromatic.optiq.jdbc.OptiqSchema.getTableNames(OptiqSchema.java:309)
at net.hydromatic.optiq.jdbc.MetaImpl.tables(MetaImpl.java:366)
at net.hydromatic.optiq.jdbc.MetaImpl.tables(MetaImpl.java:397)
at net.hydromatic.optiq.jdbc.MetaImpl$5.apply(MetaImpl.java:253)
at net.hydromatic.optiq.jdbc.MetaImpl$5.apply(MetaImpl.java:251)
at net.hydromatic.linq4j.EnumerableDefaults$8$1.moveNext(EnumerableDefaults.java:1468)
at net.hydromatic.linq4j.EnumerableDefaults$15$1.moveNext(EnumerableDefaults.java:2033)
at net.hydromatic.optiq.runtime.EnumeratorCursor.next(EnumeratorCursor.java:47)
at net.hydromatic.avatica.AvaticaResultSet.next(AvaticaResultSet.java:187)
at sqlline.IncrementalRows.hasNext(IncrementalRows.java:62)
at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
at sqlline.SqlLine.print(SqlLine.java:1653)
at sqlline.Commands.metadata(Commands.java:199)
at sqlline.Commands.tables(Commands.java:332)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:804)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Oct 23, 2014, 6:12:59 AM
Posted to Efficient SQL queries on MongoDB
