Help Center/ MapReduce Service/ User Guide (Kuala Lumpur Region)/ Troubleshooting/ Using Hive/ "Cannot modify xxx at runtime" Is Reported When the set Command Is Executed in a Security Cluster
Updated on 2022-12-14 GMT+08:00

"Cannot modify xxx at runtime" Is Reported 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:

  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 > Name of the target cluster > Services > Hive > Configurations > All Configurations > HiveServer > Security.

  2. Add the command parameters to be executed to the hive.security.authorization.sqlstd.confwhitelist.append configuration item.
  3. Click Save and restart HiveServer.

Solution 2:

  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 > Name of the target cluster > Services > Hive > Configurations > All Configurations > HiveServer > Security.

  2. Locate hive.security.whitelist.switch and select OFF. Click Save and restart HiveServer.