[teiid-issues] [JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC

[Kylin Soong (JIRA)]

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

Kylin Soong edited comment on TEIID-4297 at 6/30/16 12:36 AM:
--------------------------------------------------------------

This library(http://search.maven.org/#search%7Cga%7C1%7Carrahtec) seems really on startup stages, we can't pull it via maven as below
{code}
<dependency>
    <groupId>org.arrahtec</groupId>
    <artifactId>profiler-core</artifactId>
    <version>6.1.7</version>
</dependency>
{code}
cause we can't pull it's dependencies. Due to profiler-core is on apache licence, can we just copy it's code to our code base and implement the functions?


was (Author: kylin):
This library(http://search.maven.org/#search%7Cga%7C1%7Carrahtec) seems really on startup stages, we can't pull it via maven as below
{code}
<dependency>
    <groupId>org.arrahtec</groupId>
    <artifactId>profiler-core</artifactId>
    <version>6.1.7</version>
</dependency>
{code}
cause we can't pull it's dependencies. Due to profiler-core is on apache licence, can we just copy it's code to our code base and implement the system functions?

> 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: JieRen JieRen
>             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)