You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Matouk IFTISSEN <ma...@ysance.com> on 2014/06/06 23:28:40 UTC

Hive: regexp_extract to extract muti match in one line??

Hé Geeks,
 I have a table that each row contains data (line), and I want to extract
all patterns that match  in each line, the actuel comportement of the udf
rexexp_extract returns me one occurence match!! but with  regexp_replace
 the comportement is différent (replace all pattern match in line)
how can I extract all pattern match in each line ??

select (line,'*.(pattern_match_group).*, index_group) as truc from my_table

 Thanks by advance ;)
Matouk
-- 

*Matouk IFTISSEN | Consultant BI & Big Data[image: http://www.ysance.com] *
24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/>
Fax : +33 1 73 72 97 26
*Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook
<https://www.facebook.com/pages/Ysance/131036788697> | Google+
<https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts>
| LinkedIn
<http://www.linkedin.com/company/ysance> | Newsletter
<http://www.ysance.com/nous-contacter.html>*
*Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel
<http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>*