Geolocation using IP?

This topic contains 1 reply, has 2 voices, and was last updated by  Chris Lim 1 year, 4 months ago.

  • Creator
    Topic
  • #41684

    Pawel Kowalski
    Participant

    Hi,
    On one of Tutorials we can see nice map in excel with cities where users come from.
    But there is one hidden issue – it the tutorial, we have CITY attribute provided.

    Is there any pig function (UFD) to resolve City name from IP address from a log file?

    I’ve searched the Internbet, but the only solution I found was to download an IP database with cities attached.

    Thanks for your replies.
    Pawel

Viewing 1 replies (of 1 total)

You must be to reply to this topic. | Create Account

  • Author
    Replies
  • #41691

    Chris Lim
    Member

    You can check this excel add-in if this could help you: IP2Location Excel Add-in

    Collapse
Viewing 1 replies (of 1 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.