Victoria Markman created DRILL-3297: ---------------------------------------
Summary: Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error Key: DRILL-3297 URL: https://issues.apache.org/jira/browse/DRILL-3297 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Reporter: Victoria Markman Assignee: Jinfeng Ni {code} 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 [Error Id: 1bbc1410-5224-49e5-b6df-a8e80f888d98 on atsqa4-133.qa.lab:31010] at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73) at sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:85) at sqlline.TableOutputFormat.print(TableOutputFormat.java:116) at sqlline.SqlLine.print(SqlLine.java:1583) at sqlline.Commands.execute(Commands.java:852) at sqlline.Commands.sql(Commands.java:751) at sqlline.SqlLine.dispatch(SqlLine.java:738) at sqlline.SqlLine.begin(SqlLine.java:612) at sqlline.SqlLine.start(SqlLine.java:366) at sqlline.SqlLine.main(SqlLine.java:259) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)