drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanumath Rao Maduri (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5878) TableNotFound exception is being reported for a wrong storage plugin.
Date Mon, 16 Oct 2017 20:44:00 GMT
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)

Mime
View raw message