cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Jirsa (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-9233) Allow system variables to be retrieved and set via CQL
Date Thu, 23 Apr 2015 18:54:38 GMT
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)

Mime
View raw message