Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3685

Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

    Details

      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)
      

        Attachments

        1. j2.tar
          5 kB
          Victoria Markman
        2. drillbit.log.drill-3685
          40 kB
          Victoria Markman

          Activity

            People

            • Assignee:
              adeneche Deneche A. Hakim
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: