[
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)
