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)
