You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "David Semeria (JIRA)" <ji...@apache.org> on 2011/03/17 14:22:29 UTC
[jira] Created: (CASSANDRA-2348) Allow periods in secondary index
column names
Allow periods in secondary index column names
---------------------------------------------
Key: CASSANDRA-2348
URL: https://issues.apache.org/jira/browse/CASSANDRA-2348
Project: Cassandra
Issue Type: Wish
Components: API
Reporter: David Semeria
Priority: Minor
Premise: it is natural to map JSON objects to column names using periods to denote the object hierarchy.
For example {food:{fruit;{a:apples,b:bananas,c:cherries}}}
Would map to the following CF names: food.fruit.a, food.fruit.b, food.fruit.c
However, secondary index names cannot contain periods which means workarounds (ie denormalization) must be used to index such columns.
It would be nice if this restriction could be removed.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2348) Allow periods in secondary
index column names
Posted by "Jonathan Ellis (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13127074#comment-13127074 ]
Jonathan Ellis commented on CASSANDRA-2348:
-------------------------------------------
why not just use food_fruit_a?
> Allow periods in secondary index column names
> ---------------------------------------------
>
> Key: CASSANDRA-2348
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2348
> Project: Cassandra
> Issue Type: Wish
> Components: API
> Reporter: David Semeria
> Priority: Minor
> Labels: index, json
>
> Premise: it is natural to map JSON objects to column names using periods to denote the object hierarchy.
> For example {food:{fruit;{a:apples,b:bananas,c:cherries}}}
> Would map to the following CF names: food.fruit.a, food.fruit.b, food.fruit.c
> However, secondary index names cannot contain periods which means workarounds (ie denormalization) must be used to index such columns.
> It would be nice if this restriction could be removed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-2348) Allow periods in secondary index
column names
Posted by "Jonathan Ellis (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-2348.
---------------------------------------
Resolution: Not A Problem
WFM.
> Allow periods in secondary index column names
> ---------------------------------------------
>
> Key: CASSANDRA-2348
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2348
> Project: Cassandra
> Issue Type: Wish
> Components: API
> Reporter: David Semeria
> Priority: Minor
> Labels: index, json
>
> Premise: it is natural to map JSON objects to column names using periods to denote the object hierarchy.
> For example {food:{fruit;{a:apples,b:bananas,c:cherries}}}
> Would map to the following CF names: food.fruit.a, food.fruit.b, food.fruit.c
> However, secondary index names cannot contain periods which means workarounds (ie denormalization) must be used to index such columns.
> It would be nice if this restriction could be removed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2348) Allow periods in secondary
index column names
Posted by "David Semeria (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13127295#comment-13127295 ]
David Semeria commented on CASSANDRA-2348:
------------------------------------------
Because underscore is a valid character in a JSON property name.
We must be sure the column name separator cannot appear in the property names themselves, otherwise when we read-in and parse the column names we would risk not splitting on correct boundaries.
Not to worry though, we switched to ":" which appears to be legal in v. 0.8+ secondary index references.
> Allow periods in secondary index column names
> ---------------------------------------------
>
> Key: CASSANDRA-2348
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2348
> Project: Cassandra
> Issue Type: Wish
> Components: API
> Reporter: David Semeria
> Priority: Minor
> Labels: index, json
>
> Premise: it is natural to map JSON objects to column names using periods to denote the object hierarchy.
> For example {food:{fruit;{a:apples,b:bananas,c:cherries}}}
> Would map to the following CF names: food.fruit.a, food.fruit.b, food.fruit.c
> However, secondary index names cannot contain periods which means workarounds (ie denormalization) must be used to index such columns.
> It would be nice if this restriction could be removed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira