Victoria Markman created DRILL-3685:
---------------------------------------

             Summary: Failure to execute query with NTILE and ROW_NUMBER window 
functions with different window definitions
                 Key: DRILL-3685
                 URL: https://issues.apache.org/jira/browse/DRILL-3685
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
    Affects Versions: 1.2.0
            Reporter: Victoria Markman
            Assignee: Hanifi Gunes


{code}
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)
{code}




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

Reply via email to