[ https://issues.apache.org/jira/browse/DRILL-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556421#comment-14556421 ]
Bhallamudi Venkata Siva Kamesh commented on DRILL-3152: ------------------------------------------------------- Check whether zookeeper is running or not and you are pointing correct zk? > Apache Drill 1.0 not able to query MongoDB 3.0. > ------------------------------------------------ > > Key: DRILL-3152 > URL: https://issues.apache.org/jira/browse/DRILL-3152 > Project: Apache Drill > Issue Type: Bug > Components: Storage - MongoDB > Affects Versions: 0.9.0, 1.0.0 > Environment: The environment is as follows: > Windows 7 > MongoDB 3 Wiredtiger (installed locally) > Apache Drill 1.0 (installed locally) > Reporter: Trent Telfer > Assignee: B Anil Kumar > Labels: mongodb, mongodb3, windows7, wiredtiger > > I have been trying to get Apache Drill 1.0, and previously 0.9 to work with > MongoDB 3.0 Wiredtiger. I have no problem starting Apache Drill using the > following, but I am having problems querying MongoDB: > *./sqlline.bat* > *!connect jdbc:drill:zk=local* > *SHOW DATABASES;* > +---------------------+ > | SCHEMA_NAME | > +---------------------+ > | INFORMATION_SCHEMA | > | cp.default | > | dfs.default | > | dfs.root | > | dfs.tmp | > | mongo.admin | > | mongo.alliance_db | > | mongo.local | > | sys | > +---------------------+ > *USE mongo.alliance_db;* > +-------+------------------------------------------------+ > | ok | summary | > +-------+------------------------------------------------+ > | true | Default schema changed to [mongo.alliance_db] | > +-------+------------------------------------------------+ > 1 row selected (0.116 seconds) > *SELECT * FROM price_daily_ngi;* > May 20, 2015 11:14:40 AM > org.apache.calcite.sql.validate.SqlValidatorException <init> > SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table > 'price_daily_ngi' not found > May 20, 2015 11:14:40 AM org.apache.calcite.runtime.CalciteException <init> > SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, > column 15 to line 1, column 29: Table 'price_daily_ngi' not found > Error: PARSE ERROR: From line 1, column 15 to line 1, column 29: Table > 'price_daily_ngi' not found > [Error Id: 6414a69d-55a0-4918-8f95-10a920e4dc6b on PCV:31010] (state=,code=0) > MongoDB storage configuration: > { > "type": "mongo", > "connection": "mongodb://localhost:27017", > "enabled": true > } > The collection price_daily_ngi exists and works with normal MongoDB queries. -- This message was sent by Atlassian JIRA (v6.3.4#6332)