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


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