[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} > How