hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "dhruv kapatel (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13137) Hive parse_url(url,'HOST') returns null values
Date Wed, 24 Feb 2016 08:20:18 GMT

     [ https://issues.apache.org/jira/browse/HIVE-13137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

dhruv kapatel updated HIVE-13137:
---------------------------------
    Description: 
I've table with url stored in it. I want to extract host name from urls.
I've used this query
SELECT parse_url(url,'HOST') AS host FROM table;
It returns null for all rows.
SELECT parse_url('http://www.google.co.in','HOST') returns www.google.co.in.

So hive parse_url() does not support dynamic values ?
 . 
 

  was:
I've table with url stored in it. I want to extract host name from urls.
I've used this query
SELECT parse_url(url,'HOST') AS host FROM table;
It returns null for all rows.
SELECT parse_url('http://www.google.co.in','HOST') returns www.google.co.in.

 . 
 


> Hive parse_url(url,'HOST') returns null values
> ----------------------------------------------
>
>                 Key: HIVE-13137
>                 URL: https://issues.apache.org/jira/browse/HIVE-13137
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.0.1
>         Environment: ubuntu 12.04
>            Reporter: dhruv kapatel
>
> I've table with url stored in it. I want to extract host name from urls.
> I've used this query
> SELECT parse_url(url,'HOST') AS host FROM table;
> It returns null for all rows.
> SELECT parse_url('http://www.google.co.in','HOST') returns www.google.co.in.
> So hive parse_url() does not support dynamic values ?
>  . 
>  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message