Clickhouse with MaxMind GeoIp2/GeoLite2

[Alexey Kupershtokh]

I've created a simple project in order to show how to setup integration of ClickHouse with MaxMind GeoIp2/GeoLite2 dictionaries for geolocation.

Link: https://github.com/AlexeyKupershtokh/clickhouse-maxmind-geoip

What's inside:

• Dictionary definitions for integrating GeoLite2 or GeoIp2 dictionaries into ClickHouse database.
• Table definitions based on these dictionaries.
• Query examples of how you can use them with example results.
• Dockerfile / docker-compose.yml files for starting ClickHouse with the GeoLite2 dictionaries inside for fast experimenting.

The speed is blazing fast, on a single server node it can geolocate about 50-100M IPs per second. IPs are non-unique, 50% of them are geolocated successfully.

[Stefán Baxter]

Great Alexey, thank you

--
You received this message because you are subscribed to the Google Groups "ClickHouse" group.
To unsubscribe from this group and stop receiving emails from it, send an email to clickhouse+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/0d6d93f3-cb7e-44c6-b02d-23f161c56a00%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andrei Terentev]

Great job! Very helpful.

To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/CA%2BqXrHii0qUhEOW1aQ9Es86_xOAQgnVyLMDZF%2BF7HS7hmyWO2w%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Andrei Terentev

Head of Development at divvit.com