1.7.12 Parameter Changes
Configuration files
New files
- Add a new LDAP template for Developer Console/Visualdoop to simplify the LDAP configuration.
- This file replaces the VISUALDOOP_LDAP_XXX parameters used in the Visualdoop/config.sh
Files Change
- The configuration file
notifications.json
has been updated to display a notification on an external table without indexes and unused indexes - Starting files
start-node.sh
andstart-node.bat
have been updated to include a default GC configuration. - The log4j2 template file has been updated for Hadoop 3 for better log filtering.
Parameters
New Parameters
spill.result.max_size.mb
. Default value: 8192. maximum size, in MB, before a spilling query to be considered as too big and killed.optimization.add_index.nb_rows
. Default value: true. Enable optimization for ADD INDEX when creating from another full memory index. For instance when you create the INDEX(a) from INDEX(a, b).load.feedback.rate
. Default value: 10000. Defines the rate of notification by the engine to Monitor during a load.cognos.limit.select
. Default value : -1. Add an implicit limit on SELECT queries without GROUP BY for Cognos usage.
analyser.smart.metrics.days
. Default value: 15. The number of sliding days to pickup queries for analysis.analyser.smart.optimizer
. Default value: Last day tuning. Default optimizer to use. Can be overridden for each table. Defines in optimize_index.json.analyser.smart.scheduling.cron
. Default value : <empty>. When should we start the whole process of analysis and index creation.analyser.smart.scheduling.duration.minutes
. Default value: 120. Maximum duration of smart tables analysis.analyser.smart.threads
. Default value : 2. Number of threads used for running smart tables indexation.analyser.smart.max.indexes
. Default value: 20. Maximum number of indexes for a smart table.analyser.smart.threshold.slow.ms
. Default value: 2000. Speed threshold where a query is considered as slow.analyser.smart.weight
. Default value: 1. Default weight for score computationanalyser.smart.weight.bucket
. Default value: 1. Weight of the K-Store query for score computationanalyser.smart.weight.speed
. Default value: 1. Weight of the speed ratio for score computationanalyser.smart.weight.delegate
. Default value: 1. Weight of query delegated to the underlying table for score computationanalyser.smart.weight.size
. Default value: 1. Weight of the table size ratio for score computationanalyser.smart.weight.traffic
. Default value: 1. Weight of the traffic ratio for score computation