You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/02/28 02:39:04 UTC
[jira] [Created] (DRILL-2346) Star is not expanded correctly in
create view if view fields are specified
Victoria Markman created DRILL-2346:
---------------------------------------
Summary: Star is not expanded correctly in create view if view fields are specified
Key: DRILL-2346
URL: https://issues.apache.org/jira/browse/DRILL-2346
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 0.8.0
Reporter: Victoria Markman
Assignee: Jinfeng Ni
Priority: Minor
{code}
0: jdbc:drill:schema=dfs> select * from t2 limit 1;
+------------+------------+------------+
| a2 | b2 | c2 |
+------------+------------+------------+
| 0 | zzz | 2014-12-31 |
+------------+------------+------------+
1 row selected (0.065 seconds)
{code}
We get an error, even though table t2 has 3 columns:
{code}
0: jdbc:drill:schema=dfs> create view v2(a2, b2, c2) as select * from t2;
+------------+------------+
| ok | summary |
+------------+------------+
| false | View's field list and View's query field list have different counts. |
+------------+------------+
1 row selected (0.038 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)