[teiid-issues] [JBoss JIRA] (TEIID-3421) Add ability to create Teiid language based custom functions

Steven Hawkins (JIRA) issues at jboss.org
Thu Apr 9 13:54:18 EDT 2015


     [ https://issues.jboss.org/browse/TEIID-3421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3421.
-----------------------------------
    Resolution: Duplicate Issue


Duplicate of TEIID-3270

> Add ability to create Teiid language based custom functions
> -----------------------------------------------------------
>
>                 Key: TEIID-3421
>                 URL: https://issues.jboss.org/browse/TEIID-3421
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>
> Add the capability to create user defined functions that do not require Java backing.  Use case would be something like a library of string manipulation functions such as separating a username or domain from an email address. For example:
> BEGIN
> 	SELECT substring(inputValue, 0, (locate('@', inputValue) - 1)) AS username;
> END
> Once the function is defined in the function library model, the user would then be able to utilize the functions in ad hoc queries like the below:
> SELECT getUsername(email) as username ...



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)


More information about the teiid-issues mailing list