Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Implementing Hive UDF?

Highlighted

Implementing Hive UDF?

Rising Star

Hello,

 

I have a hive table with ip_address column. How can I find country, city and Zip code from that ip_address column?

 

I see a udf written:

https://github.com/edwardcapriolo/hive-geoip

 

Where do I get these Jar files from? 

 

geo-ip-java.jar;

hive-udf-geo-ip-jtg.jar;

 

The udf says we need separate database:

http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz

I got the database from above URL

 

Any feedback will be appreciated.

 

Thanks,

Rio