i wrote a Java UDF and experiencing some strange behaviour. It is a Table function which i use int the from clause in an select statement. It should return only one row, containing a string.

When i run the statement it seems as the statement will be executeted over and over again for an infinite number of times (it doesn't stop returning the same result row).

Has anybody an idea for this???

I rewrote the UDF twice, changed some Parameter in the UDF definition but no success!!