[ 
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

        

Reply via email to