cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Stupp (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-10623) Text Functions
Date Sat, 07 Nov 2015 11:55:11 GMT

    [ 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)

Mime
View raw message