[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