You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Constance Eustace (JIRA)" <ji...@apache.org> on 2014/04/21 17:14:14 UTC
[jira] [Created] (CASSANDRA-7062) Extension of static columns for
compound cluster keys
Constance Eustace created CASSANDRA-7062:
--------------------------------------------
Summary: Extension of static columns for compound cluster keys
Key: CASSANDRA-7062
URL: https://issues.apache.org/jira/browse/CASSANDRA-7062
Project: Cassandra
Issue Type: New Feature
Reporter: Constance Eustace
Priority: Minor
CASSANDRA-6561 implemented static columns for a given partition key.
What this is proposing for a compound cluster key is a static column that is static at intermediate parts of a compound cluster key. This example shows a table modelling a moderately complex EAV pattern :
CREATE TABLE t (
entityID text,
propertyName text,
valueIndex text,
entityName text static (entityID),
propertyType text static (propertyName),
propertyRelations List<text> static (propertyName),
PRIMARY KEY (entityID, (propertyName,valueIndex)
)
So in this example has the following static columns:
- the entityName column behaves exactly as CASSANDRA-6561 details, so all cluster rows have the same value
- the propertyName column is static with respect to the remaining parts of the cluster key (that is, across all valueIndex values for a given propertyName)
Is this a relatively simple extension of the same mechanism in -6561, or is this a "whoa, you have no idea what you are proposing"?
--
This message was sent by Atlassian JIRA
(v6.2#6252)