RE: Using an UDF in the WHERE (IN) clause

2014-03-11 Thread java8964
What version of hive you are using? It is good to know that if it works in newer version. Yong Date: Tue, 11 Mar 2014 08:33:06 +0100 Subject: Re: Using an UDF in the WHERE (IN) clause From: petter.von.dolw...@gmail.com To: user@hive.apache.org Hi Young, I must argue that the partition pruning

Re: Using an UDF in the WHERE (IN) clause

2014-03-11 Thread Petter von Dolwitz (Hem)
k, it won't do the partition > > pruning. > > > > The partition pruning in Hive is strict static, any dynamic values > provided > > to partition column won't enable partition pruning, even though it is a > > feature I missed too. > > > > Yong >

Re: Using an UDF in the WHERE (IN) clause

2014-03-11 Thread Navis류승우
t;> >> The partition pruning in Hive is strict static, any dynamic values >> provided to partition column won't enable partition pruning, even though it >> is a feature I missed too. >> >> Yong >> >> >> Date: M

Re: Using an UDF in the WHERE (IN) clause

2014-03-11 Thread Petter von Dolwitz (Hem)
work, it won't do the partition > pruning. > > The partition pruning in Hive is strict static, any dynamic values > provided to partition column won't enable partition pruning, even though it > is a feature I missed too. > > Yong > > -------------

Re: Using an UDF in the WHERE (IN) clause

2014-03-10 Thread Navis류승우
t; ____________________ > Date: Mon, 10 Mar 2014 16:23:01 +0100 > Subject: Using an UDF in the WHERE (IN) clause > From: petter.von.dolw...@gmail.com > To: user@hive.apache.org > > > Hi, > > I'm trying to get the following query to work. The parser don

RE: Using an UDF in the WHERE (IN) clause

2014-03-10 Thread java8964
mn won't enable partition pruning, even though it is a feature I missed too. Yong Date: Mon, 10 Mar 2014 16:23:01 +0100 Subject: Using an UDF in the WHERE (IN) clause From: petter.von.dolw...@gmail.com To: user@hive.apache.org Hi, I'm trying to get the following query to work. The parser

Using an UDF in the WHERE (IN) clause

2014-03-10 Thread 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