I'm aware that Hive for Hadoop does not support inequality joins. However, I've got a query which seems to run ok. As to whether the results are correct or not I'm dubious as I had a colleague who I shared this with who found it didn't produce the right result.

Here it is:

```
select foo.id, count(foo.*) as foo_vol, count(bar.*) as bar_vol 
from foo
 left outer outer join bar
  on foo.id = bar.id
  and (bar.f2 in (x, y, z)) = FALSE
group by foo.id

```

Anyone got any ideas on why this explains and runs ok? Is the issue of inequality joins actually related to whether the criteria uses fields from both sides of the join? Have FB / apache confirmed that this type of query is going to produce wrong results?

Cheers for any help,
Matt