Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of oifa.yulian@gmail.com
 designates 209.85.220.41 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CA+4UHyPAnv9vKPqoDKW04mA72bUTcNOvvhVjg0=WrgVqdRMdYw@mail.gmail.com>
References: 
 <CAF_ijKL3VtPxn8jXSc+9vkG7aC2SNiJQGjz73PT9m5Odva_0Yw@mail.gmail.com>
	<CA+4UHyPAnv9vKPqoDKW04mA72bUTcNOvvhVjg0=WrgVqdRMdYw@mail.gmail.com>
Date: Tue, 3 Mar 2015 17:18:10 +0200
Message-ID: 
 <CAF_ijK+tFgo_OKvsTmH5jC2WEdQ9FzORWCLNwXtq9ojtkF1Hgw@mail.gmail.com>
Subject: Re: Composite Keys in cassandra 1.2
From: Yulian Oifa <oifa.yulian@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a11c2e256bb8279051063d7bb

--001a11c2e256bb8279051063d7bb
Content-Type: text/plain; charset=UTF-8

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

--001a11c2e256bb8279051063d7bb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div><div>Hello<br></div>Initially problem is th=
at customer wants to have an option for ANY query , which does not fits goo=
d with NOSQL.However the size of data is too big for Relational DB. <br>The=
re are no typical queries on the data, there are 10 fields , based on which=
 ( any mix of them also ) queries should be made.<br></div>Till now i allow=
ed only single field query ( in specific cases with 2 fields ) so i had ind=
exes CFs for each field and that solved a problem.Since now i need compound=
s , sometimes 5-6 fields i either need to iterate over index CF based on so=
me 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 inde=
x for each group of fields of course is not an option since number of index=
es will be huge , and disk usage will be too big.<br><br></div>Best regards=
<br></div>Yulian Oifa<br></div><div class=3D"gmail_extra"><br><div class=3D=
"gmail_quote">On Mon, Mar 2, 2015 at 5:33 PM, Kai Wang <span dir=3D"ltr">&l=
t;<a href=3D"mailto:depend@gmail.com" target=3D"_blank">depend@gmail.com</a=
>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 =
0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div=
><div>AFIK it&#39;s not possible. The fact you need to query the data by pa=
rtial row key indicates your data model isn&#39;t proper. What are your typ=
ical queries on the data?<br></div></div></div><div class=3D"HOEnZb"><div c=
lass=3D"h5"><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Su=
n, Mar 1, 2015 at 7:24 AM, Yulian Oifa <span dir=3D"ltr">&lt;<a href=3D"mai=
lto:oifa.yulian@gmail.com" target=3D"_blank">oifa.yulian@gmail.com</a>&gt;<=
/span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8=
ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><div>=
<div><div><div>Hello to all.<br></div>Lets assume a scenario where key is c=
ompound type with 3 types in it ( Long , UTF8, UTF8 ).<br></div>Each row st=
ores timeuuids as column names and empty values.<br></div>Is it possible to=
 retreive data by single key part ( for example by long only ) by using jav=
a thrift?<br><br></div>Best regards<span><font color=3D"#888888"><br></font=
></span></div><span><font color=3D"#888888">Yulian Oifa<br><div><div><div><=
div><div><div><br></div><br></div></div></div></div></div></font></span></d=
iv>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>

--001a11c2e256bb8279051063d7bb--