[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14510212#comment-14510212
]
Jeff Jirsa commented on CASSANDRA-9233:
---------------------------------------
I hadn't considered using virtual tables, but the typing benefit would be nice
(I wasn't thrilled with all of the casts to/from strings). SELECT+UPDATE on a
virtual table is definitely worth considering. The only downside that
immediately comes to mind is that 7622 is 3.1+, though doing it right is more
important than getting it in quickly. I'll look into that. Thanks for the
feedback.
> 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)
