https://community.cloudera.com/t5/Archives-of-Support-Questions/ESRI-spatial-functions/m-p/167106#M37087 <P><A href="https://community.hortonworks.com/users/12317/sivakumarsudhakarannairgirijakumari.html">@sivakumar sudhakarannair girijakumari</A></P><P>If you wish to use a function only during the active session, use temporary keyword in its creation statement.</P><P>Examples:</P><TABLE><TBODY><TR><TD>create temporary function ST_AsText as 'com.esri.hadoop.hive.ST_AsText';</TD></TR><TR><TD>create temporary function ST_Intersects as 'com.esri.hadoop.hive.ST_Intersects';</TD></TR></TBODY></TABLE><P>This is not specific for ESRI spatial functions. It works similarly for any user defined function (UDF) when invoked in Hive.</P> Sun, 07 Aug 2016 01:16:40 GMT cstanca 2016-08-07T01:16:40Z https://community.cloudera.com/t5/Archives-of-Support-Questions/ESRI-spatial-functions/m-p/167105#M37086 <P></P><P>How do I set session-based only ESRI spatial functions?</P> Sat, 06 Aug 2016 01:58:29 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ESRI-spatial-functions/m-p/167105#M37086 sivakumar_sudha 2016-08-06T01:58:29Z https://community.cloudera.com/t5/Archives-of-Support-Questions/ESRI-spatial-functions/m-p/167106#M37087 <P><A href="https://community.hortonworks.com/users/12317/sivakumarsudhakarannairgirijakumari.html">@sivakumar sudhakarannair girijakumari</A></P><P>If you wish to use a function only during the active session, use temporary keyword in its creation statement.</P><P>Examples:</P><TABLE><TBODY><TR><TD>create temporary function ST_AsText as 'com.esri.hadoop.hive.ST_AsText';</TD></TR><TR><TD>create temporary function ST_Intersects as 'com.esri.hadoop.hive.ST_Intersects';</TD></TR></TBODY></TABLE><P>This is not specific for ESRI spatial functions. It works similarly for any user defined function (UDF) when invoked in Hive.</P> Sun, 07 Aug 2016 01:16:40 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ESRI-spatial-functions/m-p/167106#M37087 cstanca 2016-08-07T01:16:40Z