[teiid-issues] [JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC
Ramesh Reddy (JIRA)
issues at jboss.org
Thu Aug 11 13:32:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13278102#comment-13278102 ]
Ramesh Reddy commented on TEIID-4297:
-------------------------------------
Revised older commit with simpler approach using {quote}@TeiidFunction{quote}. created a new module called "data-quality" to keep this pushing further with rich capabilities.
As per binary dependency on Teiid kit, I could not achieve that, as the Annotations were not showing up, and I can't use module classloader in "engine". There may be other techniques to solve this, but nothing striked off my mind.
Latest commit can be found here.
https://github.com/teiid/teiid/commit/09af025e597e14985b7d46162bfb467401b2fbf8
> Add UDF functions based on OSDQ for POC
> ---------------------------------------
>
> Key: TEIID-4297
> URL: https://issues.jboss.org/browse/TEIID-4297
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 9.1
>
>
> Please add following UDF functions to Teiid library based on maven module
> http://search.maven.org/#search%7Cga%7C1%7Carrahtec
> The UDF functions needs to from this class below
> {code}
> public class Maskutil {
> /**
> * @param a
> * The string that need to randomize
> * vivek singh' will become 'ihg vkeivh'
> */
> public static String toRandomValue(String a) {
> return ShuffleRTM.shuffleString(a);
> }
> /**
> * @param a
> * This function will retrun MD5 hashcode of the string
> * @return String
> */
> public static String toHashValue(String a) {
> if (a == null)
> return "d41d8cd98f00b204e9800998ecf8427e"; // null MD5 value
> return ResultsetToRTM.getMD5(a).toString();
> }
> /**
> * @param a
> * This function will return digit characters of the string
> * @return
> *
> */
> public static String toDigitValue(String a) {
> return StringCaseFormatUtil.digitString(a);
> }
> }
> {code}
> for example Teiid should have UDF functions like
> {code}
> string random(string)
> string hash(string)
> string digit(string)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list