cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alvin UW <alvi...@gmail.com>
Subject Build an index to for join query
Date Wed, 15 Sep 2010 23:34:20 GMT
Hello,

I am going to build an index to join two CFs.
First, we see this index as a CF/SCF. The difference is I don't materialise
it.
Assume we have two tables:
ID_Address(*Id*, address) ,  Name_ID(*name*, id)
Then,the index is: Name_Address(*name*, address)

When the application tries to query on Name_Address, the value of "name" is
given by the application.
I want to direct the read operation  to Name_ID to get "Id" value, then go
to ID_Address to
get the "address" value by the "Id" value. So far, I consider only the read
operation.
By this way, the join query is transparent to the user.

So I think I should find out which methods or classes are in charge of the
read operation in the above operation.
For example, the operation in cassandra CLI "get
Keyspace1.Standard2['jsmith']" calls exactly which methods
in the server side?

I noted CassandraServer is used to listen to clients, and there are some
methods such as get(), get_slice().
Is it the right place I can modify to implement my idea?

Thanks.

Alvin

Mime
View raw message