[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14510196#comment-14510196
]
Aleksey Yeschenko commented on CASSANDRA-9233:
----------------------------------------------
We've planned so far to expose metrics that way, but exposing cassandra.yaml
and Java system properties via the same way would be also nice.
The upside is that you don't need to extend the protocol with another statement
(can reuse SELECT and UPDATE), and you won't need extra permissions either.
Plus values would be properly typed, and not strings.
> Allow system variables to be retrieved and set via CQL
> ------------------------------------------------------
>
> Key: CASSANDRA-9233
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9233
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Jeff Jirsa
> Assignee: Jeff Jirsa
> Priority: Minor
> Attachments: 9233.txt
>
>
> Other database systems allow system variables to be retrieved and set via
> their query interface:
> https://dev.mysql.com/doc/refman/5.1/en/set-statement.html
> http://www.postgresql.org/docs/8.2/static/sql-set.html
> Proposing the following CQL syntax for retrieving variables:
> {{SHOW VARIABLES;}}
> {{SHOW VARIABLE 'variable';}}
> Proposing the following CQL syntax for setting variables:
> {{SET VARIABLE 'variable'='value' ;}}
> The output of {{SHOW VARIABLES;}} will be a superset of the actual values
> that can be set with {{SET VARIABLE}}, as not all values are safe to change
> after starting the node.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
