drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3152) Apache Drill 1.0 not able to query MongoDB 3.0.
Date Mon, 22 Jun 2015 02:55:00 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14595306#comment-14595306
] 

Jacques Nadeau commented on DRILL-3152:
---------------------------------------

You have two options: running Drill in embedded mode (no zookeeper required) or running in
daemon mode (zookeeper required).  If you want to run in daemon mode, you need to install
zookeeper.  Google gave me this for installing zookeeper on windows (I'm on a mac): https://support.lucidworks.com/hc/en-us/articles/203187153-Install-and-start-Zookeeper-server-on-Windows

> 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)

Mime
View raw message