Network Functions and Operators

Prerequisites

Apache Tajo provides network functions and operations using GeoIP databases. To use these functions and operations, the GeoIP database should be precedently installed in local disks of all the workers. (Please refer the install instruction in http://dev.maxmind.com/geoip/legacy/downloadable/)

Once the GeoIP database is installed, you should specify the install location in conf/tajo-site.xml as follows.

<property>
  <name>tajo.function.geoip-database-location</name>
  <value>/path/to/geoip/database/file</value>
</property>

Supported Functions

geoip_country_code(string addr)

Convert an ipv4 address string to a geoip country code.

Parameters:addr – ipv4 address string
Return type:text
Example:
select geoip_country_code('163.152.71.31')
> 'KR'
geoip_country_code(inet4 addr)

Convert an ipv4 address to a geoip country code.

Parameters:addr – ipv4 address
Return type:text
Example:
select geoip_country_code(163.152.71.31)
> 'KR'
geoip_in_country(string addr, string code)

If the given country code is same with the country code of the given address, it returns true. Otherwise, returns false.

Parameters:
  • addr – ipv4 address string
  • code – country code
Return type:

boolean

Example:
select geoip_in_country('163.152.71.31', 'KR')
> true
geoip_in_country(inet4 addr, string code)

If the given country code is same with the country code of the given address, it returns true. Otherwise, returns false.

Parameters:
  • addr – ipv4 address
  • code – country code
Return type:

boolean

Example:
select geoip_in_country(163.152.71.31, 'KR')
> true