[CASSANDRA-7747] CQL token(id) does not work in DELETE statements

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.11
• Component/s: Legacy/Tools

Environment

CQL on CentOS 7 and Arch Linux, Cassandra 2.0.9

• Severity: Low
• Assignee: Sylvain Lebresne
• Reporter: Taylor Gronka

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Created: 11/Aug/14 19:16
• Updated: 16/Apr/19 09:31
• Resolved: 17/Oct/14 09:34

Description

When I try to delete a row by the token of the primary key, this happens:

cqlsh> delete from keyspace.table where token(id) = 0x478e5222f7484a5596344392e4451d59;
Bad Request: Invalid HEX constant (0x478e5222f7484a5596344392e4451d59) for id of type uuid

I'm using a blob-type because my data is highly organized, so I'm running a ByteOrderedPartitioner. This isn't a major issue, but it will save me a bit of coding hassle and cpu cycles to not be converting in and out of uuid's.

Also, I find it curious that the ByteOrderedPartitioner stores values as blob, but returns them as uuid - although I imagine this discussion took place long before I got here. Might there be a way to set Cassandra to deal solely with blobs? Or at least to return a uuid as blob?