[ https://issues.apache.org/jira/browse/DRILL-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14554621#comment-14554621 ]
B Anil Kumar commented on DRILL-3152: ------------------------------------- Hi, I just verified drill-1.0.0 with mongo v3.0.3 and it is working fine. Can you please verify by mentioning the db name in the query as below? {noformat} BANL122d28a3e:drill-latest abatchu$ bin/sqlline -u jdbc:drill:zk=localhost:2181 -n admin -p admin apache drill 1.0.0 "just drill it" 0: jdbc:drill:zk=localhost:2181> SELECT * FROM mongo.employee.`empinfo` limit 10; +--------------+-------------------+-------------+--------------+--------------+------------+--------+---------+ | employee_id | full_name | first_name | last_name | position_id | position | isFTE | salary | +--------------+-------------------+-------------+--------------+--------------+------------+--------+---------+ | 1101 | Steve Eurich | Steve | Eurich | 16 | Store T | true | 20.0 | | 1102 | Mary Pierson | Mary | Pierson | 16 | Store T | true | 30.0 | | 1103 | Leo Jones | Leo | Jones | 16 | Store Tem | true | 10.0 | | 1104 | Nancy Beatty | Nancy | Beatty | 16 | Store T | false | 40.0 | | 1105 | Clara McNight | Clara | McNight | 16 | Store | true | 50.0 | | 1106 | Marcella Isaacs | Marcella | Isaacs | 17 | Stor | false | 120.0 | | 1107 | Charlotte Yonce | Charlotte | Yonce | 17 | Stor | true | 120.0 | | 1108 | Benjamin Foster | Benjamin | Foster | 17 | Stor | false | 22.04 | | 1109 | John Reed | John | Reed | 17 | Store Per | false | 60.0 | | 1110 | Lynn Kwiatkowski | Lynn | Kwiatkowski | 17 | St | true | 80.0 | +--------------+-------------------+-------------+--------------+--------------+------------+--------+---------+ 10 rows selected (0.175 seconds) 0: jdbc:drill:zk=localhost:2181> {noformat} > 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)