[
https://issues.apache.org/jira/browse/CASSANDRA-10623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14995176#comment-14995176
]
Robert Stupp commented on CASSANDRA-10623:
------------------------------------------
[~Digot] you just cannot apply any functions on primary key column values.
Cassandra does not perform scans (like an RDBMS) on partition keys - you have
to provide the _exact_ partition key (requirement to be able to scale out).
Comparisons on clustering keys must also provide the "original" order.
As a recommendation: store the data in lower/upper case and duplicate the
original value.
However, you can apply UDFs on the selected columns.
> Text Functions
> --------------
>
> Key: CASSANDRA-10623
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10623
> Project: Cassandra
> Issue Type: New Feature
> Reporter: Markus Stephanides
>
> In SQL, there are functions that make comparing texts easier e.g UPPER() and
> LOWER()
> I need this to compare a text in a WHERE clause of a SELECT statement with
> case-insensitvity.
> Thank you in advance!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
