CODEWITHSUNDEEP
hadoopapache-pig
Eric Z Beard
Eric Z Beard

Reputation: 38424

In Pig, can you do a replicated left join?

The documentation is somewhat misleading when it comes to replicated joins in Pig. The script won't compile if I add 'left' to the join and also using 'replicated'. The documentation mentions only supporting left outer joins with replicated, but the behavior is obviously an inner join. Does anyone know how to do a left replicated join?

c = join a by (x,y,z) left, b by (x,y,z) using 'replicated';

(That statement won't parse)

Upvotes: 0

Views: 1319

Answers (1)

SNeumann
SNeumann

Reputation: 1177

replicated join can work with either inner or left outer join, and it works for me with 3 fields. what's the error message you're getting? are you sure the fields are of compatible data types? what's your pig version?

Upvotes: 1

Related Questions