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

             Summary: 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: Chris Westin


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