cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yulian Oifa <oifa.yul...@gmail.com>
Subject Re: Composite Keys in cassandra 1.2
Date Tue, 03 Mar 2015 15:18:10 GMT
Hello
Initially problem is that customer wants to have an option for ANY query ,
which does not fits good with NOSQL.However the size of data is too big for
Relational DB.
There are no typical queries on the data, there are 10 fields , based on
which ( any mix of them also ) queries should be made.
Till now i allowed only single field query ( in specific cases with 2
fields ) so i had indexes CFs for each field and that solved a
problem.Since now i need compounds , sometimes 5-6 fields i either need to
iterate over index CF based on some column ( or may be read several indexes
and find common ids ) or create some index that will allow me to read data
based on any part. Creating index for each group of fields of course is not
an option since number of indexes will be huge , and disk usage will be too
big.

Best regards
Yulian Oifa

On Mon, Mar 2, 2015 at 5:33 PM, Kai Wang <depend@gmail.com> wrote:

> AFIK it's not possible. The fact you need to query the data by partial row
> key indicates your data model isn't proper. What are your typical queries
> on the data?
>
> On Sun, Mar 1, 2015 at 7:24 AM, Yulian Oifa <oifa.yulian@gmail.com> wrote:
>
>> Hello to all.
>> Lets assume a scenario where key is compound type with 3 types in it (
>> Long , UTF8, UTF8 ).
>> Each row stores timeuuids as column names and empty values.
>> Is it possible to retreive data by single key part ( for example by long
>> only ) by using java thrift?
>>
>> Best regards
>> Yulian Oifa
>>
>>
>>
>

Mime
View raw message