Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.9.0, 1.0.0
-
The environment is as follows:
Windows 7
MongoDB 3 Wiredtiger (installed locally)
Apache Drill 1.0 (installed locally)
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.