[
https://issues.apache.org/jira/browse/DRILL-3243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601391#comment-14601391
]
Jacques Nadeau commented on DRILL-3243:
---------------------------------------
People have hit this a number of times. Everybody focuses on the schemaless
nature of things. I think that this is actually a red herring. Getting an
error message is much more annoying that just doing what the user wants. It
seems that the user friendly fix is to add support for using aliases in other
parts of a query. [~vicky], you probably know best what are all the places
where Drill doesn't support referencing aliases where it could. Do you want to
open enhancement requests for each?
> Need a better error message - Use of alias in window function definition
> ------------------------------------------------------------------------
>
> Key: DRILL-3243
> URL: https://issues.apache.org/jira/browse/DRILL-3243
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.0.0
> Reporter: Khurram Faraaz
> Assignee: Deneche A. Hakim
> Priority: Minor
> Fix For: 1.1.0
>
> Attachments: DRILL-3243.1.patch.txt
>
>
> Need a better error message when we use alias for window definition in query
> that uses window functions. for example, OVER(PARTITION BY columns[0] ORDER
> BY columns[1]) tmp, and if alias "tmp" is used in the predicate we need a
> message that says, column "tmp" does not exist, that is how it is in Postgres
> 9.3
> Postgres 9.3
> {code}
> postgres=# select count(*) OVER(partition by type order by id) `tmp` from
> airports where tmp is not null;
> ERROR: column "tmp" does not exist
> LINE 1: ...ect count(*) OVER(partition by type order by id) `tmp` from ...
> ^
> {code}
> Drill 1.0
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select count(*) OVER(partition by columns[2]
> order by columns[0]) tmp from `airports.csv` where tmp is not null;
> Error: SYSTEM ERROR: java.lang.IllegalArgumentException: Selected column(s)
> must have name 'columns' or must be plain '*'
> Fragment 0:0
> [Error Id: 66987b81-fe50-422d-95e4-9ce61c873584 on centos-02.qa.lab:31010]
> (state=,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
