Using an UDF in the WHERE (IN) clause

[Petter von Dolwitz (Hem)]

Hi,

I'm trying to get the following query to work. The parser don't like it.
Anybody aware of a workaround?

SELECT * FROM mytable WHERE partitionCol IN my_udf("2014-03-10");

partitionCol is my partition column of type INT and I want to achieve early
pruning. I've tried returning an array of INTs from my_udf and also a plain
string in the format (1,2,3). It seems like the parser wont allow me to put
an UDF in this place.

Any help appreciated.

Thanks,
Petter