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

Switch to Threaded View
Hive >> mail # user >> Set difference in Hive


Copy link to this message
-
Re: Set difference in Hive

do an outer join on user and filter on name.user is null

-- amr

Rakesh Setty wrote:
>
> Hi,
>
>  
>
>             I am new to Hive. I would like to know what is the easiest
> way to get the difference between two sets. For example, how can I
> convert the following SQL query to Hive?
>
>  
>
> select user from page_views where user not in (select name from users);
>
>  
>
> Thanks,
>
> Rakesh
>