[jira] [Created] (DRILL-3195) Throw unsupported exception for Window functions that are not currently supported

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-3195:
---------------------------------------

             Summary: Throw unsupported exception for Window functions that are not currently supported
                 Key: DRILL-3195
                 URL: https://issues.apache.org/jira/browse/DRILL-3195
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 1.0.0
            Reporter: Victoria Markman
            Assignee: Jinfeng Ni


List of window functions that are currently supported by Calcite, that we don't plan to support in 1.1 release:  ntile(), lag(), lead(), first_value(), last_value() 

Examples of behavior if not disabled:

IOBE with NTILE:
{code}
0: jdbc:drill:schema=dfs> select ntile(3) over (partition by a1 order by a1) from t1;
Error: SYSTEM ERROR: java.lang.IndexOutOfBoundsException: index (1) must be less than size (1)
[Error Id: 99f1a074-0e68-400e-9c68-d3c623f85a9f on atsqa4-133.qa.lab:31010] (state=,code=0)
{code}

Schema change exception:
{code}
0: jdbc:drill:schema=dfs> select last_value(a1) over (partition by a1) from t1;
Error: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException: Failure while materializing expression. 
Error in expression at index -1.  Error: Missing function implementation: [last_value(INT-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.
Fragment 0:0
[Error Id: b5fac51d-0977-4641-9ead-0c98892d123a on atsqa4-133.qa.lab:31010] (state=,code=0)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)