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

TableNotFound exception is being reported for a wrong storage plugin.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.11.0
    • Fix Version/s: 1.12.0
    • Component/s: SQL Parser
    • Labels:

      Description

      Drill is reporting TableNotFound exception for a wrong storage plugin.
      Consider the following query where employee.json is queried using cp plugin.

      0: jdbc:drill:zk=local> select * from cp.`employee.json` limit 10;
      +--------------+--------------------+-------------+------------+--------------+-------------------------+-----------+----------------+-------------+------------------------+----------+----------------+-------------------+-----------------+---------+--------------------+
      | employee_id  |     full_name      | first_name  | last_name  | position_id  |     position_title      | store_id  | department_id  | birth_date  |       hire_date        |  salary  | supervisor_id  |  education_level  | marital_status  | gender  |  management_role   |
      +--------------+--------------------+-------------+------------+--------------+-------------------------+-----------+----------------+-------------+------------------------+----------+----------------+-------------------+-----------------+---------+--------------------+
      | 1            | Sheri Nowmer       | Sheri       | Nowmer     | 1            | President               | 0         | 1              | 1961-08-26  | 1994-12-01 00:00:00.0  | 80000.0  | 0              | Graduate Degree   | S               | F       | Senior Management  |
      | 2            | Derrick Whelply    | Derrick     | Whelply    | 2            | VP Country Manager      | 0         | 1              | 1915-07-03  | 1994-12-01 00:00:00.0  | 40000.0  | 1              | Graduate Degree   | M               | M       | Senior Management  |
      | 4            | Michael Spence     | Michael     | Spence     | 2            | VP Country Manager      | 0         | 1              | 1969-06-20  | 1998-01-01 00:00:00.0  | 40000.0  | 1              | Graduate Degree   | S               | M       | Senior Management  |
      | 5            | Maya Gutierrez     | Maya        | Gutierrez  | 2            | VP Country Manager      | 0         | 1              | 1951-05-10  | 1998-01-01 00:00:00.0  | 35000.0  | 1              | Bachelors Degree  | M               | F       | Senior Management  |
      | 6            | Roberta Damstra    | Roberta     | Damstra    | 3            | VP Information Systems  | 0         | 2              | 1942-10-08  | 1994-12-01 00:00:00.0  | 25000.0  | 1              | Bachelors Degree  | M               | F       | Senior Management  |
      | 7            | Rebecca Kanagaki   | Rebecca     | Kanagaki   | 4            | VP Human Resources      | 0         | 3              | 1949-03-27  | 1994-12-01 00:00:00.0  | 15000.0  | 1              | Bachelors Degree  | M               | F       | Senior Management  |
      | 8            | Kim Brunner        | Kim         | Brunner    | 11           | Store Manager           | 9         | 11             | 1922-08-10  | 1998-01-01 00:00:00.0  | 10000.0  | 5              | Bachelors Degree  | S               | F       | Store Management   |
      | 9            | Brenda Blumberg    | Brenda      | Blumberg   | 11           | Store Manager           | 21        | 11             | 1979-06-23  | 1998-01-01 00:00:00.0  | 17000.0  | 5              | Graduate Degree   | M               | F       | Store Management   |
      | 10           | Darren Stanz       | Darren      | Stanz      | 5            | VP Finance              | 0         | 5              | 1949-08-26  | 1994-12-01 00:00:00.0  | 50000.0  | 1              | Partial College   | M               | M       | Senior Management  |
      | 11           | Jonathan Murraiin  | Jonathan    | Murraiin   | 11           | Store Manager           | 1         | 11             | 1967-06-20  | 1998-01-01 00:00:00.0  | 15000.0  | 5              | Graduate Degree   | S               | M       | Store Management   |
      +--------------+--------------------+-------------+------------+--------------+-------------------------+-----------+----------------+-------------+------------------------+----------+----------------+-------------------+-----------------+---------+--------------------+
      

      However if cp1 is used instead of cp then Drill reports TableNotFound exception.

      0: jdbc:drill:zk=local> select * from cp1.`employee.json` limit 10;
      Oct 16, 2017 1:40:02 PM org.apache.calcite.sql.validate.SqlValidatorException <init>
      SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'cp1.employee.json' not found
      Oct 16, 2017 1:40:02 PM org.apache.calcite.runtime.CalciteException <init>
      SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Table 'cp1.employee.json' not found
      Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Table 'cp1.employee.json' not found
      
      SQL Query null
      
      [Error Id: 280cb38f-4d71-4027-afbc-86df542f8f9a on laptop-npjh4dhd.corp.maprtech.com:31010] (state=,code=0)
      

      Ideally this should report an error similar to invalid schema.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hanu.ncr Hanumath Rao Maduri
                Reporter:
                hanu.ncr Hanumath Rao Maduri
                Reviewer:
                Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: