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
Hive >> mail # user >> regex_extract in hive


+
prakash sejwani 2010-03-08, 16:31
Copy link to this message
-
Re: regex_extract in hive
remove the leading and trailing /, no need for those

-- amr

On 3/8/2010 8:31 AM, prakash sejwani wrote:
> Hi All,
>         i have a query below
>         SELECT regexp_extract(resource,'/\&tag=([^\&]+)/') FROM a_log;
>
>        it gives black result
>
>        the sample resource string is like this
> "/searches/tagged_with?company=2-Opico&page=8&product=36154-7653-BACKUP-PLATE-F-STORAGE-STAND&tag=demco"
> i want to extract demco out of it
>
> please help me with this
>
>
> thanks'
> prakash
> Econify Infotech
> Mumbai
>
+
김영우 2010-03-09, 04:10
+
Nick Dimiduk 2010-03-10, 19:37
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