drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Wild (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4917) Unable to alias columns from subquery
Date Thu, 29 Sep 2016 19:37:20 GMT
Dan Wild created DRILL-4917:
-------------------------------

             Summary: Unable to alias columns from subquery
                 Key: DRILL-4917
                 URL: https://issues.apache.org/jira/browse/DRILL-4917
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.8.0
            Reporter: Dan Wild


Column aliasing works in a simple query (without subqueries):
`select 1 as myVal from (values(1))`
My result set gives me one column called myVal as expected.

However, when I run the query
`select myVal as myValAlias FROM(select 1 as myVal from (values(1)))`
the alias myValAlias is not applied, and the resulting column is still called myVal.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message