Small question

[Abhishek]

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