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 &amp; 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)