[DRILL-3218] Window function usage throws CompileException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.1.0
• Component/s: Execution - Flow
• Labels: window_function

Environment

faec150598840c40827e6493992d81209aa936da

• Assignee: Abdel Hakim Deneche
• Reporter: Khurram Faraaz
• Created: 29/May/15 18:24
• Updated: 11/Jun/15 19:06
• Resolved: 11/Jun/15 19:06

Description

PARTITION BY date ORDER BY timestamp

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)

I will add more details in a bit.

Issue Links

• duplicates: DRILL-3247 Query without casting results in CompileException
• is part of: DRILL-3200 Add Window functions: ROW_NUMBER, RANK, PERCENT_RANK, DENSE_RANK and CUME_DIST