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

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


Copy link to this message
-
Small question
Abhishek 2012-10-03, 14:04
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