How Do I Handle the Error Reported When Setting hive.exec.stagingdir on the Hive Client?

Scenario

By default, Hive client does not support the modification of the temporary directory created when data is inserted. If you run set hive.exec.stagingdir=xxx on the client to modify the temporary directory, the following error message is displayed:

Answer

hive.exec.stagingdir is used to set the temporary directory created when data is inserted. Data may be lost when concurrently inserted into a same table. By default, this parameter is not allowed. If no data will be inserted concurrently, you can set this parameter on the client. For details, see Procedure.

Procedure

1. Log in to FusionInsight Manager, choose Clusters > Services > Hive. On the displayed page, click the Configurations tab and select All Configurations. Choose HiveServer(Role) > Customization, and add hive.conf.internal.variable.list and its value hive.added.files.path,hive.added.jars.path,hive.added.archives.path to the parameter file hive-site.xml.
2. Click Save. In the dialog box that is displayed, click OK.
3. Click the Instance tab, select all HiveServer instances, click More > Restart Instance, enter the administrator password, and click OK to restart the HiveServer instances.