[DRILL-3297] Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Query Planning & Optimization
• Labels: window_function
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Victoria Markman
• Created: 15/Jun/15 20:55
• Updated: 11/Sep/15 19:52
• Resolved: 11/Sep/15 16:34

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