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.

How do I define ESRI spatial Hive functions to be available across multiple sessions? What happens on Hive service restart?

SOLVED Go to solution
Highlighted

How do I define ESRI spatial Hive functions to be available across multiple sessions? What happens on Hive service restart?

New Contributor

How do I define ESRI spatial Hive functions to be available across multiple sessions? What happens on Hive service restart?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How do I define ESRI spatial Hive functions to be available across multiple sessions? What happens on Hive service restart?

@sivakumar sudhakarannair girijakumari

If you want the function to be available globally, across multiple sessions, you need to create a permanent function,e.g.

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

You should issue "create function" statements via a global script. Assuming that you modified a function, in order to recreate it, you would need first to drop it. This script should be executed as part of Hive service start/restart such that functions will still be available.

drop function ST_AsText as 'com.esri.hadoop.hive.ST_AsText';
1 REPLY 1

Re: How do I define ESRI spatial Hive functions to be available across multiple sessions? What happens on Hive service restart?

@sivakumar sudhakarannair girijakumari

If you want the function to be available globally, across multiple sessions, you need to create a permanent function,e.g.

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

You should issue "create function" statements via a global script. Assuming that you modified a function, in order to recreate it, you would need first to drop it. This script should be executed as part of Hive service start/restart such that functions will still be available.

drop function ST_AsText as 'com.esri.hadoop.hive.ST_AsText';