Setting Parameters

This section provides methods for setting up system parameters for the Spider engine, including methods for built-in databases and migrated databases.

There are different configuration methods for built-in databases and migrated databases respectively. The built-in or migrated databases will be prompted for configuration when FineBI is first started after installation.

For detailed operations, see Initialization Settings.

Built-in Databases

1. Configuration file path: in the finedb folder under %FineBI%\webapps\webroot\WEB-INF\embed.

2. You can access the hsql database through the client, and modify configuration parameters for the table through SQL statements.

For example, if you need to configure the spark_executor_memory parameter to 8G, you can first check whether this parameter exists in the table FINE_CONF_ENTITY.

If the parameter exists in the targeted table, you can directly modify its corresponding value.

The query statement is as follows:

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

3. If the parameter does not exist, you can use SQL statements to add the parameter and the corresponding value.

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

4. After addition, you can see the corresponding fields and parameter values in the table FINE_CONF_ENTITY.

5. After modification, restart FineBI to make it work.

Migrated Databases

For migrated databases, you need to find the table fine_conf_entity in the data table address of the migrated database.

The data in the table is stored in the form of id and value.

For example, if you want to add or change the parameter spark_executor_memory to 8G in MySQL, you can use the following command to modify:

• Check if the parameter spark_executor_memory exists.

select * from fine_conf_entity where id="DistributedOptimizationConfig.spiderConfig.spark_executor_memory"

• Insert the parameter and its value.

INSERT into fine_conf_entity(id,`value`) VALUE("DistributedOptimizationConfig.spiderConfig.spark_executor_memory","8G")

Restart FineBI to make it work.