incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Robson <mar...@gmail.com>
Subject Re: Table Index
Date Tue, 07 Jul 2009 06:00:15 GMT
2009/7/7 Vijay <vijay2win@gmail.com>

> The reason i am asking is i have multiple columns which a user can query on
> like UID, URL, TAGS (all of them are unique).... but how can i get to them
> without getting stuck with the rowid? coz rowid can be one of those.... and
> the user at any time can know only one....


You have to create your own index as another table, and range scan that to
get the keys for your main table. It's not pretty.

But in any case, that's what a (traditional) database really does internally
anyway, it's just a bit more automatic.

I find the awkward bit is cleaning up cross-references, when you want to
throw a row out of the main table, each of its indexes need to be cleaned up
by a separate delete operation.

Mark

Mime
View raw message