[jira] [Assigned] (DRILL-5878) TableNotFound exception is being reported for a wrong storage plugin.
[
https://issues.apache.org/jira/browse/DRILL-5878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva reassigned DRILL-5878:
---
Assignee: Hanumath Rao Maduri (was: Arina Ielchiieva)
> 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
> Labels: ready-to-commit
> 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 | 8.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 | 4.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 | 4.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 | 1.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 | 5.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}
>
[jira] [Assigned] (DRILL-5878) TableNotFound exception is being reported for a wrong storage plugin.
[
https://issues.apache.org/jira/browse/DRILL-5878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva reassigned DRILL-5878:
---
Assignee: Arina Ielchiieva (was: Hanumath Rao Maduri)
> 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: Arina Ielchiieva
>Priority: Minor
> Labels: ready-to-commit
> 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 | 8.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 | 4.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 | 4.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 | 1.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 | 5.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}
>
