Skip to content
GeoIP Functions for Apache Drill
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src/main
.gitignore
LICENSE
README.md
pom.xml

README.md

GeoIP Functions for Apache Drill

This is a collection of GeoIP functions for Apache Drill. These functions are a wrapper for the MaxMind GeoIP Database.

IP Geo-Location is inherently imprecise and should never be relied on to get anything more than a general sense of where the traffic is coming from.

  • getCountryName( <ip> ): This function returns the country name of the IP address, "Unknown" if the IP is unknown or invalid.
  • getCountryConfidence( <ip> ): This function returns the confidence score of the country ISO code of the IP address.
  • getCountryISOCode( <ip> ): This function returns the country ISO code of the IP address, "Unknown" if the IP is unknown or invalid.
  • getCityName( <ip> ): This function returns the city name of the IP address, "Unknown" if the IP is unknown or invalid.
  • getCityConfidence( <ip> ): This function returns confidence score of the city name of the IP address.
  • getLatitude( <ip> ): This function returns the latitude associated with the IP address.
  • getLongitude( <ip> ): This function returns the longitude associated with the IP address.
  • getTimezone( <ip> ): This function returns the timezone associated with the IP address.
  • getAccuracyRadius( <ip> ): This function returns the accuracy radius associated with the IP address, 0 if unknown.
  • getAverageIncome( <ip> ): This function returns the average income of the region associated with the IP address, 0 if unknown.
  • getMetroCode( <ip> ): This function returns the metro code of the region associated with the IP address, 0 if unknown.
  • getPopulationDensity( <ip> ): This function returns the population density associated with the IP address.
  • getPostalCode( <ip> ): This function returns the postal code associated with the IP address.
  • getCoordPoint( <ip> ): This function returns a point for use in GIS functions of the lat/long of associated with the IP address.
  • getASN( <ip> ): This function returns the autonomous system of the IP address, "Unknown" if the IP is unknown or invalid.
  • getASNOrganization( <ip> ): This function returns the autonomous system organization of the IP address, "Unknown" if the IP is unknown or invalid.
  • isEU( <ip> ), isEuropeanUnion( <ip> ): This function returns true if the ip address is located in the European Union, false if not.
  • isAnonymous( <ip> ): This function returns true if the ip address is anonymous, false if not.
  • isAnonymousVPN( <ip> ): This function returns true if the ip address is an anonymous virtual private network (VPN), false if not.
  • isHostingProvider( <ip> ): This function returns true if the ip address is a hosting provider, false if not.
  • isPublciProxy( <ip> ): This function returns true if the ip address is a public proxy, false if not.
  • isTORExitNode( <ip> ): This function returns true if the ip address is a known TOR exit node, false if not.

This product includes GeoLite2 data created by MaxMind, available from https://www.maxmind.com.

You can’t perform that action at this time.