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

ROW_NUMBER() window function throws exception during execution

    XMLWordPrintableJSON

    Details

      Description

      Window function ROW_NUMBER() is currently:

      • Supported in Calcite
      • Not supported in DRILL
      • Not documented in DRILL documentation

      It throws exception during execution:

      0: jdbc:drill:schema=dfs> select a1, row_number() over (partition by a1) from `t.json`;
      Query failed: Query failed: Unexpected exception during fragment initialization: null
      
      Error: exception while executing query: Failure while executing query. (state=,code=0)
      0: jdbc:drill:schema=dfs> select a1, row_number() over () from `t.json`;
      Query failed: Query failed: Unexpected exception during fragment initialization: null
      
      Error: exception while executing query: Failure while executing query. (state=,code=0)
      

      According to Jira, DRILL-1487 is targeted for 0.8.0 release.
      DRILL-1902 is marked as critical bug as well.

      We have two options:
      1) Make this function work for 0.8.0
      2) Throw unsupported error message in 0.8.0 and implement row_number() later

      If we decide to go with option #1, can we please file a separate bug for error message
      in 0.8.0 and turn this one into an enhancement request.

      drill 0.8.0
      git.commit.id.abbrev=5f70ba1 
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: