You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "MUFEED USMAN (JIRA)" <ji...@apache.org> on 2014/11/10 04:16:33 UTC
[jira] [Created] (DRILL-1668) Dropping Views Throws Unrelated Error
MUFEED USMAN created DRILL-1668:
-----------------------------------
Summary: Dropping Views Throws Unrelated Error
Key: DRILL-1668
URL: https://issues.apache.org/jira/browse/DRILL-1668
Project: Apache Drill
Issue Type: Bug
Components: Client - JDBC
Affects Versions: 0.7.0
Reporter: MUFEED USMAN
Priority: Minor
I created the following 2 views on 2 separate schemas.
{code}
0: jdbc:drill:zk=n67:5181> select * from INFORMATION_SCHEMA.`VIEWS`;
+---------------+--------------+------------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION |
+---------------+--------------+------------+-----------------+
| DRILL | dfs.tmp | case_customer | SELECT `columns`[0], `columns`[1] FROM `dfs`.`root`.`cases.csv` |
| DRILL | n64.tmp | case_customer | SELECT `columns`[0], `columns`[1] FROM `dfs`.`root`.`cases.csv` |
+---------------+--------------+------------+-----------------+
2 rows selected (0.121 seconds)
{code}
Now, being in 'n64.tmp' I drop the following schema. All good.
{code}
0: jdbc:drill:zk=n67:5181> drop view case_customer;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'case_customer' deleted successfully from 'n64.tmp' schema |
+------------+------------+
1 row selected (0.135 seconds)
0: jdbc:drill:zk=n67:5181> select * from INFORMATION_SCHEMA.`VIEWS`;
+---------------+--------------+------------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION |
+---------------+--------------+------------+-----------------+
| DRILL | dfs.tmp | case_customer | SELECT `columns`[0], `columns`[1] FROM `dfs`.`root`.`cases.csv` |
+---------------+--------------+------------+-----------------+
1 row selected (0.145 seconds)
{code}
Now, when I try to drop again it should say something like "No view by the name case_customer found in the current workspace." Rather it throws the below.
{code}
0: jdbc:drill:zk=n67:5181> drop view case_customer;
+------------+------------+
| ok | summary |
+------------+------------+
| false | Error: Failure while accessing Zookeeper |
+------------+------------+
1 row selected (0.126 seconds)
{code}
And all good as it should be when executed as below.
{code}
0: jdbc:drill:zk=n67:5181> drop view dfs.tmp.`case_customer`;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'case_customer' deleted successfully from 'dfs.tmp' schema |
+------------+------------+
1 row selected (0.11 seconds)
0: jdbc:drill:zk=n67:5181> select * from INFORMATION_SCHEMA.`VIEWS`;
+---------------+--------------+------------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION |
+---------------+--------------+------------+-----------------+
+---------------+--------------+------------+-----------------+
No rows selected (0.136 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)