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

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


+
Rakesh Setty 2009-06-29, 23:01
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
>
+
Peter Skomoroch 2009-06-29, 23:19
+
Rakesh Setty 2009-06-29, 23:42
+
Namit Jain 2009-06-30, 00:04
+
Rakesh Setty 2009-06-30, 00:11
+
Namit Jain 2009-06-30, 00:19
+
Raghu Murthy 2009-06-30, 00:21
+
Rakesh Setty 2009-06-30, 00:28