[DRILL-1910] ROW_NUMBER() window function throws exception during execution

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.8.0
• Fix Version/s: Future
• Component/s: Execution - Relational Operators
• Assignee: Abdel Hakim Deneche
• Reporter: Victoria Markman
• Created: 30/Dec/14 22:31
• Updated: 08/Jun/15 21:31
• Resolved: 08/Jun/15 21:31

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 

Issue Links

• duplicates: DRILL-3200 Add Window functions: ROW_NUMBER, RANK, PERCENT_RANK, DENSE_RANK and CUME_DIST