[jira] [Commented] (CASSANDRA-9233) Allow system variables to be retrieved and set via CQL
[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14510192#comment-14510192
]
Aleksey Yeschenko commented on CASSANDRA-9233:
--
This is actually very neat - both the code and how it works.
I wonder though if this should be built on virtual tables instead, with all the
variables in one table, and strictly typed (see CASSANDRA-7622).
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)
[jira] [Commented] (CASSANDRA-9233) Allow system variables to be retrieved and set via CQL
[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14510196#comment-14510196
]
Aleksey Yeschenko commented on CASSANDRA-9233:
--
We've planned so far to expose metrics that way, but exposing cassandra.yaml
and Java system properties via the same way would be also nice.
The upside is that you don't need to extend the protocol with another statement
(can reuse SELECT and UPDATE), and you won't need extra permissions either.
Plus values would be properly typed, and not strings.
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)
[jira] [Commented] (CASSANDRA-9233) Allow system variables to be retrieved and set via CQL
[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (CASSANDRA-9233) Allow system variables to be retrieved and set via CQL
[
https://issues.apache.org/jira/browse/CASSANDRA-9233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14510403#comment-14510403
]
Michaël Figuière commented on CASSANDRA-9233:
-
Nice work Jeff! Nevertheless I like the idea of relying on virtual tables to
expose these variables for the reasons mentioned so far as well. I'd also add
that it's a pity to add a whole new kind of statement to the CQL grammar just
for this feature. Exposing it as a virtual table would be more lightweight and
consistent.
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
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)
