Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-9233

Allow system variables to be retrieved and set via CQL

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Low
    • Resolution: Won't Do
    • Fix Version/s: 4.x
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

        1. 9233.txt
          37 kB
          Jeff Jirsa

          Issue Links

            Activity

              People

              • Assignee:
                jjirsa Jeff Jirsa
                Reporter:
                jjirsa Jeff Jirsa
                Authors:
                Jeff Jirsa
              • Votes:
                3 Vote for this issue
                Watchers:
                17 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: