Hive - getting error while executing dynamic insert and selective select from managed to external table


3 Answer(s)


Hi Manish,
There is permission denied error for the hdfs. Check this error line:
Permission denied: user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x

Please correct the permission.

Hope this helps.
Thanks.

hi Manish,

I see that the Hive query is trying to write data in "/user", not sure what user are you using to execute th query. Login as "Cloudera" user and try. by default, data should be written to "/user/hive/warehouse" which is the warehouse location, or else you can specify the "LOCATION" while creating the table.

Thanks guys!! I was doing sudo hive when going to hive session. Tried just hive and all permission issues got resolved. But thanks for good suggestions.