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 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
>
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