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

Switch to Plain View
Hadoop, mail # user - Small question


+
Abhishek 2012-10-03, 14:04
Copy link to this message
-
Re: Small question
J. Rottinghuis 2012-10-03, 18:32
<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
>
>
>
+
Dmitriy Ryaboy 2012-10-04, 06:25