hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Petter von Dolwitz (Hem)" <petter.von.dolw...@gmail.com>
Subject Using an UDF in the WHERE (IN) clause
Date Mon, 10 Mar 2014 15:23:01 GMT
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

Mime
View raw message