Please try this in Hive:
select distinct a.id from tableA a LEFT OUTER join tableB b on
a.id=b.id where b.id is null
Cheers,
Tim
On Wed, Nov 3, 2010 at 1:19 PM, Tim Robertson wrote:
> In SQL you use a left join:
>
> # so in mysql:
> select distinct a.id from tableA a left join tableB b on a.id=
In SQL you use a left join:
# so in mysql:
select distinct a.id from tableA a left join tableB b on a.id=b.id
where b.id is null
Not sure exactly how that ports to Hive, but it should be something
along those lines.
HTH,
Tim
On Wed, Nov 3, 2010 at 1:13 PM, איל (Eyal) wrote:
> Hi,
>
> I have a
Hi,
I have a table A with some values and another table B with some other values
How do I get all the distinct values from A that are NOT in B
e.g
if table A has values 1,2,3,4,1,2,3,5,6,7 and B has values 2,3,4,5,6
then the result should be 1,7
Thanks
Eyal
Hi LiuLei,
I believe you should check out HIVE-1760 (
https://issues.apache.org/jira/browse/HIVE-1760)
Hope this helps.
- Youngwoo
2010/11/3 lei liu
> When I create one table, hive throw below Exception:
>
> 2010-11-03 09:42:02,939 ERROR exec.DDLTask
> (SessionState.java:printError(277)) - F
When I create one table, hive throw below Exception:
2010-11-03 09:42:02,939 ERROR exec.DDLTask
(SessionState.java:printError(277)) - FAILED: Error in metadata:
java.lang.RuntimeExcepti
on: commitTransaction was called but openTransactionCalls = 0. This probably
indicates that there are unbalanced
