Home | About | Sematext search-lucene.com search-hadoop.com
 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
Amr Awadallah 2010-03-09, 02:51
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