Error Message "Cannot modify xxx at runtime" Is Displayed When the set Command Is Executed in a Security Cluster
Symptom
The following error is reported when running the set command:
0: jdbc:hive2://192.168.1.18:21066/> set mapred.job.queue.name=QueueA;Error: Error while processing statement: Cannot modify mapred.job.queue.name at list of params that are allowed to be modified at runtime (state=42000,code=1)
Procedure
Solution 1:
- Log in to Manager and modify Hive parameters.
- MRS Manager: Log in to MRS Manager and choose Services > Hive > Service Configuration. Set Type to All and choose HiveServer > Security.
- FusionInsight Manager: Log in to FusionInsight Manager and choose Cluster > Services > Hive. On the page that is displayed, choose Configurations > All Configurations > HiveServer > Security.
- Add the command parameters to be executed to the hive.security.authorization.sqlstd.confwhitelist.append configuration item.
- Click Save and restart HiveServer.
Solution 2:
- Log in to Manager and modify Hive parameters.
- MRS Manager: Log in to MRS Manager and choose Services > Hive > Service Configuration. Set Type to All and choose HiveServer > Security.
- FusionInsight Manager: Log in to FusionInsight Manager and choose Cluster > Services > Hive. On the page that is displayed, choose Configurations > All Configurations > HiveServer > Security.
- Locate hive.security.whitelist.switch and select OFF. Click Save and restart HiveServer.
Parent topic: Using Hive
- Symptom
- Procedure