[
https://issues.apache.org/jira/browse/DRILL-1910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14286616#comment-14286616
]
Deneche A. Hakim commented on DRILL-1910:
-----------------------------------------
This is more like a duplicate issue. In DRILL-1908 latest patch, I added a
configuration option to disable window functions completely and display "window
functions not supported" whenever the user uses over in a query. But as I
commented before, the exception reported here is thrown by optiq-drill and
should be fixed by DRILL-1852.
> ROW_NUMBER() window function throws exception during execution
> --------------------------------------------------------------
>
> Key: DRILL-1910
> URL: https://issues.apache.org/jira/browse/DRILL-1910
> Project: Apache Drill
> Issue Type: New Feature
> Components: Execution - Operators
> Affects Versions: 0.8.0
> Reporter: Victoria Markman
> Assignee: Deneche A. Hakim
> Fix For: Future
>
>
> Window function ROW_NUMBER() is currently:
> * Supported in Calcite
> * Not supported in DRILL
> * Not documented in DRILL documentation
> It throws exception during execution:
> {code}
> 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)
> {code}
> 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.
> {code}
> drill 0.8.0
> git.commit.id.abbrev=5f70ba1
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
