drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trent Telfer (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3152) Apache Drill 1.0 not able to query MongoDB 3.0.
Date Wed, 20 May 2015 22:30:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Trent Telfer updated DRILL-3152:
--------------------------------
    Description: 
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.

  was:
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.


> 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