Hi Andy,

SELECT parse_url(url, 'QUERY', 'q') as query FROM table

You can specify a query key. I did not test it in vanilla Hive 4.x but it
works in Cloudera's Hive RPM(0.4.1)

Youngwoo

2010/3/9 Andy Kent <[email protected]>

> We have a query like...
>
> SELECT parse_url(url, 'QUERY:q') as query FROM table
>
> I'm sure this used to work in hive 0.4.1 and the docs suggest that
> 'QUERY:key' should extract the relevant key from a query string but it
> always seems to return NULL in 0.5.0 is this a regression? or maybe the
> parse_url() API has changed?
>
> Thanks,
> Andy

Reply via email to