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

Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error

    XMLWordPrintableJSON

    Details

      Description

      0: jdbc:drill:schema=dfs> select rank() from t1;
      java.lang.RuntimeException: java.sql.SQLException: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException: Failure while materializing expression. 
      Error in expression at index -1.  Error: Missing function implementation: [rank(BIGINT-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.
      Fragment 0:0
      

        Attachments

          Activity

            People

            • Assignee:
              seanhychu Sean Hsuan-Yi Chu
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: