Hi

I am doing an inner join on two relations say A, B.

A has fields - Word1:chararray, Word2:chararray, Word3:chararray,
Metric1:long, Metric2:long
B has fields - UniqueWord1:chararray, UniqueID:long

Facts about the relations:

   - Relation B has no duplicates, no NULLs in either fields.
   - Relation A has 840K records
   - Relation B has 340 records


Join statement:
join_A_B = JOIN A BY Word1, B BY UniqueWord1;

I expected the join to have <= 840K records. However the join returns 860K
records. While I debug, I just thought of asking here. Any thoughts on what
could be wrong?

Thanks much.

Arun

Reply via email to