[prev in list] [next in list] [prev in thread] [next in thread] 

List:       drill-dev
Subject:    [jira] [Created] (DRILL-1910) ROW_NUMBER() window function throws exception during execution
From:       "Victoria Markman (JIRA)" <jira () apache ! org>
Date:       2014-12-30 22:32:13
Message-ID: JIRA.12764294.1419978697000.117850.1419978733287 () Atlassian ! JIRA
[Download RAW message or body]

Victoria Markman created DRILL-1910:
---------------------------------------

             Summary: 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: Functions - Drill
    Affects Versions: 0.8.0
            Reporter: Victoria Markman


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)

[prev in list] [next in list] [prev in thread] [next in thread]