hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "J. Rottinghuis" <jrottingh...@gmail.com>
Subject Re: Small question
Date Wed, 03 Oct 2012 18:32:27 GMT
<moved common-user@hadoop.apache.org to bcc and added user@pig.apache.org>

Best asked on the Pig users list.

Cheers,

Joep

On Wed, Oct 3, 2012 at 7:04 AM, Abhishek <abhishek.dodda1@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
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message