On this page

Symptom
Procedure

Show all

Help Center/ MapReduce Service/ Troubleshooting/ Using Hive/ Error Message "Cannot modify xxx at runtime" Is Displayed When the set Command Is Executed in a Security Cluster

Error Message "Cannot modify xxx at runtime" Is Displayed When the set Command Is Executed in a Security Cluster

Updated on 2024-12-18 GMT+08:00

View PDF

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

Previous topic: Failed to Start Hive

Next topic: Specifying a Queue When Submitting a Hive Task

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback