Exception: Hash join failed


#1

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.


#2

Hi, try to see here:
table-expression-and-join-support
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.”


#3

Really appreciate! Thanks for response!