Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB