[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14510403#comment-14510403
]
Michaël Figuière commented on CASSANDRA-9233:
---------------------------------------------
Nice work Jeff! Nevertheless I like the idea of relying on virtual tables to
expose these variables for the reasons mentioned so far as well. I'd also add
that it's a pity to add a whole new kind of statement to the CQL grammar just
for this feature. Exposing it as a virtual table would be more lightweight and
consistent.
> 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
> Fix For: 3.1
>
> 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)
