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 josh@keen.io designates
 209.85.192.169 as permitted sender)
Date: Fri, 20 Dec 2013 15:43:30 -0800
From: Josh Dzielak <josh@keen.io>
To: user@cassandra.apache.org
Message-ID: <907790B2B04448DC876125169213ED4E@keen.io>
In-Reply-To: 
 <CAKmMYa9e_xteGKnOfgVyfFMmaagZoND4HosRGtpNOepPio7=ZA@mail.gmail.com>
References: <8DB123D233A54FE088FD836949D1B20C@keen.io>
 <CAKmMYa9e_xteGKnOfgVyfFMmaagZoND4HosRGtpNOepPio7=ZA@mail.gmail.com>
Subject: Re: Multi-Column Slice Query w/ Partial Component of Composite
 Key
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="52b4d622_39b7aaa2_f520"

--52b4d622_39b7aaa2_f520
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thanks Nate. =20

I will take a look at extending thrift, seems like this could be useful f=
or some folks. =20


On =46riday, December 20, 2013 at 12:29 PM, Nate McCall wrote:

> > =20
> > My questions =E2=80=93
> > =20
> > 1) Is this supported in the Thrift interface or CQL=3F
> =20
> Not directly, no. =20
>  =20
> > 2) If not, is there clever data modeling or indexing that could accom=
plish this use case=3F 1 single-row round-trip to get these columns=3F
> > =20
> =20
> =20
> If this is a query done frequently you could prefix both columns with a=
 static value, eg. =5B=22foo:username....=22, foo:city...=22, =22bar:othe=
r=5Fcolumn:...=22=5D so in this specific case you look for 'foo:*' =20
>  =20
> > 3) Is there plans to support this in the future=3F Generally, what is=
 the future of composite columns in a CQL world=3F
> > =20
> =20
> You can always extend cassandra.thrift and add a custom method (not as =
hard as it sounds - Thrift is designed for this). Side note: DataStax Ent=
erprise works this way for reading the Cassandra=46ileSystem blocks. An e=
arly prototype: =20
> https://github.com/riptano/brisk/blob/master/interface/brisk.thrift=23L=
68-L80 =20
> =20
> =20
> =20
> -- =20
> -----------------
> Nate McCall
> Austin, TX
> =40zznate
> =20
> Co-=46ounder & Sr. Technical Consultant
> Apache Cassandra Consulting
> http://www.thelastpickle.com =20


--52b4d622_39b7aaa2_f520
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


                <div>
                    Thanks Nate.
                </div><div><br></div><div>I will take a look at extending=
 thrift, seems like this could be useful for some folks.</div>
                <div></div>
                =20
                <p style=3D=22color: =23A0A0A8;=22>On =46riday, December =
20, 2013 at 12:29 PM, Nate McCall wrote:</p>
                <blockquote type=3D=22cite=22 style=3D=22border-left-styl=
e:solid;border-width:1px;margin-left:0px;padding-left:10px;=22>
                    <span><div><div><div dir=3D=22ltr=22><div><div><block=
quote type=3D=22cite=22><div>
<div><br></div><div>My questions =E2=80=93</div><div><br></div><div>1) Is=
 this supported in the Thrift interface or CQL=3F</div></div></blockquote=
><div><br></div><div>Not directly, no.&nbsp;</div><div>&nbsp;</div><block=
quote type=3D=22cite=22><div>
<div>2) If not, is there clever data modeling or indexing that could acco=
mplish this use case=3F 1 single-row round-trip to get these columns=3F</=
div></div></blockquote><div><br></div><div>If this is a query done freque=
ntly you could prefix both columns with a static value, eg. =5B=22foo:use=
rname....=22, foo:city...=22, =22bar:other=5Fcolumn:...=22=5D so in this =
specific case you look for 'foo:*'</div>
<div>&nbsp;</div><blockquote type=3D=22cite=22><div><div>3) Is there plan=
s to support this in the future=3F Generally, what is the future of compo=
site columns in a CQL world=3F</div>
<div><br></div></div></blockquote><div><br></div><div>You can always exte=
nd cassandra.thrift and add a custom method (not as hard as it sounds - T=
hrift is designed for this). Side note: DataStax Enterprise works this wa=
y for reading the Cassandra=46ileSystem blocks. An early prototype:</div>=

<div><a href=3D=22https://github.com/riptano/brisk/blob/master/interface/=
brisk.thrift=23L68-L80=22>https://github.com/riptano/brisk/blob/master/in=
terface/brisk.thrift=23L68-L80</a>&nbsp;</div></div><br clear=3D=22all=22=
><div><br></div>-- <br>
<div dir=3D=22ltr=22>-----------------<br>Nate McCall<br>Austin, TX<br>=40=
zznate<br><br>Co-=46ounder &amp; Sr. Technical Consultant<br>Apache Cassa=
ndra Consulting<br><a href=3D=22http://www.thelastpickle.com=22 target=3D=
=22=5Fblank=22>http://www.thelastpickle.com</a></div>

</div></div>
</div></div></span>
                =20
                =20
                =20
                =20
                </blockquote>
                =20
                <div>
                    <br>
                </div>
            
--52b4d622_39b7aaa2_f520--