Re: Set difference in Hive

[Amr Awadallah]

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