Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - IN() Operator


+
Andy Kent 2010-02-19, 16:58
+
Vladimir Klimontovich 2010-02-19, 17:00
Copy link to this message
-
Re: IN() Operator
Amr Awadallah 2010-02-20, 04:27
Andy,

    Are you trying to do something like:

SELECT
FROM mytable  A
WHERE ....
AND mycol IN (
SELECT ....

)

If so, you can't do sub-queries inside the WHERE clause in Hive, you can
only do sub-queries within the FROM/JOIN clause.

But, almost any query similar to above can be written using sub-queries
in the FROM using join instead.

For example:

SELECT ....
FROM mytable A
JOIN ( SELECT .... ) B
ON A.mycol  = B.mycol
WHERE ...

hope that helps.

-- amr

On 2/19/2010 8:58 AM, Andy Kent wrote:
> I couldn't find anything on the wiki so thought I would try here.
>
> Does Hive have an IN() operator similar to in MySQL?
>
> If not then is there an alternative way of testing for inclusion?
>
> Thanks,
> Andy.