ESRI spatial functions

[#1]

How do I set session-based only ESRI spatial functions?

[#2 · Accepted solution]

@sivakumar sudhakarannair girijakumari

If you wish to use a function only during the active session, use temporary keyword in its creation statement.

Examples:

create temporary function ST_AsText as 'com.esri.hadoop.hive.ST_AsText';

create temporary function ST_Intersects as 'com.esri.hadoop.hive.ST_Intersects';

This is not specific for ESRI spatial functions. It works similarly for any user defined function (UDF) when invoked in Hive.