Jeff Jirsa created CASSANDRA-9233:
-------------------------------------

             Summary: 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:

{{LIST VARIABLES;}}

Proposing the following CQL syntax for setting variables:

{{SET VARIABLE 'variable'='value' [, 'variable2' = 'value2'] ;}}

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. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to