You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "B Anil Kumar (JIRA)" <ji...@apache.org> on 2015/05/21 18:37:17 UTC
[jira] [Commented] (DRILL-3152) Apache Drill 1.0 not able to query
MongoDB 3.0.
[ 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)