question Re: Getting error on hive in Support Questions

Getting error on hive

kunda — Thu, 03 Mar 2022 11:59:36 GMT

INSERT into `edl_dev_sathyam_raw_mpi_fnxnegotiat`.`negotiation` VALUES (1,'sat', 0)

when running above query in impala it was executing successfully but not executing in hive

thouing error like below

could guide on this how to fix

"""Permission denied: user=hive, access=WRITE, inode="/user/sathyam.kunda/dev/data/raw/multiplan/mpi_fnxnegotiator.db/negotiationteam":impala:edlpocdev:drwxr-xr-x at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:553)"""

Re: Getting error on hive

marudhu_ramaiah — Fri, 04 Mar 2022 11:19:20 GMT

hive user does not have access to dir /user/sathyam.kunda/dev/data/raw/multiplan/mpi_fnxnegotiator.db/negotiationteam. drwxr-xr-x shows that other group users has only read and execute access but not write. pls check the permissions.

Re: Getting error on hive

VidyaSargur — Tue, 08 Mar 2022 09:31:09 GMT

@marudhu_ramaiah, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.