Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Pig, mail # user - Joining 3 tables in Pig

Copy link to this message
Joining 3 tables in Pig
Raj hadoop 2013-04-25, 02:39

I have a where condition in sql query like below
 Table1.col1=Table2.col3 and Table2.col2=Table3.col1 and

In Pig,

Can i write like below

A= Table1

Joins = join A by col1,B by col3 and  B by col2,C by col1 and C by col3,A
by cole

Please help me.

j.barrett Strausser 2013-04-25, 03:07
Bill Graham 2013-04-25, 04:52
Russell Jurney 2013-04-25, 08:40
Raj hadoop 2013-04-26, 16:52