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.

Finding geo location from ip address in hive

Finding geo location from ip address in hive

Rising Star

Hi,

 

I have a Hive table which has ip address. How can I find geo location such as city, zip from it?

 

hive> desc ad_data;

OK

ad_id string
id_segment bigint
ip string
datecreate string
action string
utc_date string
utc_hour string

 

Thanks