Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ESRI spatial functions

Solved Go to solution
Highlighted

ESRI spatial functions

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ESRI spatial functions

@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.

1 REPLY 1

Re: ESRI spatial functions

@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.

Don't have an account?
Coming from Hortonworks? Activate your account here