You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Vitalii Diravka (JIRA)" <ji...@apache.org> on 2018/10/05 12:24:00 UTC
[jira] [Created] (DRILL-6773) The renamed schema with aliases is
not shown for queries on directories
Vitalii Diravka created DRILL-6773:
--------------------------------------
Summary: The renamed schema with aliases is not shown for queries on directories
Key: DRILL-6773
URL: https://issues.apache.org/jira/browse/DRILL-6773
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.14.0
Reporter: Vitalii Diravka
Assignee: Vitalii Diravka
Fix For: 1.15.0
The query is not working:
{code:java}
0: jdbc:drill:zk=local> select WeekId, Product as ProductName from (select CAST(`dir0` as INT) AS WeekId, Product from dfs.`/tmp/empty_dir`);
+--+
| |
+--+
+--+
No rows selected (0.197 seconds)
{code}
but the following query without aliases works fine:
{code:java}
0: jdbc:drill:zk=local> select WeekId, Product from (select CAST(`dir0` as INT) AS WeekId, Product from dfs.`/tmp/empty_dir`);
+---------+----------+
| WeekId | Product |
+---------+----------+
+---------+----------+
No rows selected (0.276 seconds)
{code}
[_outProj_|https://github.com/apache/drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/planner/physical/ProjectPrel.java#L51] for _ProjectPrel_ was introduced in DRILL-5546. It marks top level Projects, which schema should be shown in result output.
_ProjectAllowDupPrel_ should have the same.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)