[DRILL-3247] Query without casting results in CompileException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.0.0
• Fix Version/s: 1.1.0
• Component/s: Execution - Flow
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Khurram Faraaz
• Created: 03/Jun/15 00:47
• Updated: 06/Jun/15 15:54
• Resolved: 06/Jun/15 15:54

Description

Need a better error message, currently we report CompileException, when columns are not casted to correct datatypes.

Please see DRILL-3218 for more details.

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)

Issue Links

• is duplicated by: DRILL-3218 Window function usage throws CompileException