drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3279) Window functions without ORDER BY - Error message needs to be fixed
Date Tue, 04 Aug 2015 19:18:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14654188#comment-14654188
] 

Khurram Faraaz commented on DRILL-3279:
---------------------------------------

We also need to fix the error message for LEAD and LAG window functions

{code}
0: jdbc:drill:schema=dfs.tmp> select lead(col0) over ( ) from `fewRowsAllData.parquet`;
Error: PARSE ERROR: From line 1, column 24 to line 1, column 26: RANK or DENSE_RANK functions
require ORDER BY clause in window specification


[Error Id: aa880bc4-5ff1-4c6d-82ea-d19d587c1b90 on centos-03.qa.lab:31010] (state=,code=0)
{code}

{code}
0: jdbc:drill:schema=dfs.tmp>  select lag(col0) over ( ) from `fewRowsAllData.parquet`;
Error: PARSE ERROR: From line 1, column 23 to line 1, column 25: RANK or DENSE_RANK functions
require ORDER BY clause in window specification


[Error Id: 26c2d055-e101-439b-b307-3e85faf1daad on centos-02.qa.lab:31010] (state=,code=0)
{code}

> Window functions without ORDER BY - Error message needs to be fixed
> -------------------------------------------------------------------
>
>                 Key: DRILL-3279
>                 URL: https://issues.apache.org/jira/browse/DRILL-3279
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.0.0
>            Reporter: Khurram Faraaz
>            Assignee: Deneche A. Hakim
>            Priority: Minor
>              Labels: window_function
>             Fix For: 1.3.0
>
>
> We need to add these two window function names CUME_DIST and PERCENT_RANK to the error
message, when user issues window function query without an order by in window definition.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select cume_dist() over (partition by col_chr) from
`allDataInPrq/0_0_0.parquet`;
> Error: PARSE ERROR: From line 1, column 25 to line 1, column 46: RANK or DENSE_RANK functions
require ORDER BY clause in window specification
> [Error Id: 330100e4-d90e-43db-8893-8e9ad3783874 on centos-03.qa.lab:31010] (state=,code=0)
> {code}
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select row_number() over (partition by col_chr) from
`allDataInPrq/0_0_0.parquet`;
> Error: PARSE ERROR: From line 1, column 26 to line 1, column 47: RANK or DENSE_RANK functions
require ORDER BY clause in window specification
> [Error Id: 4a95813f-592c-45e4-a74c-1cd34a9067c9 on centos-03.qa.lab:31010] (state=,code=0)
> {code}
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select rank() over (partition by col_chr) from `allDataInPrq/0_0_0.parquet`;
> Error: PARSE ERROR: From line 1, column 20 to line 1, column 41: RANK or DENSE_RANK functions
require ORDER BY clause in window specification
> [Error Id: 19bbd577-b653-4ebb-8f62-b9aee2bd6be5 on centos-03.qa.lab:31010] (state=,code=0)
> {code}
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select dense_rank() over (partition by col_chr) from
`allDataInPrq/0_0_0.parquet`;
> Error: PARSE ERROR: From line 1, column 26 to line 1, column 47: RANK or DENSE_RANK functions
require ORDER BY clause in window specification
> [Error Id: f9a438db-097c-441e-94a4-1d07835fcca7 on centos-03.qa.lab:31010] (state=,code=0)
> {code}
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select percent_rank() over (partition by col_chr) from
`allDataInPrq/0_0_0.parquet`;
> Error: PARSE ERROR: From line 1, column 28 to line 1, column 49: RANK or DENSE_RANK functions
require ORDER BY clause in window specification
> [Error Id: 897f32ea-4da5-4b1d-8864-f504bfe5ab6f on centos-03.qa.lab:31010] (state=,code=0)
> {code}



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

Mime
View raw message