<moved common-user@hadoop.apache.org to bcc and added u...@pig.apache.org>
Best asked on the Pig users list.
Cheers,
Joep
On Wed, Oct 3, 2012 at 7:04 AM, Abhishek <abhishek.dod...@gmail.com> 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
>
>
>
