hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matouk IFTISSEN <matouk.iftis...@ysance.com>
Subject How to extract multi-match in one line with regexp_extract function?
Date Tue, 10 Jun 2014 10:11:47 GMT
Hello,
 I have a table that each record is in one line  (line), and I want to
extract all patterns those match  in each line, the actuel comportement of
the udf regexp_extract returns one occurence match!! but with
 regexp_replace  the comportement is différent (replace all pattern match
in line)
how can I extract all patterns those  match in each line ??

select (line,'*.(pattern_match).*, index_group) as matchs from my_table

 Thanks by advance ;)


-- 

*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/>*

Mime
View raw message