The /alter/system/properties
endpoint is primarily used to simplify the testing of the system and is not
expected to be used during normal execution. Commands are given through the
input parameter property_updates_map whose keys are commands and values are
strings representing integer values (for example ‘8000’) or boolean values
(‘true’ or ‘false’).
Sets the maximum number of simultaneous threads allocated to a given request, on each rank. Note that thread allocation may also be limited by resource group limits and/or system load.
Sets the execution_mode for kernel executions to the specified string value. Possible values are host, device, default (engine decides) or an integer value that indicates max chunk size to exec on host.
Number of minutes after which filtering (e.g., /filter) and aggregating (e.g., /aggregate/groupby) queries will timeout.The default value is 20. The minimum allowed value is 0. The maximum allowed value is 1440.
The maximum number of records the database will serve for a given data retrieval call.The default value is 20000. The minimum allowed value is 0. The maximum allowed value is 1000000.
Size of the shadow aggregate chunk cache in bytes.The default value is 10000000. The minimum allowed value is 0. The maximum allowed value is 2147483647.
Maximum number of records to be ingested in a single batch.The default value is 1000. The minimum allowed value is 1. The maximum allowed value is 10000000.
Maximum time (milliseconds) for each poll to get records from Kafka.The default value is 0. The minimum allowed value is 0. The maximum allowed value is 1000.
Maximum time (seconds) to buffer records received from Kafka before ingestion.The default value is 30. The minimum allowed value is 1. The maximum allowed value is 120.
Max file size (in MB) to allow saving to a single file. May be overridden by target limitations.The default value is 10000. The minimum allowed value is 1. The maximum allowed value is 200000.
Size of the worker rank data calculation thread pool. This is primarily used for computation-based operations such as aggregates and record retrieval.The minimum allowed value is 2. The maximum allowed value is 8192.
Size of the worker rank data processing thread pool. This includes operations such as inserts, updates, and deletes on table data. Multi-head inserts are not affected by this limit.The minimum allowed value is 2. The maximum allowed value is 8192.
Size of the worker rank background thread pool. This includes background operations such as watermark evictions catalog table updates.The minimum allowed value is 1. The maximum allowed value is 8192.
The default compression algorithm applied to any column without a column-level or table-level default compression specified at the time it was created.
Time interval in seconds after which the database will apply optimizations/transformations to persisted data, such as compression.The minimum allowed value is 0.
If true the system configuration will be written to disk upon successful application of this request. This will commit the changes from this request and any additional in-memory modifications.The default value is true.The supported values are:
The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:
