This example uses the default Converter class that ships with the IPGeo function (geolite 1.2.8), and requires that the files GeoLiteCity.dat and GeoLiteCityv6.dat are installed on the ML Engine.
Input
- Input table: ipgeo_1, as in IPGeo Example 1: IP Database Stored as ML Engine File
SQL Call
SELECT * FROM IPGeo ( ON ipgeo_1 USING IpAddressColumn ('ip') Accumulate ('id', 'ip') ) AS dt ORDER BY 1;
Output
The output is the same as in IPGeo Example 1: IP Database Stored as ML Engine File.