Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB