search

Esri / spatial-framework-for-hadoop

The Spatial Framework for Hadoop allows developers and data scientists to use the Hadoop data processing system for spatial data analysis.
Apache License 2.0
369 stars 159 forks source link

permission denied error for the spatial function "st_aggr_union" #179

Closed bgajula closed 2 years ago

bgajula commented 3 years ago

Hi,

I am trying to use st_aggr_union function using a permanent UDF created on hive. Used the following command to create it

DROP FUNCTION IF EXISTS udf_db.st_aggr_union; CREATE FUNCTION p0_bcc_eudswr.st_aggr_union AS 'com.esri.hadoop.hive.ST_Aggr_Union' USING JAR 'hdfs://user/esri/lib/spatial-sdk-hive-2.1.0.jar';

when running the udf against the spatial data, I am getting bellow error

Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [userxxxx] does not have [SELECT] privilege on [@_udf_db/st_aggr_union] (state=42000,code=40000)

We have created many other spatial functions and using them without any issues.

Could you please help me with this.

randallwhitman commented 3 years ago
bgajula commented 3 years ago

Hi,

Does the error happen with the other aggregate functions, such as aggregate convex hull or aggregate intersection? --> It is happening with other two aggregate functions as well Does the error happen when running the query as the Hive super-user (for testing)? --> This is yet to be checked. I will update on this What happens if you CREATE FUNCTION st_aggr_union without p0_bcc_eudswr. in front? --> This is happening irrespective of the DB.