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
Updated on 2023-11-30 GMT+08:00

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:

  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.

  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 > Services > Hive. On the page that is displayed, choose Configurations > All Configurations > HiveServer > Security.

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