[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeff Jirsa updated CASSANDRA-9233:
----------------------------------
Description:
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.
was:
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:
{{LIST VARIABLES;}}
Proposing the following CQL syntax for setting variables:
{{SET VARIABLE 'variable'='value' ;}}
The output of {{LIST 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.
> 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
>
>
> 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)
