1.0 - 8.00 - IPGeo Example 2: Default Maxmind Geolite Database - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

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.

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.