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] [Updated] (DRILL-3681) need a better error message
Date Fri, 21 Aug 2015 02:36:46 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Khurram Faraaz updated DRILL-3681:
----------------------------------
    Assignee: Sean Hsuan-Yi Chu  (was: Chris Westin)

> need a better error message
> ---------------------------
>
>                 Key: DRILL-3681
>                 URL: https://issues.apache.org/jira/browse/DRILL-3681
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>    Affects Versions: 1.2.0
>            Reporter: Khurram Faraaz
>            Assignee: Sean Hsuan-Yi Chu
>              Labels: window_function
>
> We need a better error message, our current error message does not make any sense. The
issue is that we define the window in the outer query and try to use in the inner sub query.
We need to report to user that the window "windw" does not exist.
> Error reported by Drill
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select col1 , col2 , lead(col2) OVER windw FROM (SELECT
col0 , col1 , col2, col7 , ntile(3) over windw from FEWRWSPQQ_101) sub_query WINDOW windw
as (PARTITION BY col7 ORDER BY col0) ;
> Error: PARSE ERROR: From line 2147483647, column 2147483647 to line -1, column -1: Table
'FEWRWSPQQ_101' not found
> [Error Id: 176f1284-04cb-4718-a582-b10c9a690e95 on centos-02.qa.lab:31010] (state=,code=0)
> {code}
> Error reported by Postgres for same query and data
> {code}
> postgres=# select col1 , col2 , lead(col2) OVER windw FROM (SELECT col0 , col1 , col2,
col7 , ntile(3) over windw from FEWRWSPQQ_101) sub_query WINDOW windw as (PARTITION BY col7
ORDER BY col0) ;
> ERROR:  window "windw" does not exist
> LINE 1: ... (SELECT col0 , col1 , col2, col7 , ntile(3) over windw from...
>                                                                                     
      ^
> {code}



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

Mime
View raw message