SELECT * FROM IPGeo ( ON ipgeo_1 IpAddressColumn ('ip') IpDatabaseLocation ('/home/maxmind/') Converter ('MaxMindLite.jar', 'com.asterdata.sqlmr.analytics.location.ipgeo.MaxMindLite') Accumulate ('id', 'ip') ) ORDER BY 1;
SELECT * FROM IPGeo ( ON ipgeo_1 IpAddressColumn ('ip') IpDatabaseLocation ('/home/maxmind/') Converter ('MaxMindLite.jar', 'com.asterdata.sqlmr.analytics.location.ipgeo.MaxMindLite') Accumulate ('id', 'ip') ) ORDER BY 1;