How to create java UDFs in teradata with table returned and the returned table's column numbers are variable
I want to create a java UDF in teradata, its return is table. My UDF's function is to read a input and return a table.
The input is splited to multi column by a delimter. For instans, the input's format is "1|1|1", the delimter is "|", so the return table has 3 columns, but when the input's format is "1|1|1|1", the table has 4 columns. Anyway, the table's column number is variable.
How can I achieve the UDF using java? Anyone can help me? I would appreciate very much.