Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - parse_url returning NULL


Copy link to this message
-
parse_url returning NULL
Mohammad Tariq 2013-06-10, 21:59
Hello list,

         I have a file stored in my HDFS which contains some urls. File
looks like this :
abc.in
xyz.net
http://tariq.com
http://tariq.in/sompath

And i'm trying to get the hostnames from these urls using *parse_url*. It
works fine except for the urls which do not contain any scheme. So when I
issue

hive> select parse_url(url, 'HOST') from url;

it gives me :

NULL
NULL
tariq.com
tariq.in

Could someone please point out the mistake? Many thanks.

Warm Regards,
Tariq
cloudfront.blogspot.com
+
Edward Capriolo 2013-06-10, 22:10
+
Mohammad Tariq 2013-06-10, 22:17