System Properties

Kinetica provides a SQL interface for managing system properties, which control everything from GPUs, hostnames, storage, graph server, and more.

The ability to manage system properties is available through SQL, using the following commands:


ALTER SYSTEM SET PROPERTIES

Only a small subset of the system properties can be altered at runtime. See the /alter/system/properties endpoint documentation for the full list. Only users with the system_admin permission can issue this command.

ALTER SYSTEM SET PROPERTIES Syntax 
1

ALTER SYSTEM SET PROPERTIES ('<property key>' = '<property value>'[,...])

For example, to increase the request timeout and the maximum /get/records size:

ALTER SYSTEM SET PROPERTIES Example 
1
2
3
4

ALTER SYSTEM SET PROPERTIES (
    'request_timeout' = '25', 
    'max_get_records_size' = '25000'
)

SHOW SYSTEM PROPERTIES

All system properties can be shown by any user.

SHOW SYSTEM PROPERTIES Syntax 
1

SHOW SYSTEM PROPERTIES