[
https://issues.apache.org/jira/browse/CASSANDRA-4920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sidharth updated CASSANDRA-4920:
--------------------------------
Summary: Add collation semantics to abstract type to provide standard sort
order for Strings (was: Add Collation semantics to abstract type to provide
standard sort order for Strings)
> Add collation semantics to abstract type to provide standard sort order for
> Strings
> -----------------------------------------------------------------------------------
>
> Key: CASSANDRA-4920
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4920
> Project: Cassandra
> Issue Type: Improvement
> Components: API, Core
> Affects Versions: 1.2.0 beta 1
> Reporter: Sidharth
> Priority: Minor
> Labels: cassandra
>
> Adding a way to sort UTF8 based on below described collation semantics can be
> useful.
> Use case: Say for example you have wide rows where you cannot use cassandra's
> standard indexes(secondary/primary index). Lets say each column had a string
> value that was either one of alphanumeric or purely numeric and you wanted an
> index by value. MOre specifically you want to slice range over a bunch of
> column values and say "get me all the ID's associated with value ABC to XYZ
> ". As usual I would index these values in a materialized views
> More specifically I create an index CF; And add these values into a
> CompositeType column and SliceRange over them for the indexing to work and I
> dont really care weather its a alpha or a numeric as long as its ordered by
> the following collation semantics as follows:
> 1) If the string is a numeric then it should be comparable like a numeric
> 2) If its a alpha then it should be comparable like a normal string.
> 3) If its a alhpa-numeric then a contiguos sequence of numbers in the string
> should be compared as numbers like "c10" > "c2".
> 4) UTF8 type strings assumed everywhere.
> How this helps?:
> 1) You dont end up creating multiple CF for different value types.
> 2) You dont have to write boiler plate to do complicated type detection and
> do this manually in the application.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
