<moved [email protected] to bcc and added [email protected]>
Best asked on the Pig users list. Cheers, Joep On Wed, Oct 3, 2012 at 7:04 AM, Abhishek <[email protected]> wrote: > Hi all, > > Below hive query in pig latin how to do that. > > 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 > > >
