SHOW SYSTEM PROPERTIES - Kinetica Docs

System properties can be shown by any user.

SHOW SYSTEM PROPERTIES Syntax

SHOW SYSTEM PROPERTIES
[WITH OPTIONS ('properties' = '<config parameter name>[,...]')]

Examples

To show all system properties:

SHOW SYSTEM PROPERTIES Example

SHOW SYSTEM PROPERTIES

To show the internal & external cluster node URLs:

SHOW SYSTEM PROPERTIES Individually Example

SHOW SYSTEM PROPERTIES
WITH OPTIONS ('properties' = 'conf.worker_http_server_urls,conf.worker_http_server_urls_private')

To show all RAM tier properties:

SHOW RAM Tier Properties Example

SHOW SYSTEM PROPERTIES
WITH OPTIONS
(
    'properties' =
    '
        conf.tier.ram.default.high_watermark,
        conf.tier.ram.default.limit,
        conf.tier.ram.default.low_watermark,
        conf.tier.ram.rank0.high_watermark,
        conf.tier.ram.rank0.limit,
        conf.tier.ram.rank0.low_watermark,
        conf.tier.ram.rank1.high_watermark,
        conf.tier.ram.rank1.limit,
        conf.tier.ram.rank1.low_watermark,
        conf.tier.ram.rank2.high_watermark,
        conf.tier.ram.rank2.limit,
        conf.tier.ram.rank2.low_watermark
    '
)

​Examples

Examples