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

Switch to Plain View
Pig >> mail # user >> Small question


hi all,

I am fairly new to pig.Can any one tell me how to write below hive
query in pig latin.

In this query iam using Cartesian join to achieve instring or contains in java.

Example

col1 -- 145678341212

col2 -- %67834%

insert into table t1

select t2.col1, t3.col2

from table2 t2

join table3 t3

WHERE t3.col2 IS NOT NULL

AND t2.col1 LIKE CONCAT(CONCAT('%',t3.col2),'%')

Regards
abhi
+
Abhishek 2012-10-12, 14:05
+
Arun Ahuja 2012-10-12, 15:26
+
Abhishek 2012-10-12, 16:54