I have loaded my application logs in BigQuery and I need to calculate country based on IP address from those logs. I have written a join query between my table and a GeoIP mapping table that I downloaded from MaxMind. An ideal query would be OUTER JOIN with range filter, however BQ supports only = in join conditions. So the query does an INNER JOIN and handles missing values in each side of the JO
db = MaxMindDB.new('./GeoLite2-City.mmdb') ret = db.lookup('74.125.225.224') ret.found? # => true ret.country.name # => 'United States' ret.country.name('zh-CN') # => '美国' ret.country.iso_code # => 'US' ret.city.name(:fr) # => 'Mountain View' ret.subdivisions.most_specific.name # => 'California' ret.location.latitude # => -122.0574 ret.to_hash # => {"city"=>{"geoname_id"=>5375480, "names"=>{"de"=>
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
