[
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