Exception: Hash join failed


Hi Mapd masters,

I have two database tables:“PART” and “PARTSUPP”.Select records that have matching values in both tables.

select a.P_NAME, b.PS_AVAILQTY from PART a inner join PARTSUPP b ON a.P_PARTKEY = b.PS_PARTKEY;

I got error:

Exception: Hash join failed, reason: Could not build a 1-to-1 correspondence for columns involved in equijoin

Anyone can help? Thanks in advance.


Hi, try to see here:
especially at:
“For all but the first table list in the from-list, the data values in the join column must be unique. In data warehouse terms, list the “fact” table first, followed by any number of “dimension” tables.”


Really appreciate! Thanks for response!