反馈已提交
网络繁忙
BI server version
JAR package
fine_conf_entity visual configuration plugin
Functional changes
5.1
2020-02-28
V1.0
-
5.1.12
V1.2
Added support for modifying related parameters
5.1.13
V1.4
Added support for "custom parameter configuration"
5.1.14
V1.5
5.1.15
V1.6
1) Added support for "LDAP authentication" parameter configuration
2) Delete parameter: SystemOptimizationConfig.ignoreBaseTableRedMarkCheck
5.1.16
V1.7
Added support for "Plugin Auto Update" parameter configuration
V1.9
Added support for parameter configuration of "Set the time period that updates can occupy high-performance resources"
Added support for "Plugin Package Integrity Check" parameter configuration
Some configuration information in the platform is recorded in the fine_conf_entity table of FineDB , which can only be changed by modifying the table fields.
Users can safely modify the relevant configuration through the " fine_conf_entity visual configuration plugin".
Note: Do not use methods other than this plug-in to modify the FineDB file, it may cause irreparable bugs, and you must bear the consequences yourself.
Please contact our technical support team (international@fanruan.com) to get the fine_conf_entity pulgin.
For plug-in installation method, please refer to Plug-in Management
After the plug-in is successfully installed, the super administrator logs in to the data decision system, clicks "Manage", and adds the "System Tools" setting. As shown below:
Note: Since the modification of FineDB is very important and has a great impact, it only supports the operation of the super tube , and does not support the operation of the sub-administrator.
The configuration method supports the following two:
·Select parameter configuration: The drop-down box of the system parameter name (key) lists the fine_conf_entity parameters that support configuration. The user can directly select the parameter in the drop-down box and configure the parameter value (value).
·Custom parameter configuration: The user can input the fine_conf_entity parameter name (key) that supports configuration, and the parameter value (value) will automatically jump out, and the user can modify and save the parameter value.
The parameters supported by the two configuration methods are exactly the same. The configuration parameters and parameter values in fine_conf_entity that can be modified are shown in the following table:
V1.0 and above plugins all support:
parameter name
Parameter Description
parameter value
BackupConfig.customKeyLength
Backup conf table, customize id length
parameter value must be a positive integer
Default is 1500
BackupConfig.customValueLength
Backup conf table, customize value length
The default value is 65536
CacheConfig.maxMemSize
Shared dataset cache space limit
The parameter value must be a non- negative integer
The default value is 4194304
ClusterTimeMonitorConfig.permitCount
In the cluster single time error detection task, the minimum number of successes in multiple error analysis
Default is 1
ClusterTimeMonitorConfig.permitError
In the cluster single time error detection task, the allowable time error value, in ms
parameter value must be a positive long integer
Default is 10000
ClusterTimeMonitorConfig.sumCount
The total number of attempts at error analysis in the cluster single time error detection task
Default is 3
ConfigVersion.versionOrdinal
Configuration version number
The default is the current version number
CustomConfig.absPositionOfFloat
Whether the floating element is displayed in an absolute position (not affected by cell expansion)
The parameter value needs to be a boolean, the default is false
false: do not display in absolute position (not affected by cell expansion)
true: display in absolute position (affected by cell expansion)
CustomConfig.columnMatchRuleForWidgetValue
Whether the data field is case sensitive
parameter values are as follows, the default is case_ignore
case_ignore : case insensitive
case_sensitive : case sensitive
CustomConfig.dataTransType
Define the transmission form of filling and submitting, and verify the front-end template data in the request
The parameter values are as follows, the default is xml
xml: transfer in xml string format
json: transfer in json string format
CustomConfig.excelAdjustHeight
Excel export row height factor
parameter value must be a non- negative single-precision floating-point type
Default is 20.1
CustomConfig.excelAdjustWidth
Excel export column width factor
Default is 34.742
CustomConfig.exportFullImg4Excel
Whether to export the complete picture when exporting from Excel
false: When exporting from Excel, the complete picture is not exported
true: When exporting from Excel, export the complete picture
CustomConfig.printWidget
Whether to export/print controls (currently supports printing checkbox and checkbox group controls)
false: do not export/print controls
true: export/print controls
CustomConfig.screenScaleEnabled
Control Designer Zoom
The parameter value needs to be boolean, the default is true
false: turn off designer scaling
true: enable designer scaling
CustomConfig.wordAdjustHeight
Word exports the value used to adjust the line height to prevent blank pages from appearing when the content height is at certain thresholds
Default is 2
FSConfig.authorizeAttr.postAuthority
Switches for assigning permissions by position
false: Turn off assignment permissions by position
true: Enable assignment by position permission
FSConfig.loginConfig.forceRedirectAfterLogin
Force jump to:
http://ip:port/webroot/decision/
false: Do not force jump after login
true: Force jump after login
FileServerMonitorConfig.messageInterval
ftp abnormal message notification frequency, unit h
FineFocusPointConfig.allowRecordFitInfo _
Whether to allow recording of adaptive buried points
false: do not allow recording of adaptive buried points
true: allows recording of adaptive buried points
GcConfig.gcThreshold
Template version control storage optimization condition threshold, the unit is the number of files
The default value is 300
HotBackConf.master
Hot Standby Master Node Configuration
hostname of the master node
HotBackConf.slave
Standby node configuration
Note: 2021-02-05 and later JARs can configure this parameter
hostname of the standby node
IntelliLogConfig.expired
Template cache invalidation time
parameter value needs to be a long integer
The default value is 18000
IntelliReleaseConfig.defaultCellCount
Default base for the number of to-be-killed session slots
Default is 1000000
IntelliReleaseConfig.highInterruptAgainRate
The second time to release more than (default number of grids * this ratio) sessions during high load
parameter value must be a non- negative double-precision floating-point type
The default value is 0.6
IntelliReleaseConfig.highInterruptRate
The first time to release more than (default number of grids * this ratio) sessions during high load
The default value is 0.8
IntelliReleaseConfig.highKillRate
The proportion of sessions released for the first time under high load exceeds this value and does not trigger the second time
The default value is 0.1
IntelliReleaseConfig.interruptRate
Default ratio of kill session tiles
The default value is 0.3
IntelliReleaseConfig.jvmSupport
the current version of jdk support smart release ?
false: the current version of jdk does not support smart release
true: the current version of jdk supports smart release
IntelliReleaseConfig.releaseSessionInteval
The time interval for releasing the trigger
The default value is 20
IntelliReleaseConfig.terribleInterruptAgainRate
The second time to release more than (default number of grids * this ratio) sessions when the load is too high
Default is 0.4
IntelliReleaseConfig.terribleInterruptRate
The first time to release more than (default number of grids * this ratio) sessions when the load is too high
Default is 0.6
IntelliReleaseConfig.terribleKillRate
If the proportion of sessions released for the first time under ultra-high load exceeds this value, the second time will not be triggered
Default is 0.2
IntelliReleaseConfig.waitInLineRate
Each session has this chance to queue under high load
parameter value must be a double-precision floating-point type
Default is 0.9
JarConsistenceConfig.messageInterval
jar inconsistency exception message notification frequency, unit h
Default is 6
LoadConfig.majorExtremeTerribleThreshold
majorgc , if the ratio of the size of the objects remaining in the old age to the size of the old age exceeds this value, it is considered a limit load.
Default is 0.95
LoadConfig.majorHighThreshold
majorgc , if the ratio of the size of the objects remaining in the old age to the size of the old age exceeds this value, it is considered a high load
Default is 0.7
LoadConfig.majorTerribleThreshold
majorgc , if the ratio of the size of the objects remaining in the old age to the size of the old age exceeds this value, it is considered an ultra-high load.
Default is 0.85
LoadConfig.minorHighThreshold
minorgc , the ratio of the rate of objects promoted to the old age to the eden area exceeds this value, which is considered a high load
Default is 0.04
LoadConfig.minorMidThreshold
minorgc , the ratio of the rate of objects promoted to the old age to the eden area exceeds this value, which is considered a medium load
Default is 0.02
LoadConfig.minorTerribleThreshold
minorgc , the ratio of the rate of objects promoted to the old age to the eden area exceeds this value, which is considered an ultra-high load
Default is 0.06
MobileConfig.appMsgProxy
App message broker
The parameter value is a non-empty string
Default is __EMPTY__
The proxy server address format is:
http://ip:port/mobile/push/message/send
MobileConfig.disableEncryptPassword
Control whether the password for mobile login is encrypted
false: The password for mobile login is not encrypted
true: Password encryption for mobile login
MobileConfig.persistedAttach
Whether to persist scheduled images when starting the server
Parameter value needs to be boolean
By default, the first startup is false, and then it is true
false: Persist timing scheduling images when starting the server
Do not persist scheduled images when starting the server
MobileConfig.productPlan
Whether to join the developer program
false: do not join the developer program
true: Join the developer program
MobileConfig.templateFetchTimeout
template timeout
The parameter value must be an integer
Default is -1
When the field value is less than or equal to 0, the request timeout is not limited
When the field value is greater than 0, it will take effect according to the set time
QuartzConfig.maxConnections
The maximum number of connections for the timing scheduling module (supported in versions after August 16, 2019)
The default value is 50
QuartzConfig.threadCount
The maximum number of threads in the timing scheduling module (supported in versions after August 16, 2019)
Default is 100
RedisClusterConfig.maxConnection
Redis Cluster connection pool maximum total number of instances
The default value is 200
RedisClusterMonitorConfig.messageInterval
Redis node abnormal message notification frequency, unit h
RedisConfig.database
Redis specified database
Default value is 0
RedisConfig.expireStateRemoveInterval
State server expired key deletion interval, in ms
The default value is 300000
RedisConfig.maxConnection
Redis connection pool maximum total number of instances
RemoteDesignConfig.avoidTempAuthValid
Remote design supports digital signature preview
false: Remote Design does not support digital signature preview
true: Remote Design supports digital signature preview
ScheduleSettingConfig.taskTimeout
Scheduled tasks exceed the time, the default is 5 minutes
ScheduleSettingConfig.timeoutRemind
Whether to enable the monitoring log timeout reminder for the scheduled task
false: Scheduled tasks do not enable monitoring log timeout reminders
true: The scheduled task enables the monitoring log timeout reminder
SecurityConfig.frontSeed
Used to provide keys for front-end encryption
The parameter value is 16-bit uppercase and lowercase letters
The initial is a random 16-bit uppercase and lowercase letter string, which can be modified by yourself
ServerConfig.cookiePath
cookie path
Note: Please configure it when deploying the project. Otherwise, the browser will store multiple cookies, and each user needs to manually clear the cookies to log in successfully.
parameter value must be a non- empty string
The initial value is /
ServerConfig.tokenFromCookie
When enabled, the token can be taken from the cookie when verifying the token in the background, which solves the problem of background single point and cross-domain single sign-on failure under httponly .
false: The token cannot be retrieved from the cookie when verifying the token in the background
true: the token can be retrieved from the cookie when verifying the token in the background
ServerPreferenceConfig.useOptimizedUPM
Configure whether to enable new plugin management
false: Do not enable new plugin management
true: Enable new plugin management
SystemConfig.hideVersion
Whether to hide version information in system info
false: Do not hide version information in system info
true: hide version information in system info
SystemConfig.serverInit
Whether the platform is initialized
The parameter values are as follows, the default is success
success: platform initialization completed
fail: Platform initialization not completed
SystemOptimizationConfig.ClientMasterId _
Web cluster nodes with data
The parameter value needs to be a string
is the web cluster, the specified data request, update, the ID of the machine with the data
SystemOptimizationConfig.biClusterMasterNodeHostName
hostname of the master node of the BI cluster
The initial value is __EMPTY__
SystemOptimizationConfig.cacheHeap
Number of caches: excluding other caches associated with dimension table caches and paging caches
not configured by default , 100 large data sets are cached, and 10,000 small data sets are cached
Set to 0, which means there is no limit to the number of caches, and needs to be restarted after modification to take effect
SystemOptimizationConfig.cacheIdleSeconds
cache expiration time
SystemOptimizationConfig.cacheLargeMemPercent
Large buffer pool memory ratio
SystemOptimizationConfig.cacheMiddleMemPercent
The proportion of memory in the buffer pool
Default is 0.05
SystemOptimizationConfig.cacheSmallMemPercent
Small buffer pool memory ratio
Default is 0.01
SystemOptimizationConfig.cacheStrategy
caching strategy
Default is mem
SystemOptimizationConfig.chartBigDataNum
Limit the number of big data charts
SystemOptimizationConfig.chartDataThreadPoolNum
chart thread pools
1) Versions before 5.1.11:
Default is 8
2) 5.1.11 and later versions:
0 means to close the thread pool. After closing, the thread at the beginning of chart-group-data-pool will not appear in the thread stack of BI
This parameter is meaningless when connecting directly
SystemOptimizationConfig.confLockTimeOutTime
Configure lock timeout settings, in seconds
The default value is 30
SystemOptimizationConfig.dashboardEditLimit
Row limit for dashboard editing ( do not select all data)
SystemOptimizationConfig.detailUseColumnarCompress
Whether column compression is enabled for the schedule
false: column compression is not enabled for schedules
true: column compression is enabled for the schedule
SystemOptimizationConfig.directMemoryEngineLimitRows
Direct connection to the new memory engine cache data line limit
Default is 100000
SystemOptimizationConfig.directUseAllData
not available by default
false: All data for direct connection is available
true: All data of direct connection is unavailable
SystemOptimizationConfig.excelExtractDataBase
There are restrictions on the associated optional table directly connected to Excel data extraction. If the system parameter is Excel data extraction, the Excel table can be configured with association .
false: Directly connected Excel tables cannot be associated
true: Directly connected Excel tables can be associated
SystemOptimizationConfig.excelExtractMaxLimitRows
The limit of the number of rows when directly connecting to excel to generate a temporary table
SystemOptimizationConfig.fieldInfoTimeoutSeconds
Timeout for fetching field information from the data source
SystemOptimizationConfig.firstDayofWeek
The first day of the week is the day of the week
SystemOptimizationConfig.groupUseColumnarCompress
Whether column compression is enabled for grouped tables
false: column compression is not enabled for grouped tables
true: Enable column compression for grouped tables
SystemOptimizationConfig.inheritPermissio nAndRelation
Set permissions to inherit the default switch state
false: permission inheritance is disabled by default
true: permission inheritance is enabled by default
SystemOptimizationConfig.memManagerPercent
Size ratio of global memory management
SystemOptimizationConfig.memoryWarningSize
SQL data set data volume alarm value
Default is 100000000
SystemOptimizationConfig.needTreatRedMark
Whether to fix the red self-help dataset
false: Do not fix the red-marked self-help dataset
true: fix self-service datasets marked in red
SystemOptimizationConfig.optimizeSqlAlias
Whether to optimize SQL aliases (opening will reset all aliases in SQL)
false: do not optimize SQL aliases
true: optimize SQL aliases
SystemOptimizationConfig.queryConditionCountRestriction
Limit on the number of detailed filter conditions
SystemOptimizationConfig.readRelationFromDbSource
adding a db table, do you want to read the association in the database
false: do not read the association in the database when adding the db table
true: read the association in the database when adding the db table
SystemOptimizationConfig.reportShareType
Whether template sharing uses creator permissions
The parameter value is an integer
SystemOptimizationConfig.schedulerMergeTimeSeconds
How many seconds to perform a timed task merging
Default is 5
SystemOptimizationConfig.tableLoadThreadPoolNum
update thread count
SystemOptimizationConfig.threadPoolStrat egy
Update thread pool policy
The parameter values are as follows, the default is dynamic
dynamic: based on memory, 1G=1 thread static: fixed number of threads, used together with TableloadThreadPoolNum
SystemOptimizationConfig.treeCacheHeap
The number of caches in the tree structure
SystemOptimizationConfig.treeCacheSeconds
Cache duration of tree structure
SystemOptimizationConfig.useColumnarCompress
SystemOptimizationConfig.usePagingCache
Whether to enable paging cache
false: do not enable paging cache
true: enable paging cache
TemplateAuthConfig.digitalAuthAvailable
Template authentication - whether the digital signature function can be used
This parameter is supported by BI projects of version 5.1.11 and later
The parameter values are as follows, the default is true
false: The administrator cannot use the template authentication-digital signature function
true: the administrator can use the template authentication-digital signature function
WebSecurityConfig.cacheControlExpiresHeader
Browser cache disables the value of header expires
The parameter values are as follows, the default value is 0
0: Represents a date in the past, that is, the resource has expired
<http-date>: The response expires after the specified date
WebSecurityConfig.cacheControlHeader
Browser cache disables the value of header cache-control
The parameter values are as follows, the default value is no-cache
no-cache: Force the cache to submit the request to the origin server for validation before publishing the cached copy (negotiate cache validation)
max-age=<seconds>: Set the maximum period of cache storage, beyond which the cache is considered expired (in seconds)
WebSecurityConfig.cacheControlPragmaHeader
Browser caching disables the value of the header pragma
The parameter value is no-cache
WebSecurityConfig.contentSecurityPolicyHeader
csp content security policy header content-security-policy
The parameter values are as follows, the default value is object- src 'self'
1) object- src 'self':
Restrict the source address of <object>, <embed>, <applet> tags
and only allow matching against the current origin (not its subdomains)
2) object- src uri
Restrict the source address of <object>, <embed>, <applet> tags and the address in the above tags only specifies the URL to allow loading
3) default- src https:
Disable insecure inline/dynamic execution, only allow these resources (images, fonts, scripts, etc.) to be loaded via https
WebSecurityConfig.contentTypeOptionsHeader
Content sniffing attack protection header x-content-type-options value
parameter value is nosniff
WebSecurityConfig.fileInspectorType
After the file verification of security management is enabled, use this configuration file to upload the verification type
The parameter values are as follows, the default is 1
0: Comprehensive, the suffix is not released in the whitelist, otherwise the header is checked
1: Whitelist, only those with the suffix in the whitelist and the header match will be released
2: Blacklist, the suffix is not allowed in the blacklist
WebSecurityConfig.frameOptionsHeader
Clickjack attack protection header x-frame-options value
The parameter values are as follows, the default value is SAMEORIGIN
DENY: The browser will refuse the current page to load any frame page SAMEORIGIN: The address of the frame page can only be the page under the same origin domain name ALLOW-FROM origin: The page address that allows frame loading
WebSecurityConfig.hstsHeader
hsts header strict-transport-security
The parameter values are as follows, the default value is max-age=31536000; includeSubDomains
1) max-age=<expire-time>:
It is set that all requests to access this domain name will use HTTPS requests within XXX seconds after the browser receives this request.
2) max-age=<expire-time>; includeSubDomains :
It is set that within XXX seconds after the browser receives this request, all requests to access this domain name will use HTTPS requests. This rule also applies to all subdomains of the site
3) max-age=<expire-time>; preload:
It is set that within XXX seconds after the browser receives this request, all requests to access this domain name will use HTTPS requests. Preload HSTS
WebSecurityConfig.loginValidateStrict
It is used to restrict the use of cross-domain login interface and cas background login interface. If true is configured, these two interfaces cannot be used.
false: does not restrict the use of cross-domain login interface and cas background login interface
true: Restrict the use of cross-domain login interface and cas background login interface
WebSecurityConfig.xssProtectionHeader
xss attack protection header x- xss -protection
The parameter values are as follows, the default value is 1; mode=block
0: Disable XSS filtering
cross-site scripting attack is detected , the browser will clear the page and remove the unsafe parts
1; mode=block: Enables XSS filtering, if an attack is detected, the browser will not clear the page, but block the page from loading
1; report=<reporting- uri >:
cross-site scripting attack is detected , the browser will clear the page and send a violation report using the CSP reporting- uri functionality
WebSocketConfig.port
websocket server listening port
The parameter value is an array of ports ["port1","port2"]
The ports belong to the interval (1024,65535]
The default value is ["38888","39888"]
WebSocketConfig.trustStore
The file storage path of the trust certificate
The parameter value is a non-empty string, try to use an absolute path
WebSocketConfig.trustStoreFormat
Type of trust certificate
The parameter value is JKS or PKCS12
If it is a pfx certificate, change it to PKCS12
Default is JKS
WebSocketConfig.trustStorePassword
The application key when the trust certificate is used
Added support for V1.2 and above plugins:
ClusterRedirectConfig.enableSessionIDGenerationStrategy
Whether to enable the sessionID generation policy under the cluster
false: Do not enable the sessionID generation strategy under the cluster
true: The tail of the sessionID under the cluster will be spliced with the nodeID of the cluster
FineClusterConfig.params.encrypt
Cluster communication encryption switch, the default is false
false: Cluster communication is not encrypted
true: cluster communication encryption
FineClusterConfig.params.ipStackType
cluster communication
The parameter value defaults to ipv4, and ipv6 can be configured
Html5Config.isJoinProductPlan
HTML5 allows to close the developer program, and users can manually close whether to join the product improvement program to further protect the privacy of users
false: turn off the developer program
true: enable the developer program
LanguageConfig.locale
Platform-Global Language Settings
default value is zh_CN
zh_CN : Simplified Chinese
zh_TW : Traditional Chinese
en_US : English
ja_JP : Japanese
ko_KR : Korean
MarketConfig.cloudOperationMaintenanceId
Reset the cloud operation and maintenance application ID
The parameter value defaults to your cloud operation and maintenance application ID
MobileConfig.emptyDirVisible
Controls whether to display empty directories on mobile (APP, HTML5)
true: show empty directories
false: do not display empty directories
ParseCheckConfig.allowDrawing
When html parsing reports an error (unsupported tags and attributes are encountered in each export scenario), whether to allow html to be drawn as a graph
false: When the html parsing error is reported, it is not allowed to draw html as a picture
true: When html parsing reports an error, allow html to be drawn as a graph
ServerPreferenceConfig.errorTemplate
FR template error page, you can refer to FanRuan official help documentation, custom template error page
The parameter value is the custom error page link
Defaults to __EMPTY__
SystemOptimizationConfig.clearEntityStrategy
Get custom fineb table cleanup strategy
The parameter default value is __EMPTY__
parameter format is: {policy serial number}:{cleaning months of data },{cleaning time (hours)},{cleaning time (minutes)},{cleaning period (seconds)};
For example: strategy 1, clean data before March, execute every 2 days, execute strategy 2 at 4:20, clean data before January, execute every 30 days, execute at 2:50. Then the parameter is: 1:3,4,20,172800;2:1,2,50,2592000
WebSocketConfig.hostName
Websocket listening IP settings
The parameter value is the built-in network card of the server or the external IP.
Default is 0.0.0.0
WebSocketConfig.webSocketTokenInHeader
Socket communication token delivery method
true: the token is transmitted from the request header
false: the token is transmitted from the url
WorkflowAuthorityConfig.compatible
Independent link for multi-level reporting, when you log in for the first time, a pop-up window will pop up on the page to prompt : There is a permission configuration for the reporting page in the directory permissions, whether to synchronize the permission configuration from the directory permissions
This parameter is used to control whether a prompt will pop up afterward
true: do not pop up
false: popup
DistributedOptimizationConfig.spiderConfig.local _file_delete_retry_mode
Local file deletion retry mechanism
true: local file deletion retry mechanism
false: local files do not delete retry mechanism
DistributedOptimizationConfig.spiderConfig.local _file_delete_retry_period
Local file deletion retry period
parameter value must be a positive integer, the default is 10
DistributedOptimizationConfig.spiderConfig.local _file_delete_retry_time
Local file deletion retries
parameter value must be a positive integer, the default is 3
DistributedOptimizationConfig.spiderConfig.max_slice_memory_size
slice max memory setting
parameter value must be a positive integer, the default is 52428800
DistributedOptimizationConfig.spiderConfig.spark_blockManager_port _
spark blockManager port
parameter value must be a positive integer in the interval [1001, 65535]
The default value is 17778
DistributedOptimizationConfig.spiderConfig.spark_driver_host _
spark driver hostname
parameter value needs to be a string, the default is empty
DistributedOptimizationConfig.spiderConfig.spark _driver_maxResultSize
Spark returns the maximum result set size on the driver side
The parameter value needs to be a string, the default is 1g
DistributedOptimizationConfig.spiderConfig.spark_driver_port _
spark driver port
The default value is 17777
DistributedOptimizationConfig.spiderConfig.spark_executor_cores _
spark executor core
parameter value must be a positive integer, the default is 12
DistributedOptimizationConfig.spiderConfig.spark _executor_memory
spark executor memory
The parameter value needs to be a string, the default is 6g
DistributedOptimizationConfig.spiderConfig.spark_local_dir _
spark temporary file directory, calculate spit disk directory
DistributedOptimizationConfig.spiderConfig.spark_master_host _
spark master hostname
DistributedOptimizationConfig.spiderConfig.spark_master_port _
spark master port
The default value is 7077
DistributedOptimizationConfig.spiderConfig.spark_scheduler_allocation_file _
spark scheduling allocation file
DistributedOptimizationConfig.spiderConfig.spark _scheduler_mode
spark scheduling mode
The parameter value needs to be a string, the default is CAPACITY
DistributedOptimizationConfig.spiderConfig.spark _shuffle_service_enabled
shuffle process data outflow
true: shuffle process data outflow
false: The data in the shuffle process will not be sorted out
DistributedOptimizationConfig.spiderConfig.spark _sql_adaptive_enabled
Computational adaptive function
true: Compute adaptive features
false: do not calculate adaptive features
DistributedOptimizationConfig.spiderConfig.spark _sql_adaptive_shuffle_targetPostShuffleInputSize
Calculate adaptive target block size
The parameter value needs to be a string, the default is 200M
DistributedOptimizationConfig.spiderConfig.spark _sql_broadcastTimeout
broadcast timeout
The parameter value needs to be a string, the default is 12000
DistributedOptimizationConfig.spiderConfig.spark_sql_shuffle_partitions _
Number of concurrent blocks for spark shuffle
DistributedOptimizationConfig.spiderConfig.spark _sql_sortMergeJoinExec_buffer_in_memory_threshold
sortMergeJoin operator
The parameter value needs to be a string, the default is 100000
DistributedOptimizationConfig.spiderConfig.spark _sql_sortMergeJoinExec_buffer_spill_threshold
sortMergeJoin operator throughput threshold
DistributedOptimizationConfig.spiderConfig.spider_array_group_map_function_threshold _
Array Grouping Algorithm Threshold
parameter value must be a positive integer, the default is 5000000
DistributedOptimizationConfig.spiderConfig.spider_base_update_thread_proportion _
Basic table thread ratio
parameter value must be a positive integer, the default is 30
DistributedOptimizationConfig.spiderConfig.spider_build_field_index_cores _
Build field index cores
parameter value must be a positive integer, the default is 8
DistributedOptimizationConfig.spiderConfig.spider_build_index_cores _
Build index cores
parameter value must be a positive integer, the default is 4
DistributedOptimizationConfig.spiderConfig.spider_column_max_load_dictionary_key_size _
The maximum number of loaded dictionaries for data columns
parameter value must be a positive integer, the default is 10000
DistributedOptimizationConfig.spiderConfig.spider_compress_slice_size _
When drawing, the number of rows per shard
parameter value must be a positive integer, the default is 100000
DistributedOptimizationConfig.spiderConfig.spider_core_limit_fraction _
spark limit core task score
Default is 0.67
DistributedOptimizationConfig.spiderConfig.spider_create_satellite_async _
Create satellite table asynchronously
true: create satellite table asynchronously
do not create satellite tables asynchronously
DistributedOptimizationConfig.spiderConfig.spider_deletion_criteria_size_per_execution _
Incremental delete each maximum calculation size
parameter value needs to be a string, the default is 128m
DistributedOptimizationConfig.spiderConfig.spider_detail_formula_use_page _
Detail formulas use pagination
true: Detail formulas use pagination
false: detail formulas do not use pagination
DistributedOptimizationConfig.spiderConfig.spider_distinct_median_threshold _
Deduplication count/median memory threshold
Versions prior to 5.1.12, the default value is 100
5.1.12 and later, the default value is 25
DistributedOptimizationConfig.spiderConfig.spider_double_dictionary_max_key_size _
Maximum number of dictionaries of type double
DistributedOptimizationConfig.spiderConfig.spider_engine_use_page _
Use paging engine
true: use paging engine
false: do not use paging engine
DistributedOptimizationConfig.spiderConfig.spider_etl_coalesce_size _
etl maximum number of blocks
DistributedOptimizationConfig.spiderConfig.spider_etl_compute_limit_unit _
etl calculate cell limit
parameter value must be a positive integer, the default is 50000000
DistributedOptimizationConfig.spiderConfig.spider_etl_core_limit _
etl limit core
true: etl limit core
false: etl does not limit cores
DistributedOptimizationConfig.spiderConfig.spider_etl_iterator_repartition_size _
etl repartition size
parameter value must be a positive integer, the default is 20
DistributedOptimizationConfig.spiderConfig.spider_etl_no_order _
etl disorder
true: etl unordered
false: etl ordered
DistributedOptimizationConfig.spiderConfig.spider_etl_output_use_bitmap _
ETL generated index
true
true: ETL generates indexes
false: ETL does not generate indexes
DistributedOptimizationConfig.spiderConfig.spider_etl_preview_row_count _
etl preview row count
The parameter value needs to be a string, the default is 5000
DistributedOptimizationConfig.spiderConfig.spider_etl_writer_lock_wait _
etl write lock wait time
parameter value must be an integer greater than or equal to -1
Default is 60000
DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_memory _
Quickly calculate memory limit byte size
Default is 500000000
DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_row _
Quick calculation of row limit
parameter value must be a positive integer, the default is 10000000
DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_unit _
Quickly calculate cell limits
DistributedOptimizationConfig.spiderConfig.spider_fast_etl_cache _
Fast computation using cache
true: use cache for fast computation
false: do not use cache for fast computation
DistributedOptimizationConfig.spiderConfig.spider_file_max_mmap_size _
File maximum mmap size
parameter value must be a positive integer, the default is 2147483647
DistributedOptimizationConfig.spiderConfig.spider_file_mmap_size _
file mmap size
parameter value must be a positive integer, the default is 1073741823
DistributedOptimizationConfig.spiderConfig.spider_first_day_of_week _
first day of the week
parameter value must be an integer in the range [0, 6]
DistributedOptimizationConfig.spiderConfig.spider_float_dictionary_max_key_size _
The maximum number of dictionaries of type float
DistributedOptimizationConfig.spiderConfig.spider_generate_join_cache_in_query _
Generate associative cache at query time
true: generate associative cache at query time
false: do not generate associative cache at query time
DistributedOptimizationConfig.spiderConfig.spider_high_performance_pool_size _
Correlation and analysis table resource pool size when computing performance is not guaranteed
parameter value must be a positive integer, the default is 1000
DistributedOptimizationConfig.spiderConfig.spider_high_performance_resource_time _
High performance resource usage time
DistributedOptimizationConfig.spiderConfig.spider_ignore_base_update _
Whether to skip underlying table updates
true: Skip underlying table updates
false: Do not skip underlying table updates
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_dataset _
Index generation using dataset
true: index generation uses dataset
false: index is not generated using dataset
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_external _
Index generation uses outer row
true: index generation uses outer row
false: Indexes are not generated using outer row
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_external_buffer_path _
index cache file path
Default is distributed/external
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_external_buffer_size _
index buffer size
DistributedOptimizationConfig.spiderConfig.spider_int_dictionary_max_key_size _
Maximum number of dictionaries of type int
DistributedOptimizationConfig.spiderConfig.spider_int_distinct_structure _
This parameter is added in 5.1.12 and later versions
A data structure that controls the number of deduplicated records
The parameter value is the specified value, the default value is 0
0: Indicates that the data structure is KolobokeIntSet , which is fast but occupies large memory (an average int key occupies 8 bytes)
1: Indicates that the data structure is RoaringBitmap , which is slow but has a small memory footprint (an average int key occupies 1 byte)
DistributedOptimizationConfig.spiderConfig.spider_join_always_use_sql _
Associations are always computed using SQL
true: associations are always computed using SQL
false: the association is never computed using SQL
DistributedOptimizationConfig.spiderConfig.spider_join_build_index _
Associative generated index
true: the association generates an index
false: the association does not generate an index
DistributedOptimizationConfig.spiderConfig.spider_join_cache_delete_direct _
The associated cache is immediately deleted
true: the associated cache is immediately deleted
false: The associated cache is not deleted immediately
DistributedOptimizationConfig.spiderConfig.spider_join_dot_constant _
Link Point Constants
The parameter value needs to be a string, the default is .
DistributedOptimizationConfig.spiderConfig.spider_join_equal_constant _
Associated Equals Constant
The parameter value needs to be a string, the default is =
DistributedOptimizationConfig.spiderConfig.spider_join_huge_table_size _
Associative large table size
The parameter value must be a non- negative integer, the default is 0
DistributedOptimizationConfig.spiderConfig.spider_join_left_bracket_constant _
associative left parenthesis constant
The parameter value needs to be a string, the default is (
DistributedOptimizationConfig.spiderConfig.spider_join_left_square_bracket_constant _
Associative Left Bracket Constant
The parameter value needs to be a string, the default is [
DistributedOptimizationConfig.spiderConfig.spider_join_name_simple _
Associations use simple naming
true: association uses simple naming
false: the association does not use simple naming
DistributedOptimizationConfig.spiderConfig.spider_join_right_bracket_constant _
Associative closing parenthesis constant
The parameter value needs to be a string, the default is)
DistributedOptimizationConfig.spiderConfig.spider_join_right_square_bracket_constant _
Associative closing bracket constant
The parameter value needs to be a string, the default is ]
DistributedOptimizationConfig.spiderConfig.spider_join_use_relation _ _
Use associative cache
true: use associative cache
false: do not use associative cache
DistributedOptimizationConfig.spiderConfig.spider_load_data_buffer_queue_size _
size of the buffer queue for the draw
parameter value must be a positive integer, the default is 100
DistributedOptimizationConfig.spiderConfig.spider_load_data_buffer_row_size _
decimated buffer line size
DistributedOptimizationConfig.spiderConfig.spider_load_use_bitmap _
Draw number to generate index
true: draw the number to generate the index
false: No index is generated for draw
DistributedOptimizationConfig.spiderConfig.spider_local_compute_cores _
Number of local computing cores
parameter value must be a positive integer, the default is empty
DistributedOptimizationConfig.spiderConfig.spider_local_default_db _
Data default DB
The parameter value needs to be a string, the default is db
DistributedOptimizationConfig.spiderConfig.spider_local_root_path _
Data extraction storage path
The parameter value needs to be a string, the default is ../spider
DistributedOptimizationConfig.spiderConfig.spider_lock_wait_time _
Default wait time for locks
DistributedOptimizationConfig.spiderConfig.spider_long_dictionary_max_key_size _
Maximum number of dictionaries of type long
DistributedOptimizationConfig.spiderConfig.spider_low_performance_small_pool_size _
When ensuring computing performance, the associated resource pool size is generated
DistributedOptimizationConfig.spiderConfig.spider_max_rowstream_memory_size _
etl rowstream memory limit
DistributedOptimizationConfig.spiderConfig.spider_mem_filer_datamodel_ratio _
Memory evaluation ratio after filtering
parameter value needs to be a non- negative double-precision floating-point type, the default is 0.3
DistributedOptimizationConfig.spiderConfig.spider_memory_check_frequency_group _
Grouping Algorithm Memory Statistics Frequency
DistributedOptimizationConfig.spiderConfig.spider_merge_forbidden_time _
Merger Prohibition Time
DistributedOptimizationConfig.spiderConfig.spider_number_set_dictionary_max_key_size _
Whether to set the maximum number of dictionaries for numeric type dictionary encoding
true: set the maximum number of dictionaries
false: do not set the maximum number of dictionaries
DistributedOptimizationConfig.spiderConfig.spider_page_summary_concurrent_threads _
Paging indicator calculation multi-thread
parameter value needs to be boolean, default is empty
true: paging indicator calculation is multi-threaded
false: paging metrics do not count for multithreading
DistributedOptimizationConfig.spiderConfig.spider_partition_limitation _
Partition row limit
DistributedOptimizationConfig.spiderConfig.spider_partition_merge_policy _
partition merge strategy
DistributedOptimizationConfig.spiderConfig.spider_partition_row_size _
Number of partition rows
DistributedOptimizationConfig.spiderConfig.spider_partition_slice_size _
partition is drawn, the number of rows in each shard
parameter value must be a positive integer, the default is 5000
DistributedOptimizationConfig.spiderConfig.spider_query_condition_count_restriction _
Engine query condition number limit
Defaults to -1
DistributedOptimizationConfig.spiderConfig.spider_reduce_row_key_ratio _
reduce uses the ratio of dictionaries
parameter value must be a non- negative double-precision floating-point type, the default is 1.0
DistributedOptimizationConfig.spiderConfig.spider_relation_column_strategy _
Generation Strategy for Associated Columns
parameter value needs to be a string, the default is SectionShrink
DistributedOptimizationConfig.spiderConfig.spider_relation_matcher_policy _
Association matching rules
parameter value must be a string, the default is HeadTail
DistributedOptimizationConfig.spiderConfig.spider_restrictions_column_long_text _
Maximum text limit
DistributedOptimizationConfig.spiderConfig.spider_retry_max_times _
Maximum number of retries
parameter value must be a positive integer, the default is 2
DistributedOptimizationConfig.spiderConfig.spider_row_index_strategy _
Analysis table row index optimization
true: Analysis table row index optimization
false: Analysis table row index is not optimized
DistributedOptimizationConfig.spiderConfig.spider_satellite_creation_step _
Satellite table creation step size
DistributedOptimizationConfig.spiderConfig.spider_section_merge_large_section_count _
section number of merged chunks
parameter value must be a positive integer, the default is 6
DistributedOptimizationConfig.spiderConfig.spider_section_merge_policy _
section merge strategy
parameter value needs to be a string, the default is grouping
DistributedOptimizationConfig.spiderConfig.spider_section_merge_row_threshold_factor _
section merge row count threshold
parameter value must be a positive integer, the default is 1000000
DistributedOptimizationConfig.spiderConfig.spider_section_merge_small_section_count _
The number of sections merged into small blocks
DistributedOptimizationConfig.spiderConfig.spider_spark_driver_use_random_port _
spark driver uses random port
true: spark driver uses random port
false: spark driver does not use random ports
DistributedOptimizationConfig.spiderConfig.spider_spark_local_threads _
Spark native thread count
DistributedOptimizationConfig.spiderConfig.spider_sparksql_filter_pushdown _
sparkSQL filter pushdown
true: sparkSQL filter pushdown
false: sparkSQL filter does not push down
DistributedOptimizationConfig.spiderConfig.spider_sql_merge_table _
Merge tables using sql
true: merge tables using sql
false: Do not use sql to merge tables
DistributedOptimizationConfig.spiderConfig.spider_stream_partition_estimated_byte _
Streaming partition estimated size
parameter value must be a positive integer, the default is 2000000000
DistributedOptimizationConfig.spiderConfig.spider_submit_spark_thread_count _
Submit the number of spark threads
parameter value must be a positive integer, the default is 5
DistributedOptimizationConfig.spiderConfig.spider_table_estimate_strategy _
Ways to estimate table size
The parameter value needs to be a string, the default is SAMPLE
DistributedOptimizationConfig.spiderConfig.spider_temp_folder_path_for_spark _
spark temporary file path
Defaults to /root/temp/spark
DistributedOptimizationConfig.spiderConfig.spider_update_fast_compute_limit_cell _
Analyze the disk usage of user self-service datasets
parameter value must be a positive integer, the default is 100000000
DistributedOptimizationConfig.spiderConfig.spider_updated_background _
Whether the incremental update merge is performed in the background
true: Incremental update merge background execution
false: Incremental update merges are not performed in the background
DistributedOptimizationConfig.spiderConfig.spider_updated_partition_num _
Number of updated partitions that triggered the merge
DistributedOptimizationConfig.spiderConfig.spider_use_fast_etl_local_optimize _
Fast computation using local optimization
true: use local optimization for fast computation
false: fast computation does not use local optimization
DistributedOptimizationConfig.spiderConfig.spider_use_pin_yin_sort _
Sort using Chinese Pinyin
true: Use Chinese Pinyin to sort
false: do not use Chinese pinyin sorting
Added support for V1.6 and above plugins:
FSConfig.loginConfig.fWords
Custom configuration LDAP authentication username login search field
The parameter value format is: ["value1", "value2"]
The parameter value is not allowed to be empty, and the parameter length is not allowed to be 0
The default value of the parameter is ["sAMAccountName","cn","userPrincipalName","uid","displayName","name","sn"]
Added support for V1.7 and above plugins:
UpdateConfig.launchSwitchMap.plugins
Whether the startup update of plugin automatic update is enabled
If you want to disable the automatic update of the plugin after the project is started, please change the parameter value to false, otherwise no need to change
CronUpdateConfig.typeMap.plugins
Whether the regular update of the plugin's automatic update is enabled
If you need to close the external network update plug-in at 11:00 every night after the project starts, please change the parameter value to false, otherwise no need to change
DelayUpdateConfig.delaySwitchMap.plugins
Whether the delayed update of plugin automatic update is enabled
If you want to disable the automatic update of the plugin that is delayed for a period of time after the project is started, please modify the parameter value to false, otherwise there is no need to change
Added support for V1.9 and above plugins:
Set the time period during which updates can consume high-performance resources
If you want to set 7:00pm - 8:00am, please modify the parameter value to 19:00:00-8:00:00
PluginFileValidateConfig.fileValidateOpen
Whether the plugin package integrity check is enabled
false: Plug-in package integrity check is disabled
true: plugin package integrity check is enabled
After modifying the configuration according to the parameter rules, click "Save", and a prompt box will pop up: The parameters you modified will take effect after the restart. Please restart the server.
The configuration takes effect after restarting the BI server.
Note: If it is not configured according to the parameter rules in Section 2.3, the parameter value verification fails, and a prompt box will pop up: the configuration item value verification fails, and the saving fails.
Note: If you do not configure according to the parameter rules in section 2.3, the parameter value verification fails, and a prompt box will pop up: Configuration item value verification fails.
售前咨询电话
400-811-8890转1
在线技术支持
在线QQ：800049425
热线电话：400-811-8890转2
总裁办24H投诉
热线电话：173-1278-1526
文 档反 馈
鼠标选中内容，快速反馈问题
鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。
不再提示
10s后关闭