Hanumath Rao Maduri created DRILL-5878:
------------------------------------------
Summary: TableNotFound exception is being reported for a wrong
storage plugin.
Key: DRILL-5878
URL: https://issues.apache.org/jira/browse/DRILL-5878
Project: Apache Drill
Issue Type: Bug
Components: SQL Parser
Affects Versions: 1.11.0
Reporter: Hanumath Rao Maduri
Assignee: Hanumath Rao Maduri
Priority: Minor
Fix For: 1.12.0
Drill is reporting TableNotFound exception for a wrong storage plugin.
Consider the following query where employee.json is queried using cp plugin.
{code}
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 |
+--------------+--------------------+-------------+------------+--------------+-------------------------+-----------+----------------+-------------+------------------------+----------+----------------+-------------------+-----------------+---------+--------------------+
{code}
However if cp1 is used instead of cp then Drill reports TableNotFound exception.
{code}
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)
{code}
Ideally this should report an error similar to invalid schema.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
