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(addr text)¶

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(addr inet4)

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(addr text, code text)¶

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(addr inet4, code text)

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