[teiid-issues] [JBoss JIRA] (TEIID-4646) Add engine support for lead/lag aggregate functions

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13386601#comment-13386601 ] 

Steven Hawkins commented on TEIID-4646:
---------------------------------------

a user defined aggregate function marked as analytic can be created as a replacement.

For pushdown support a source function can be created:

create foreign function first_value(arg object) returns object options ("teiid_rel:aggregate" true, "teiid_rel:analytic" true)

However since there isn't a good method for generic typing, this results in a function that is weakly typed.

Built-in engine and pushdown support is not a huge effort, but is currently scheduled further out.  You may want to open a support issue for faster inclusion.

> Add engine support for lead/lag aggregate functions
> ---------------------------------------------------
>
>                 Key: TEIID-4646
>                 URL: https://issues.jboss.org/browse/TEIID-4646
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector, Misc. Connectors, Query Engine
>            Reporter: Steven Hawkins
>             Fix For: 10.0
>
>
> Lead/lag and first_value/last_value analytical function support should be added to the engine with appropriate pushdown support.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)