Parameter configuration method

This section provides system parameter configuration methods related to spider engine, including configuration methods of built-in database and migration database.

The configuration method is divided into built-in database and migration database. The built-in or migration database is prompted to configure when installing finebi for the first time. Please refer to Setup Initialization for detailed operations.

Their configuration methods are described below.

1. built-in database

• Configuration file path: %FineBI%\webapps\webroot\WEB-INF\embed in finedb, as shown in the following figure:

• You can connect to the hsql database through the client and modify the table configuration parameters through SQL statements.For example, we need to configure spark_executor_memory parameter is 8G, you can first query whether the parameter exists in FINE_CONF_ENTITY table. If the parameter exists, the value corresponding to the parameter can be directly modified. The query statement is as follows:

SELECT * FROM FINE_CONF_ENTITY WHERE 
ID='DistributedOptimizationConfig.spiderConfig.spark_executor_memory'

• If the query does not have this parameter, the SQL statement can be used to add the parameter and the corresponding value 8G, as shown in the following figure:
  

INSERT INTO FINE_CONF_ENTITY 
VALUES('DistributedOptimizationConfig.spiderConfig.spark_executor_memory','8G')

• After the addition is successful, in the FINE_CONF_ENTITY table, we can see the corresponding fields and parameter values. As shown below:
  

• Restart FineBI to take effect.

2. migration database

• If it is a migration database, the table fine_conf_entity in the migration database needs to be found in the data table address, as shown in the following figure:
  

• The data in this table are stored in the form of id and value, as shown in the following figure:

• For example, you need to add or change the parameter spark_executor_memory to 8g. Take MySQL as an example, use the following command to modify:
  

  #Find whether there are parameters spark_executor_memory select * from fine_conf_entity where id="DistributedOptimizationConfig.spiderConfig.spark_executor_memory"
  #Insert parameter and parameter value INSERT into fine_conf_entity(id,`value`) VALUE("DistributedOptimizationConfig.spiderConfig.spark_executor_memory","8G")

• Restart FineBI to take effect.