Reply
Highlighted
rio
Explorer
Posts: 48
Registered: ‎04-18-2014

Finding geo location from ip address in hive

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