Trent Telfer created DRILL-3152:
-----------------------------------
Summary: 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: 1.0.0, 0.9.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
I have been trying to get Apache 1.0, and previously 0.9 to work with MongoDB
3.0 WIredtiger. I have no problem starting Apache Drill using the following:
./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
}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
