cassandra-commits mailing list archives

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


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:
>             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

View raw message