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
Hi,

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

In Pig,

Can i write like below

A= Table1
B=Table2
C=Table3

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.

Raj
+
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