Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
<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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB