NIFI PutHiveQL Permission denied error : Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [svcda_nifi] does not have [SELECT] privilege on [default/values__tmp__table__4/*]
I created a data flow with NIFI, in which I put: SelectHiveQL ===> ConvertAvroToJSON ====> SplitJson ====> EvaluateJsonPath ===> ReplaceText ===> PutHiveQL.
All the processors work well except the last "PutHiveQL" which shows me the following error.
thank you in advance for your help
" The problem seems to be around the default temporary
table (at least, it is failing here before anything else). The query you
make with the "VALUES" part work like this :
- it creates a temporary hive table with the line to be inserted
- it then queries that temporary table for inserting the data into the target table
From the output I see, the temporary table is created [default/values__tmp__table__3]. But the user does not have "select" permission on it.
I guess that a workaround would be to grant "SELECT" on the
database "default" but this could bring some security issues for you
(since the user will have read permission on all the tables inside