[DRILL-3685] Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Execution - Data Types
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Victoria Markman
• Created: 21/Aug/15 17:46
• Updated: 03/Sep/15 20:17
• Resolved: 24/Aug/15 17:00

Description

0: jdbc:drill:schema=dfs> select
. . . . . . . . . . . . >         c_integer,
. . . . . . . . . . . . >         row_number()   over (order by c_date desc),
. . . . . . . . . . . . >         ntile(100)     over (order by c_date, c_timestamp )
. . . . . . . . . . . . > from
. . . . . . . . . . . . >         j2
. . . . . . . . . . . . > ;
Error: SYSTEM ERROR: UnsupportedOperationException: Unable to get value vector class for minor type [LATE] and mode [OPTIONAL]
Fragment 0:0
[Error Id: 1912dd81-dda4-4576-9bd9-420189ff57fe on atsqa4-133.qa.lab:31010] (state=,code=0)