You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by 我很快乐 <89...@qq.com> on 2010/08/03 17:33:53 UTC

How I can implement the in clause

I am using the 0.4.1 version. The version don't support the in clause. Could anybody can tell me wether I can use where clause to implement the function, example: where id=1 or id=2 or id=3?
  
  
  
 Thanks,
  
  
 LiuLei

Re: How I can implement the in clause

Posted by Edward Capriolo <ed...@gmail.com>.

You should upgrade.

Hive trunk has row wise in.
https://issues.apache.org/jira/browse/HIVE-801

This feature will appear in the soon to be released hive 0.6.0

2010/8/3 我很快乐 <89...@qq.com>:
> I am using the 0.4.1 version. The version don't support the in clause. Could
> anybody can tell me wether I can use where clause to implement the function,
> example: where id=1 or id=2 or id=3?
>
>
>
> Thanks,
>
>
> LiuLei