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.