Query Engine Properties

This applies to: Visual Data Discovery

Most of the query engine components can be edited in the query-engine.properties file. You can manage the query engine using the following properties. For information on editing configuration files, see Edit a Symphony Configuration File.

Property Default Value Description
Service Logging
access.log.file.size 10 Access log file size (in MB)
qe.error.log.file.size 5 Error log file size (in MB)
log.file.size 20 General log file size (in MB)
websocket.log.file.size 10 Websocket log file size (in MB)
syslog.host 127.0.0.1 Sets the host IP address for Syslog server message logging.
syslog.log.level OFF Sets the syslog log level for messages logged to the Syslog server. The following options are available for this property: TRACE, DEBUG, INFO, WARN, ERROR. and OFF.
trace.requests false Enables detailed tracing of HTTP request
tracing.sampler.probability 1 The distributed tracing request rate percentage. Valid values are between 0 to 1.0, where 0 disables tracing and 1.0 indicates tracing 100% of requests.
General Microservice Configuration for Jetty Web Server
server.jetty.max-threads 200 Number of threads to serve the HTTP & WebSocket clients
qe.server.ws.idle.timeout 86400000 Idle time (in milliseconds) that allows the WebSocket to be still valid
qe.server.ws.input.buffer.size 16384 Buffer size (in bytes) for the WebSocket message
qe.server.ws.max.message.size 1048576 Max size (in bytes) of a message that could be sent over the query engine WebSocket
server.port 5580 REST/WebSocket microservice port
server.ssl.enabled false Defines whether the REST/WS API should use SSL
server.ssl.key-store Path to the file with the keystore
Graceful Shutdown  
application.graceful.shutdown.enabled true Indicates whether or not graceful shutdown processing should occur. Valid values are true (perform graceful shutdown processing) or false (do not perform graceful shutdown processing).
application.graceful.shutdown.event-propagation-timeout-sec 5 Specifies how long (in seconds) a query engine instance will wait to allow clients to receive the information that it is out of service.
application.graceful.shutdown.force-kill-timeout-sec 30 The maximum number of seconds that a query engine instance will wait for the number of its active tasks to reach zero. When this time has elapsed, all remaining active WebSockets serving in-flight queries are closed and then the query engine instance will stop.
Topology Configuration  
calculations.detect.array.fields true Enables and disables the query engine validation of multivalue fields in a derived field. By disabling (set the value to false) this functionality, any custom metrics that you may have created in earlier versions of Symphony that are aggregations of multivalue fields will produce valid values.
qe.max.allowed.time.groups 10000 The maximum amount of time in which groups can be generated by the Include Blanks function. For information on even time intervals, see Even Time Intervals.
qe.max.rows.during.execution 5000000

The maximum number of rows that can be processed during a single query. The value specified must be at least slightly greater than the value for the qe.zengine.edc.rows.limit property. If you increase the value of qe.zengine.edc.rows.limit, consider increasing the value of this property.

When a query exceeds the limit set by this property, a Resource limit is reached during query execution message appears.

qe.zengine.edc.rows.limit 1000000 The maximum number of records that can be fused from a single data source.
sharpening.enabled true Enables or disables Data Sharpening. Set this property to true to enable Data Sharpening; set it to false to disable it.
sharpening.samples.max.count 100 The maximum number of Data Sharpening requests that can be generated by the sharpening process.
sharpening.samples.skip.first 1 Defines how many first samples are skipped before visualizing the result of sharpening
zoomdata.validation.histogram.max.size 1000 Histogram max bucket count