[ 
https://issues.apache.org/jira/browse/CASSANDRA-7622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14539854#comment-14539854
 ] 

Tupshin Harper commented on CASSANDRA-7622:
-------------------------------------------

An additional thought is that the capabilities framework (CASSANDRA-8303) could 
be used to to restrict the available commands that would make it through to the 
virtual table implementation.

A possibly controversial example of this would be to only support UPDATE 
operations and not INSERT operations to semantically denote the fact that this 
table doesn't support adding new hosts, metrics, or attributes, but does 
support updating them. This wouldn't restrict all unsupported behavior, and the 
table implementation would still have to return errors if a read-only (or 
non-existent) attribute were updated, but it seems a bit cleaner than having 
the table claim to support INSERTs.

A (maybe) less controversial use of 8303 would be to disallow all write 
operations (both UPDATE and INSERT as well as others) for tables that are truly 
read-only.

And in the JMX case, it would certainly make sense to have different users have 
either SELECT only permissions or SELECT and UPDATE.



> Implement virtual tables
> ------------------------
>
>                 Key: CASSANDRA-7622
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7622
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>            Reporter: Tupshin Harper
>            Assignee: Benjamin Lerer
>             Fix For: 3.x
>
>
> There are a variety of reasons to want virtual tables, which would be any 
> table that would be backed by an API, rather than data explicitly managed and 
> stored as sstables.
> One possible use case would be to expose JMX data through CQL as a 
> resurrection of CASSANDRA-3527.
> Another is a more general framework to implement the ability to expose yaml 
> configuration information. So it would be an alternate approach to 
> CASSANDRA-7370.
> A possible implementation would be in terms of CASSANDRA-7443, but I am not 
> presupposing.



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

Reply via email to