Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
MIME-Version: 1.0
In-Reply-To: <CAGbQL+VSXMwao-20oRNvdNK-Lo32S=rFz-KnUFH6Xqr3VE5CtA@mail.gmail.com>
References: <0B8CBB75-11C6-40B0-A458-E8F8CDB172A1@googlemail.com>
 <21C5F4F1-30F8-4AFD-B00F-2B401CC54505@bamlabs.com> <796FA59D-D873-4440-9BC7-D77C3A82B777@googlemail.com>
 <CAGbQL+VSXMwao-20oRNvdNK-Lo32S=rFz-KnUFH6Xqr3VE5CtA@mail.gmail.com>
From: kurt greaves <kurt@instaclustr.com>
Date: Tue, 9 May 2017 03:06:53 +0000
Message-ID: <CAPbVhuPP_T5w4rk0kkYyR03f40boF+oxy14B6F_2TCzYzD9Czw@mail.gmail.com>
Subject: Re: Smart Table creation for 2D range query
To: Anthony Grasso <anthony.grasso@gmail.com>
Cc: Lydia Ickler <icklerly@googlemail.com>, user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=94eb2c07d65c3619eb054f0ea8cb
archived-at: Tue, 09 May 2017 03:07:42 -0000

--94eb2c07d65c3619eb054f0ea8cb
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Note that will not give you the desired range queries of 0 >=3D x <=3D 1 an=
d 0
>=3D y <=3D 1.


=E2=80=8BSomething akin to Jon's solution could give you those range querie=
s if you
made the x and y components part of the clustering key.

For example, a space of (1,1) could contain all x,y coordinates where x and
y are > 0 and <=3D 1. You would then have a table like:

CREATE TABLE geospatial (
space text,
x double,
y double,
item text,
m1,
m2,
m3,
primary key ((space), x, y, m1, m2, m3, m4, m5)
);

A query of select * where space =3D '1,1' and x <1 and x >0.5 and y< 0.2 an=
d
y>0.1; should yield all x and y pairs and their distinct metadata. Or
something like that anyway.

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

<div dir=3D"ltr">Note that will not give you the desired range queries of 0=
 &gt;=3D x &lt;=3D 1 and 0 &gt;=3D y &lt;=3D 1.<div><br></div><div><br></di=
v>=E2=80=8BSomething akin to Jon&#39;s solution could give you those range =
queries if you made the x and y components part of the clustering key.<div>=
<br></div><div>For example, a space of (1,1) could contain all x,y coordina=
tes where x and y are &gt; 0 and &lt;=3D 1. You would then have a table lik=
e:</div><div><br></div><div><div>CREATE TABLE geospatial (</div><div>space =
text,</div><div>x double,</div><div>y double,</div><div>item text,</div><di=
v>m1,</div><div>m2,</div><div>m3,</div><div>primary key ((space), x, y, m1,=
 m2, m3, m4, m5)</div><div>);</div></div><div><br></div><div>A query of sel=
ect * where space =3D &#39;1,1&#39; and x &lt;1 and x &gt;0.5 and y&lt; 0.2=
 and y&gt;0.1; should yield all x and y pairs and their distinct metadata. =
Or something like that anyway.</div><div><br></div></div>

--94eb2c07d65c3619eb054f0ea8cb--