Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3152

Apache Drill 1.0 not able to query MongoDB 3.0.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.9.0, 1.0.0
    • Fix Version/s: Future
    • Component/s: Storage - MongoDB
    • Environment:

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ttelfer Trent Telfer
            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated: