Properties - queryengine.properties file
Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace  Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
Some of the important properties of the queryengine.properties file, needed for cluster deployment are listed here.
Property Name | Description | Syntax/Example | Default Value |
---|---|---|---|
QUERY_ENGINE_LISTENER_PORT | The port at which the Query Engine will listen. | [int] | 45440 |
ZOOKEEPER_HOSTS | Comma-separated ZooKeeper hosts and, optionally, their port numbers. | [host:port,host:port,host:port] | localhost: 2181 |
CLUSTER_NAME | The name of the ZooKeeper node is used for creating a namespace for different users. | [unique_user_name] | Default_Cluster |
LOG | The log file directory. The log filename is intera.log. | [path] (string) | ../logs |
LOG_LEVEL | The debug level for logging indicates the level of criticality to be logged. | [TRACE,DEBUG,INFO,WARN,ERROR,FATAL] (string) | ERROR |
CUBOID_REPLICATION_QUEUE_SIZE | The maximum number of cuboid replication requests that can be concurrently served. | [Queue size] (int) | 1000 |
CUBOID_REPLICATION_THREADS | The maximum number of cuboid replication threads that can be concurrently executed. | [No. of threads] (int) | 5 |
QUERY_ENGINE_HEALTH_PUBLISHER_INTERVAL | The time interval at which the Query Engine’s health is published to the ZooKeeper server. | [time in milliseconds] (int) | 60000 |
QE_LOCAL_CACHE_PATH | The location where semantic model data is locally copied. | [Directory Path] (string) | |
PARALLEL_READS_PER_QUERY | The number of concurrent cuboid reader threads. | [Max Number of Cuboids to be read concurrently] (int) | 5 |
MOLAP_CUBE_CACHE_SIZE | The maximum number of MOLAP semantic models that can be kept in memory. | [Max Number of MOLAP semantic models] (int) | 10 |
CUBOID_PURGE_FREQUENCY | The file system purge frequency that is, the interval after which the purge thread execution for cuboids is repeated (specified in minutes). | [>0] (int) | 30 |
CUBE_DATA_CACHE_LIMIT | The amount of memory specified in the percentage of maximum memory assigned to the BI Server process for caching semantic model data. | [An integer value between 0 to 80] (int) | 50 |
QE_STARTUP_QUERY_HOLD_TIME | This property specifies the time (in minutes) to hold the queries when Query Engines are started with Load Based Elasticity. If Query Engines become active before the configured time, the query will be served; otherwise, it will fail. | Any positive integer value (in minutes). QE_STARTUP_QUERY_HOLD_TIME=[60] (int) | The default value is 0. This indicates the query will not wait for the startup of the Query Engine cluster and will fail instantly. |
DS_QUERY_RETRIES_ON_ERROR | This property denotes the number of re-tries system will make in the event when a data store query gives out of memory error. We will add delays between the retries with 50 ms between first and second retry, 200 ms between second and third retry and 500 ms for all the retries onwards. This is relevant for data store based semantic models in case of errors like OOM at the time of querying. | Any positive integer value | 3 |
DS_MEMORY_CLEANUP_TRIGGER_PERCENTAGE | This property denotes the percentage of total assigned memory to be consumed by data store post which the system will trigger a mechanism to free some memory by itself. | Any positive integer value | 70 |
DS_CONNECTION_CONF | This property allows a user to configure parameters like memory and threads on data store connection that will be shared across semantic models and their cuboids at the time of reading. It is recommended to set it as 'SET memory_limit='10GB'; SET THREADS to 1;' | Â |
|
Copyright Kyvos, Inc. All rights reserved.