Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
1.11.0
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
- links to
