Skip to content

phaelmoita/presto-phaelmoita-udfs

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

presto-phaelmoita-udfs Build Status

With that project you will be able to get geoip using Maxmind Database

Some issues are needs like:

  • Load database file from s3 or hdfs

Call this funcion is simple, just with 3 params:

  • ip
  • path_database
  • type_result (country = 0, state = 1, city = 2)
select geo_ip('192.64.147.150', '/GeoIP2-City.mmdb', '0'), geo_ip('192.64.147.150', '/GeoIP2-City.mmdb', '1'), geo_ip('192.64.147.150', '/GeoIP2-City.mmdb', '2')

AWS EMR

I added a single script to bootstrap your cluster emr (bootstrap-emr.sh) so that you can install the plugin when cluster is started.

About

udf geoip using maxmind database

Resources

Stars

Watchers

Forks

Packages

No packages published