[ https://issues.jboss.org/browse/TEIID-4646?page=com.atlassian.jira.plugin... ] 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. -- This message was sent by Atlassian JIRA (v7.2.3#72005)