Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
From: Atul Saroha <atul.saroha@snapdeal.com>
Date: Wed, 18 May 2016 16:38:12 +0530
Message-ID: <CAG0vsS+mDeA9EGnJii04Vb417v9Next=pbfeY6QJjAPgAbA2GQ@mail.gmail.com>
Subject: Migrating from Cassandra-Lucene to SASI
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a114104fec584ef05331be0e2
archived-at: Wed, 18 May 2016 11:08:39 -0000

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

From Duy Hai DOAN's blog http://www.doanduyhai.com/blog/?p=2058 :

   Please note that SASI does not intercept DELETE for indexing. Indeed the
> resolution and reconciliation of deleted data is let to Cassandra at read
> time. SASI only indexes INSERT and UPDATE.
>

With this it feels that Lucene is better if you have use-case of frequent
deletes on CF as it marks documents deleted and will be cleaned later.

Though I dint find any doc mentioning how SASI indexes are cleaned after
grace period expired for the tombstone. Will it be remove or not? Ideally
it should be removed.

Also fetching functionality of lucene 'filter' search and SASI is also
sequancial, i.e. no scatter gather.

Does it worth to migrate to SASI if your column family face heavy deletes
too.
---------------------------------------------------------------------------------------------------------------------
Atul Saroha
*Sr. Software Engineer*
*M*: +91 8447784271 *T*: +91 124-415-6069 *EXT*: 12369
Plot # 362, ASF Centre - Tower A, Udyog Vihar,
 Phase -4, Sector 18, Gurgaon, Haryana 122016, INDIA

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

<div dir=3D"ltr"><div><div>From Duy Hai DOAN&#39;s blog <a href=3D"http://w=
ww.doanduyhai.com/blog/?p=3D2058">http://www.doanduyhai.com/blog/?p=3D2058<=
/a> :<br><br><blockquote style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex" class=3D"gmail_quote">=C2=A0=C2=A0=
=C2=A0Please note that SASI does not intercept DELETE for indexing. Indeed =
the resolution and reconciliation of deleted data is let to Cassandra at re=
ad time. SASI only indexes INSERT and UPDATE.<br></blockquote><br>With this=
 it feels that Lucene is better if you have use-case of frequent deletes on=
 CF as it marks documents deleted and will be cleaned later. <br><br>Though=
 I dint find any doc mentioning how SASI indexes are cleaned after grace pe=
riod expired for the tombstone. Will it be remove or not? Ideally it should=
 be removed.<br><br></div>Also fetching functionality of lucene &#39;filter=
&#39; search and SASI is also sequancial, i.e. no scatter gather.<br><br></=
div>Does it worth to migrate to SASI if your column family face heavy delet=
es too.<br clear=3D"all"><div><div><div><div class=3D"gmail_signature"><div=
 dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><span><div style=
=3D"font-weight:bold;font-stretch:normal;font-size:15px;line-height:16px;fo=
nt-family:Arial,Helvetica,sans-serif;color:rgb(251,2,41)"><span style=3D"co=
lor:rgb(178,0,0)">---------------------------------------------------------=
------------------------------------------------------------<br>Atul Saroha=
</span><span><span><img src=3D"http://i1.sdlcdn.com/img/marketing-mailers/m=
ailer/2015/MKT/refer_23dec/images/sd_logo_23dec.png" align=3D"right" height=
=3D"72" hspace=3D"0" vspace=3D"0" width=3D"219"></span></span><br style=3D"=
color:rgb(0,0,0)"><span style=3D"font:bold 11px/16px Arial,Helvetica,sans-s=
erif;color:rgb(0,0,0)"><b>Sr. Software Engineer</b></span><br></div><span s=
tyle=3D"font:11px/16px Arial,Helvetica,sans-serif;color:rgb(139,139,139)"><=
b style=3D"color:rgb(116,116,116)">M</b>: +91 8447784271=C2=A0</span><span =
style=3D"font:11px/16px Arial,Helvetica,sans-serif;color:rgb(139,139,139)">=
<span style=3D"font-stretch:normal;font-size:11px;line-height:16px;font-fam=
ily:Arial,Helvetica,sans-serif;color:rgb(139,139,139)"><b>T</b>: +91 124-41=
5-6069 <b>EXT</b>: 12369</span></span><span style=3D"font:11px/16px Arial,H=
elvetica,sans-serif;color:rgb(139,139,139)"><br></span><span style=3D"font-=
stretch:normal;font-size:11px;line-height:16px;font-family:Arial,Helvetica,=
sans-serif;color:rgb(139,139,139)">Plot # 362, ASF Centre - Tower A, Udyog =
Vihar,<br>=C2=A0Phase -4, Sector 18, Gurgaon, Haryana 122016, INDIA</span><=
/span></div></div></div></div></div></div></div>
</div></div></div>

--001a114104fec584ef05331be0e2--