Venkatarao N
Venkatarao N

Reputation: 245

Select one relations all fields & one or two from other relation on PIG JOIN, how?

A = load '$input1' using pigStorage() AS (a,b,c,d,e)
B = load '$input2' using pigStorage() AS (a,b1,c1,d1,e1)
C = JOIN A by a, B by a; 
D = do something;

'D' should be of format (a,b,c,d,e,b1)

How to achieve this?

Upvotes: 0

Views: 813

Answers (1)

reo katoa
reo katoa

Reputation: 5801

D = FOREACH C GENERATE A::a .. A::e, B::b AS b1;

Upvotes: 2

Related Questions