[
https://issues.apache.org/jira/browse/DRILL-3243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601402#comment-14601402
]
Deneche A. Hakim commented on DRILL-3243:
-----------------------------------------
for this specific query I don't think is valid at all, the where clause should
be applied before the over clause so one cannot reference the output of the
window function in the where clause. Drill assumes 'tmp' referes to a column in
the table and because it's a csv file we only support {{columns[X]}} for now.
> 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)
