array type with user defined functions

[jietao]

I have a function in JAVA that returns a string array, i.e., String []. I created a UDF with Teiid designer for this function, but cannot find a data type for the output parameter (I need a string array). How can I work around with this? The length of my string array is not fixed.

Thx

[rareddy]

Use "string[]" as datatype

[jietao]

in the wizard for UDF creation, I can only choose the data type listed by Teiid designer. There is no data type string [].

[rareddy]

See if you can edit it after the wizard completes. You can also log a Designer JIRA for the bug.

Ramesh..

[asmigala]

jietao, there is already a feature request reported: [TEIIDDES-2621] Support for array datatype - JBoss Issue Tracker

[jietao]

thx

[asmigala]

jietao as a workaround, you can model your return parameter as object datatype and then convert in the queries, or use arraytable

public static String[] splitString(String s){
    return s.split(" ");
}

SELECT CONVERT(c1, string[]) FROM t1
SELECT ARRAY_GET(c1, 1) FROM t1
SELECT x.* FROM t1, ARRAYTABLE(t1.c1 COLUMNS v1 string, v2 string, v3 string, v4 string) x

[jietao]

thx. it works!

Jie