IPGeo Example 2: Default Maxmind Geolite Database - Teradata Vantage

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.