[jira] [Closed] (DRILL-3247) Query without casting results in CompileException

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

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

Deneche A. Hakim closed DRILL-3247.
-----------------------------------
    Resolution: Duplicate

I tested the query using my patch for DRILL-3218 and it seems to be working fine now.

> Query without casting results in CompileException
> -------------------------------------------------
>
>                 Key: DRILL-3247
>                 URL: https://issues.apache.org/jira/browse/DRILL-3247
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.0.0
>            Reporter: Khurram Faraaz
>            Assignee: Deneche A. Hakim
>              Labels: window_function
>             Fix For: 1.1.0
>
>
> Need a better error message, currently we report CompileException, when columns are not casted to correct datatypes.
> Please see DRILL-3218 for more details.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> SELECT MAX(columns[0]) OVER (PARTITION BY columns[6] ORDER BY columns[4]) FROM `allTypData2.csv`;
> Error: SYSTEM ERROR: org.codehaus.commons.compiler.CompileException: Line 330, Column 31: Unknown variable or type "incoming"
> Fragment 0:0
> [Error Id: 285af8f1-ddb4-4d3e-a2d7-bfaef20df5e0 on centos-02.qa.lab:31010] (state=,code=0)
> {code}



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