The parse_url UDF works in general but the common use case is querying
apache logs which do not include the protocol or host portions - you need to
include a concat() call.
Also, the docs on parse_url are wrong around the query parameter parsing
feature. The describe statement above shows the actu
Hi Prakash,
You can extract query string from url using 'parse_url' udf.
hive> describe function parse_url;
OK
parse_url(url, partToExtract[, key]) - extracts a part from a URL
Time taken: 0.024 seconds
hive>
hive> select parse_url('
http://www.example.com/searches/tagged_with?company=2-Opico&pag
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
"/se
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 t