FrankChen021 commented on code in PR #18692: URL: https://github.com/apache/druid/pull/18692#discussion_r2497976040
########## docs/querying/sql-metadata-tables.md: ########## @@ -315,3 +316,21 @@ For example, to retrieve supervisor tasks information filtered by health status, ```sql SELECT * FROM sys.supervisors WHERE healthy=0; ``` + +### SERVER_PROPERTIES table + +The `server_properties` table exposes the runtime properties configured on for each Druid server. Each row represents a single property key-value pair associated with a specific server. + +|Column|Type|Notes| +|------|-----|-----| +|server|VARCHAR|Host and port of the server, in the form `host:port`| +|service_name|VARCHAR|Service name of the server, as defined by `druid.service`| +|node_roles|VARCHAR|Comma-separated list of roles that the server performs. For example, `[coordinator,overlord]` if the server functions as both a Coordinator and an Overlord.| +|property|VARCHAR|Name of the property| +|value|VARCHAR|Value of the property| + +For example, to retrieve properties for a specific server, use the query + +```sql +SELECT * FROM sys.server_properties WHERE server='123.456.789.1:8081' Review Comment: ```suggestion SELECT * FROM sys.server_properties WHERE server='192.168.1.1:8081' ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
