RE: Simple UDFS and IN Operator

2016-03-09 Thread Lavelle, Shawn
, ~ Shawn M Lavelle From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Tuesday, March 08, 2016 6:10 PM To: user@hive.apache.org Subject: Re: Simple UDFS and IN Operator The IN UDF is a special one in that unlike many others there is support in the ANTLR language and parsers for it. The

Re: Simple UDFS and IN Operator

2016-03-08 Thread Gopal Vijayaraghavan
> In Hive 0.11, I¹ve written a UDF that returns a list of Integers. I¹d >like to use this in a WHERE clause of a query, something like SELECT * >FROM WHERE in ( getList()). ... > Joins would be ideal, but we haven¹t upgraded yet. IN() is actually rewritten into a JOIN (distinct ...) intern

Re: Simple UDFS and IN Operator

2016-03-08 Thread Edward Capriolo
The IN UDF is a special one in that unlike many others there is support in the ANTLR language and parsers for it. The rough answer is it can be done but it is not as direct as making other UDFs. On Tue, Mar 8, 2016 at 2:32 PM, Lavelle, Shawn wrote: > Hello All, > >I hope that this question