Skip to main content
Skip table of contents

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 and start-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 computation
  • analyser.smart.weight.bucket. Default value: 1. Weight of the K-Store query for score computation 
  • analyser.smart.weight.speed. Default value: 1. Weight of the speed ratio for score computation
  • analyser.smart.weight.delegate. Default value: 1. Weight of query delegated to the underlying table for score computation
  • analyser.smart.weight.size. Default value: 1. Weight of the table size ratio for score computation
  • analyser.smart.weight.traffic. Default value: 1. Weight of the traffic ratio for score computation
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.