Properties - queryengine.properties file

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;'

1. blank