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

    XMLWordPrintableJSON

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

            adeneche Abdel Hakim Deneche
            vicky Victoria Markman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: