You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/03/10 23:17:39 UTC
[jira] [Created] (DRILL-2422) Querying views having the same name
as their datasource fails
Abhishek Girish created DRILL-2422:
--------------------------------------
Summary: Querying views having the same name as their datasource fails
Key: DRILL-2422
URL: https://issues.apache.org/jira/browse/DRILL-2422
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 0.8.0
Reporter: Abhishek Girish
Assignee: Jinfeng Ni
Git.Commit.ID: f658a3c (Mar 9 2015)
*Convert a simply text file to Parquet:*
{code:sql}
> select * from `abc.dat` limit 1;
+------------+
| columns |
+------------+
| ["hi","abc"] |
+------------+
1 row selected (0.574 seconds)
> create table abc_1 as select cast(columns[0] as varchar(10)) as a from `abc.dat`;
+------------+---------------------------+
| Fragment | Number of records written |
+------------+---------------------------+
| 0_0 | 1 |
+------------+---------------------------+
1 row selected (0.626 seconds)
> select * from abc_1 limit 1;
+------------+
| a |
+------------+
| hi |
+------------+
1 row selected (0.135 seconds)
{code}
*Create a view on top of the Parquet table:*
{code:sql}
> create view abc_1 as select cast(a as varchar(10)) as b from abc_1;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'abc_1' created successfully in 'dfs.tmp' schema |
+------------+------------+
1 row selected (0.072 seconds)
> select * from abc_1 limit 1;
Query failed: SqlValidatorException: Column 'a' not found in any table
Error: exception while executing query: Failure while executing query. (state=,code=0)
OR
> create view abc_1 as select cast(a as varchar(10)) as b from dfs.`/tmp/abc_1`;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'abc_1' created successfully in 'dfs.tmp' schema |
+------------+------------+
1 row selected (0.047 seconds)
> select * from abc_1 limit 1;
Query failed: SqlValidatorException: Column 'a' not found in any table
Error: exception while executing query: Failure while executing query. (state=,code=0)
OR
0: jdbc:drill:zk=10.10.103.32:5181> create view abc_1 as select a from dfs.`/tmp/abc_1`;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'abc_1' created successfully in 'dfs.tmp' schema |
+------------+------------+
1 row selected (0.046 seconds)
0: jdbc:drill:zk=10.10.103.32:5181> select * from abc_1 limit 1;
+--+
| |
+--+
+--+
No rows selected (11.856 seconds)
{code}
In the third case, queries do not return and need to be cancelled.
For example:
{code:sql}
0: jdbc:drill:zk=10.10.103.32:5181> use dfs.tpcds1;
+--+
| |
+--+
+--+
No rows selected (2.854 seconds)
{code}
Sqlline needs to be suspended, killed and restarted to be able to query again.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)