From user-return-26180-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed May 16 03:54:10 2012 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 66474C163 for ; Wed, 16 May 2012 03:54:10 +0000 (UTC) Received: (qmail 57442 invoked by uid 500); 16 May 2012 03:54:08 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 57085 invoked by uid 500); 16 May 2012 03:54:05 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 57021 invoked by uid 99); 16 May 2012 03:54:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 May 2012 03:54:02 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of abhijit.chanda0@gmail.com designates 74.125.82.172 as permitted sender) Received: from [74.125.82.172] (HELO mail-we0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 May 2012 03:53:56 +0000 Received: by werf13 with SMTP id f13so187202wer.31 for ; Tue, 15 May 2012 20:53:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=TG2bE3uwmOO5vJJOuUy/P0XYEYSr/IUGZdFroRgbhsw=; b=vECIiuuBWh+wjPO0RBQfqV/MQJQPrXCGJww5vsypbJy3Pe/anaN5xRRh1XOXFxH+4x mjtNl/llzo0SGP7xz1+uB/XKYb1QNnVdrydZmi8D+FzIXH0hMoIV9V8r6um0rmEOnDZs fGZdmvkQqCJiiO/73cqZKl4YG4+QBAA/7gKkGNfAR4cfyfri/Nj8WePy5TashLXGijjp IKO4WLng1m1C6KJIRHARCeBieTLVKLsxdL2DR1WtgxQs7JiqqYP91DZK+7A3MmX4rxy0 TE2MPm3A1uqsuJB1l6zpZ1pRUjoAZ4qofKRE8kiMw+e3NJXdN6gjLb5VcRrUc8RxVtuU a9kQ== MIME-Version: 1.0 Received: by 10.180.100.230 with SMTP id fb6mr3974964wib.3.1337140414338; Tue, 15 May 2012 20:53:34 -0700 (PDT) Received: by 10.216.48.134 with HTTP; Tue, 15 May 2012 20:53:33 -0700 (PDT) In-Reply-To: References: Date: Wed, 16 May 2012 09:23:33 +0530 Message-ID: Subject: Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra From: Abhijit Chanda To: user@cassandra.apache.org Content-Type: multipart/related; boundary=f46d041824ee69575404c01f4390 X-Virus-Checked: Checked by ClamAV on apache.org --f46d041824ee69575404c01f4390 Content-Type: multipart/alternative; boundary=f46d041824ee69575104c01f438f --f46d041824ee69575104c01f438f Content-Type: text/plain; charset=ISO-8859-9 Content-Transfer-Encoding: quoted-printable Sorry for the confusion Tamar. Any ways thanks dear. Regards, Abhijit On Tue, May 15, 2012 at 9:36 PM, Tamar Fraenkel wrote= : > Actually woman ;-) > > *Tamar Fraenkel * > Senior Software Engineer, TOK Media > > [image: Inline image 1] > > tamar@tok-media.com > Tel: +972 2 6409736 > Mob: +972 54 8356490 > Fax: +972 2 5612956 > > > > > > On Tue, May 15, 2012 at 3:45 PM, Abhijit Chanda > wrote: > >> Thanks so much Guys, specially Tamar, thank you so much man. >> >> Regards, >> Abhijit >> >> >> On Tue, May 15, 2012 at 4:26 PM, Tamar Fraenkel wro= te: >> >>> Do you still need the sample code? I use Hector, well here is an exampl= e: >>> *This is the Column Family definition:* >>> (I have a composite, but if you like you can have only the UTF8Type). >>> >>> CREATE COLUMN FAMILY title_indx >>> with comparator =3D 'CompositeType(UTF8Type,UUIDType)' >>> and default_validation_class =3D 'UTF8Type' >>> and key_validation_class =3D 'LongType'; >>> >>> *The Query:* >>> SliceQuery query =3D >>> HFactory.createSliceQuery(CassandraHectorConn.getKeyspace()= , >>> LongSerializer.get(), >>> CompositeSerializer.get(), >>> StringSerializer.get()); >>> query.setColumnFamily("title_indx"); >>> query.setKey(...) >>> >>> Composite start =3D new Composite(); >>> start.add(prefix); >>> char c =3D lowerCasePrefix.charAt(lastCharIndex); >>> String prefixEnd =3D prefix.substring(0, lastCharIndex) + ++c; >>> Composite end =3D new Composite(); >>> end.add(prefixEnd); >>> >>> ColumnSliceIterator iterator =3D >>> new ColumnSliceIterator( >>> query, start, end, false) >>> while (iterator.hasNext()) { >>> ... >>> } >>> >>> Cheers, >>> >>> *Tamar Fraenkel * >>> Senior Software Engineer, TOK Media >>> >>> [image: Inline image 1] >>> >>> tamar@tok-media.com >>> Tel: +972 2 6409736 >>> Mob: +972 54 8356490 >>> Fax: +972 2 5612956 >>> >>> >>> >>> >>> >>> On Tue, May 15, 2012 at 1:19 PM, samal wrote: >>> >>>> You cannot extract via relative column value. >>>> It can only extract via value if it has secondary index but exact >>>> column value need to match. >>>> >>>> as tamar suggested you can put value as column "name" , UTF8 comparato= r. >>>> >>>> { >>>> 'name_abhijit'=3D>'abhijit' >>>> 'name_abhishek'=3D>'abhiskek' >>>> 'name_atul'=3D>'atul' >>>> } >>>> >>>> here you can do slice query on column name and get desired result. >>>> >>>> /samal >>>> >>>> On Tue, May 15, 2012 at 3:29 PM, selam wrote: >>>> >>>>> Mapreduce jobs may solve your problem for batch processing >>>>> >>>>> >>>>> On Tue, May 15, 2012 at 12:49 PM, Abhijit Chanda < >>>>> abhijit.chanda0@gmail.com> wrote: >>>>> >>>>>> Tamar, >>>>>> >>>>>> Can you please illustrate little bit with some sample code. It highl= y >>>>>> appreciable. >>>>>> >>>>>> Thanks, >>>>>> >>>>>> >>>>>> On Tue, May 15, 2012 at 10:48 AM, Tamar Fraenkel >>>>> > wrote: >>>>>> >>>>>>> I don't think this is possible, the best you can do is prefix, if >>>>>>> your order is alphabetical. For example I have a CF with >>>>>>> comparator UTF8Type, and then I can do slice query and bring all co= lumns >>>>>>> that start with the prefix, and end with the prefix where you repla= ce the >>>>>>> last char with the next one in order (i.e. "aaa"-"aab"). >>>>>>> >>>>>>> Hope that helps. >>>>>>> >>>>>>> *Tamar Fraenkel * >>>>>>> Senior Software Engineer, TOK Media >>>>>>> >>>>>>> [image: Inline image 1] >>>>>>> >>>>>>> tamar@tok-media.com >>>>>>> Tel: +972 2 6409736 >>>>>>> Mob: +972 54 8356490 >>>>>>> Fax: +972 2 5612956 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, May 15, 2012 at 7:56 AM, Abhijit Chanda < >>>>>>> abhijit.chanda0@gmail.com> wrote: >>>>>>> >>>>>>>> I don't know the exact value on a column, but I want to do a >>>>>>>> partial matching to know all available values that matches. >>>>>>>> I want to do similar kind of operation that LIKE operator in SQL >>>>>>>> do. >>>>>>>> Any help is highly appreciated. >>>>>>>> >>>>>>>> -- >>>>>>>> Abhijit Chanda >>>>>>>> Software Developer >>>>>>>> VeHere Interactive Pvt. Ltd. >>>>>>>> +91-9748888395 >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Abhijit Chanda >>>>>> Software Developer >>>>>> VeHere Interactive Pvt. Ltd. >>>>>> +91-9748888395 >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Sayg=FDlar && =DDyi =C7al=FD=FEmalar >>>>> Timu EREN ( a.k.a selam ) >>>>> >>>> >>>> >>> >> >> >> -- >> Abhijit Chanda >> Software Developer >> VeHere Interactive Pvt. Ltd. >> +91-9748888395 >> >> > --=20 Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91-9748888395 --f46d041824ee69575104c01f438f Content-Type: text/html; charset=ISO-8859-9 Content-Transfer-Encoding: quoted-printable Sorry for the confusion Tamar. Any ways thanks dear.

Regards,
Abh= ijit

On Tue, May 15, 2012 at 9:36 PM, Tam= ar Fraenkel <tamar@tok-media.com> wrote:
Actually woman ;-)

= Tamar Fraenkel=A0
Senior Software Engineer, TOK Media=A0

3D"Inline

tamar@tok= -media.com
Tel:=A0=A0=A0+972 2 6409736= =A0
Mob:=A0=A0+972 54 8356490=A0
Fax:= =A0=A0=A0+972 2 5612956=A0





On Tue, May= 15, 2012 at 3:45 PM, Abhijit Chanda <abhijit.chanda0@gmail.com> wrote:
Thanks so much Guys, specially Tamar, thank you so much man.

Regards= ,
Abhijit


On Tue, May 15, 20= 12 at 4:26 PM, Tamar Fraenkel <tamar@tok-media.com> wrote:=
Do you still need the sampl= e code? I use Hector, well here is an example:
This is the Column Fa= mily definition:
(I have a composite, but if you like you can have only the=A0UTF8Type)= .

CREATE COLUMN FAMILY title_indx
=A0 =A0 = with comparator =3D 'CompositeType(UTF8Type,UUIDType)'
=A0 =A0 and default_validation_class =3D 'UTF8Type= 9;
=A0 =A0 and key_validation_class =3D 'LongTyp= e';

The Query:
=A0 =A0 Sl= iceQuery<Long, Composite, String> query =3D
=A0 =A0 =A0 =A0 =A0 =A0 HFactory.createSlic= eQuery(CassandraHectorConn.getKeyspa= ce(),
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 LongSerializer.get(),
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 CompositeSerializer.get(),
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 StringSerializer<= span>.get());
=A0 =A0=A0query.setColumnFamily<= /span>("title_indx");
=A0 =A0 query.setKey(...)

=A0 =A0 Composite start =3D new Composite();
=A0 =A0 start.add<= span>(prefix);
=A0 =A0 char c =3D lowerCasePrefix.charAt(lastCharIndex);
=A0 =A0 String p= refixEnd=A0=3D=A0 prefix.substring(0, lastCharIndex) + ++c;
=A0 =A0 Composite end =3D new Composite();
=A0 =A0 end.add(prefixEnd);

=A0 =A0=A0ColumnSliceIterator&l= t;Long, Composite, String> iterator =3D
=A0 =A0 =A0 =A0 =A0 = =A0 =A0 new ColumnSliceIterator<Long, Composite, String>= (
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0query, sta= rt, end, false)
=A0 =A0=A0while (iterator.hasNext()) {
=A0 =A0 ...
=A0 =A0}

Cheers,<= /div>

= Tamar Fraenkel=A0
Senior Software Engineer, TOK Media=A0

3D"Inline

tamar@tok-media.com
Tel:=A0=A0=A0+972 2 6= 409736=A0
Mob:=A0=A0+972 54 8356490=A0
Fax:=A0=A0= =A0+972 2 5612956=A0




On Tue, May 15, 2012 at = 1:19 PM, samal <samalgorai@gmail.com> wrote:
You cannot extract via relative column value.
It can only extract via v= alue if it has secondary index but exact column value need to match.
as tamar suggested you can put value as column "name" , UTF8 com= parator.

{
'name_abhijit'=3D>'abhijit'
'name_abhish= ek'=3D>'abhiskek'
'name_atul'=3D>'atul'= ;
}

here you can do slice query on column name and get desired r= esult.

/samal

On Tue, Ma= y 15, 2012 at 3:29 PM, selam <selamtux@gmail.com> wrote:
Mapreduce jobs may solve your problem =A0for batch processing

=
On Tue, May 15, 2012 at 12:49 PM, Abhijit Ch= anda <abhijit.chanda0@gmail.com> wrote:
Tamar,

Can you please illustrate litt= le bit with some sample code. It highly appreciable.

Thanks,


On Tue, May 15, 2012 at 10:48 AM, T= amar Fraenkel <tamar@tok-media.com> wrote:
I don't think this is p= ossible, the best you can do is prefix, if your order is alphabetical. For = example I have a CF with comparator=A0UTF8Type, and then I can do slice que= ry and bring all columns that start with the prefix, and end with the prefi= x where you replace the last char with the next one in order (= i.e. "aaa"-"aab").

Hope that helps.

=
Tamar Fraenkel=A0
Senior Software E= ngineer, TOK Media=A0

3D"Inline

tamar@tok= -media.com
Tel:=A0=A0=A0+972 2 6409736= =A0
Mob:=A0=A0+972 54 8356490=A0
Fax:= =A0=A0=A0+972 2 5612956=A0





On Tue, May 15, 2012 at 7:56 AM, Abhijit= Chanda <abhijit.chanda0@gmail.com> wrote:
I don't know the exact value on a column, but I want to do a partial ma= tching to know all available values that matches.
I want to do similar = kind of operation that LIKE operator in SQL do.
Any help is highly appr= eciated.

--
Abhijit Chanda
Software Developer
VeHere Interactive Pvt. = Ltd.
+91-9748888395


<= /div>



--
Abhijit Chanda
Softw= are Developer
VeHere Interactive Pvt. Ltd.
+91-9748888395




<= /div>--
Sayg=FDlar && =DDyi =C7al= =FD=FEmalar
Timu EREN ( a.k.a selam )





--
Abhijit Chanda
Softw= are Developer
VeHere Interactive Pvt. Ltd.
+91-9748888395





--
Abhijit Chanda
Softw= are Developer
VeHere Interactive Pvt. Ltd.
+91-9748888395

--f46d041824ee69575104c01f438f-- --f46d041824ee69575404c01f4390 Content-Type: image/png; name="tokLogo.png" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: ii_135b91fb888fa9ff iVBORw0KGgoAAAANSUhEUgAAAF0AAAAnCAYAAABtyERkAAAABGdBTUEAALGPC/xhBQAACkNpQ0NQ SUNDIFByb2ZpbGUAAHgBnZZ3VFNZE8Dvey+90BJCkRJ6DU1KAJESepFeRSUkAUIJGBKwV0QFVxQV aYoiiyIuuLoUWSuiWFgUFLAvyCKgrIuriIplX/QcZf/Y/b6z88ec35s7c+/cmbnnPAAovoFCUSas AECGSCIO8/FgxsTGMfHdAAZEgAPWAHB52VlB4d4RABU/Lw4zG3WSsUygz/p1/xe4xfINYTI/m/5/ pcjLEkvQnULQkLl8QTYP5TyU03MlWTL7JMr0xDQZwxgZi9EEUVaVcfIXNv/s84XdZMzPEPFRH1nO WfwMvow7UN6SIxWgjASinJ8jFOSifBtl/XRphhDlNyjTMwTcbAAwFJldIuCloGyFMkUcEcZBeR4A BEryLE6cxRLBMjRPADiZWcvFwuQUCdOYZ8K0dnRkM30FuekCiYQVwuWlccV8JiczI4srWg7AlzvL ooCSrLZMtMj21o729iwbC7T8X+VfF796/TvIevvF42Xo555BjK5vtm+x32yZ1QCwp9Da7PhmSywD oGUTAKr3vtn0DwAgnwdA841Z92HI5iVFIslysrTMzc21EAp4FrKCfpX/6fDV859h1nkWsvO+1o7p KUjiStMlTFlReZnpmVIxMzuLyxMwWX8bYnTr/xw4K61ZeZiHCZIEYoEIPSoKnTKhKBltt4gvlAgz RUyh6J86/B/DZuUgwy9zjQKt5iOgL7EACjfoAPm9C2BoZIDE70dXoK99CyRGAdnLi9Ye/TL3KKPr n/XfFFyEfsLZwmSmzMwJi2DypOIcGaNvQqawgATkAR2oAS2gB4wBC9gAB+AM3IAX8AfBIALEgsWA B1JABhCDXLAKrAf5oBDsAHtAOagCNaAONIAToAWcBhfAZXAd3AR94D4YBCPgGZgEr8EMBEF4iArR IDVIGzKAzCAbiA3Nh7ygQCgMioUSoGRIBEmhVdBGqBAqhsqhg1Ad9CN0CroAXYV6oLvQEDQO/Qm9 gxGYAtNhTdgQtoTZsDscAEfAi+BkeCm8As6Dt8OlcDV8DG6GL8DX4T54EH4GTyEAISMMRAdhIWyE gwQjcUgSIkbWIAVICVKNNCBtSCdyCxlEJpC3GByGhmFiWBhnjC8mEsPDLMWswWzDlGOOYJoxHZhb mCHMJOYjlorVwJphnbB+2BhsMjYXm48twdZim7CXsH3YEexrHA7HwBnhHHC+uFhcKm4lbhtuH64R dx7XgxvGTeHxeDW8Gd4FH4zn4iX4fHwZ/hj+HL4XP4J/QyATtAk2BG9CHEFE2EAoIRwlnCX0EkYJ M0QFogHRiRhM5BOXE4uINcQ24g3iCHGGpEgyIrmQIkippPWkUlID6RLpAeklmUzWJTuSQ8lC8jpy Kfk4+Qp5iPyWokQxpXAo8RQpZTvlMOU85S7lJZVKNaS6UeOoEup2ah31IvUR9Y0cTc5Czk+OL7dW rkKuWa5X7rk8Ud5A3l1+sfwK+RL5k/I35CcUiAqGChwFrsIahQqFUwoDClOKNEVrxWDFDMVtikcV ryqOKeGVDJW8lPhKeUqHlC4qDdMQmh6NQ+PRNtJqaJdoI3Qc3YjuR0+lF9J/oHfTJ5WVlG2Vo5SX KVcon1EeZCAMQ4YfI51RxDjB6Ge8U9FUcVcRqGxVaVDpVZlWnaPqpipQLVBtVO1TfafGVPNSS1Pb qdai9lAdo26qHqqeq75f/ZL6xBz6HOc5vDkFc07MuacBa5hqhGms1Dik0aUxpaml6aOZpVmmeVFz Qouh5aaVqrVb66zWuDZNe762UHu39jntp0xlpjsznVnK7GBO6mjo+OpIdQ7qdOvM6BrpRupu0G3U fahH0mPrJent1mvXm9TX1g/SX6Vfr3/PgGjANkgx2GvQaTBtaGQYbbjZsMVwzEjVyM9ohVG90QNj qrGr8VLjauPbJjgTtkmayT6Tm6awqZ1pimmF6Q0z2MzeTGi2z6zHHGvuaC4yrzYfYFFY7qwcVj1r yIJhEWixwaLF4rmlvmWc5U7LTsuPVnZW6VY1Vvetlaz9rTdYt1n/aWNqw7OpsLk9lzrXe+7aua1z X9ia2Qps99vesaPZBdlttmu3+2DvYC+2b7Afd9B3SHCodBhg09kh7G3sK45YRw/HtY6nHd862TtJ nE44/eHMck5zPuo8Ns9onmBezbxhF10XrstBl8H5zPkJ8w/MH3TVceW6Vrs+dtNz47vVuo26m7in uh9zf+5h5SH2aPKY5jhxVnPOeyKePp4Fnt1eSl6RXuVej7x1vZO9670nfex8Vvqc98X6Bvju9B3w 0/Tj+dX5Tfo7+K/27wigBIQHlAc8DjQNFAe2BcFB/kG7gh4sMFggWtASDIL9gncFPwwxClka8nMo LjQktCL0SZh12KqwznBa+JLwo+GvIzwiiiLuRxpHSiPbo+Sj4qPqoqajPaOLowdjLGNWx1yPVY8V xrbG4eOi4mrjphZ6LdyzcCTeLj4/vn+R0aJli64uVl+cvvjMEvkl3CUnE7AJ0QlHE95zg7nV3KlE v8TKxEkeh7eX94zvxt/NHxe4CIoFo0kuScVJY8kuybuSx1NcU0pSJoQcYbnwRapvalXqdFpw2uG0 T+nR6Y0ZhIyEjFMiJVGaqCNTK3NZZk+WWVZ+1uBSp6V7lk6KA8S12VD2ouxWCR39meqSGks3SYdy 5udU5LzJjco9uUxxmWhZ13LT5VuXj67wXvH9SsxK3sr2VTqr1q8aWu2++uAaaE3imva1emvz1o6s 81l3ZD1pfdr6XzZYbSje8Gpj9Ma2PM28dXnDm3w21efL5YvzBzY7b67agtki3NK9de7Wsq0fC/gF 1wqtCksK32/jbbv2nfV3pd992p60vbvIvmj/DtwO0Y7+na47jxQrFq8oHt4VtKt5N3N3we5Xe5bs uVpiW1K1l7RXunewNLC0tUy/bEfZ+/KU8r4Kj4rGSo3KrZXT+/j7eve77W+o0qwqrHp3QHjgzkGf g83VhtUlh3CHcg49qYmq6fye/X1drXptYe2Hw6LDg0fCjnTUOdTVHdU4WlQP10vrx4/FH7v5g+cP rQ2shoONjMbC4+C49PjTHxN+7D8RcKL9JPtkw08GP1U20ZoKmqHm5c2TLSktg62xrT2n/E+1tzm3 Nf1s8fPh0zqnK84onyk6Szqbd/bTuRXnps5nnZ+4kHxhuH1J+/2LMRdvd4R2dF8KuHTlsvfli53u neeuuFw5fdXp6qlr7Gst1+2vN3fZdTX9YvdLU7d9d/MNhxutNx1vtvXM6znb69p74Zbnrcu3/W5f 71vQ19Mf2X9nIH5g8A7/ztjd9Lsv7uXcm7m/7gH2QcFDhYcljzQeVf9q8mvjoP3gmSHPoa7H4Y/v D/OGn/2W/dv7kbwn1Cclo9qjdWM2Y6fHvcdvPl34dORZ1rOZifzfFX+vfG78/Kc/3P7omoyZHHkh fvHpz20v1V4efmX7qn0qZOrR64zXM9MFb9TeHHnLftv5Lvrd6Ezue/z70g8mH9o+Bnx88Cnj06e/ AAOb8/zszueKAAAACXBIWXMAAA7DAAAOwwHHb6hkAAAHmklEQVRoBeVaa0wUVxQ+uzPLLqj1lbRW IkKKYgNq0WpRq0mjEWJRqVaLGmoCFdpCpYhGLP6hlvpCWl+NmGATFYH+qPhqq9W0wSqgLYhPFCxI Q2L7oyjCPthX7xkY2MedYRaGWbAnmcy959x77plvzp69c+5R2QnBICLLn7UAqg6D2aAJg8jyblPZ 7ubAatma/wVzVSVYblaB7U4l2OquAfgQGxlyodV4qQn+rAqYKZGgDp4M7MSpwASFgHr4KCIcuKRC T3/8+G8oLi7uVyvnzZsL4eHhomvYDQYw37gBphMFYC09D6AhP0ICrkpDprGkLQB614vAF0Iudnos aGa9DZqps0TXcxWePn0G6uvrXdkQFBQES5YsduPTGFKw5DzdaDRAeXkFTYdsvNDQUFFdpp8vgiF7 O9ibGjtARqB7SZbKIsDL5D8DdKsyuF+AFFUIeF9wMBqN8NVXX0NjY6PgckuXLsYfqHfJ2tQELR+l gD7+Y7A/+ktWY2xN10Gfsxz0x3aD3WSQVberMgR8z57cHgGPjY31Lujm6mp4tup9sJ694PoMsvYt l/OgbUc8WP9pklUvr4wH/PbtOzzL7Y4ejoAjceHFbYQCjParZdD23lpJK7FRq4Cd9jq3a2FCOsMU 2cFYa++A3dAGtkf3wPJ7oaguzut3xoHf5mPAvOgvOtYToaeAo26vgI4hRZ+xVfTZ2HdiQbt8BWgm TxEcxwYGd8nspkyw1NwAc9k5Es/pL8D+rBH0BPihX54Dlda3a25fGgUFJ0Cqh/PrcKAHBgZCYWEB z6PeGxoaYMuWTKps+/ZsQB1SCHcorWkbwV5Pj99MVBT4paYCG9wNqBS9Kq2O7FYiuMvyYAUYC3eA rYlsM10IgTd8mw1+H37hIvG8W1RUBBcvXhKc6BhSHAcp/kdqOn8BbGV/ONrQ1dZuTocX9u/3GPAu BZ0NduIUGJJxBNi5Sa4iro87G3N1GVUmlYmAnzp1RnC4EOA4QVHQ0cuNufuohmoz04n30UGiTuiB iZ7vF7cJNJGbqCNNJXQ7qINdmH0BHFUpCnr7b1eoYUXzSaKsgDtipIteC0xIlCOLa+Mfq+VBtRu/ J8aVK1d77eG8bmVB/+VXfl2nu9+6BKe+nB30eN2KT6kqzbc8CzFVVVVw4MBBqi5kioUUx0mKgm45 9p3j2lwbvVw9cqQbX04GExAMav+ZbiptDbfceEIMBHzXrhwhsWTAUQG3exHUJKMAt4k00kwTz8fQ 5vSGx86MhvaTzrsZ632S35FANTU1oukBqR7OL6WYp9v1en5NpzsTON6p318dle/QXqt+8uSp6Ny2 NvqzCU1SDHQhA54HPu7V8Q9WKikGunr0aKpN1oZHVL7cTLuhVW6VTvqOHz8OmNaVQsqBPop+sGCu rJJiZ5/HWK6dddPBhES68XrLwBCUn58PmIvpiRQDHQ3RpKxzs8e8/zDYmpvd+HIyzDfLqSkB5tXZ Hi8zYsRwwTmYgykpKRGU8wJFQfeZ+ya/rtO9LSfXqS9nx24ygukk/etTE+a+jRRbOywslBxS5ALe hQhTA7jbESNFQdeEvwaqoHFu9liOFoP+UJ4bv68MBFx/YCPVy9XkVIkJmCB5CQQ6PX0D6HQ6SEgQ /5jbu3cfiO14FAVd5esLug3rqQ9qyt4DrbtzwC4hJlIVuDB5wK33f3KRdHTxGE8qBQQEdAGOc8aM eQlSUpIFpyPgBw8Kf7kqCjpaqYtZCkz0QqrB5m8OQ0t8PFjq6qhyqcz2ikvQmhkNQoBj9hErB6TS 2LEvcx7uOH7OnNkQEfGGI8upjfEdD7pppDjoaMTQ7M+pYQZltuskEXX3LjY9ItvTZmgvJ2BnrQZj fhLYWxqo83HH4rsyhSrzlJmUlAhif6yFhUWA5xCupFgawHFhNdk+Dis8yp2PCh1mOI7Htu1JM5jL S7kjO67YiBzXIVkbH4DtIamNwQMLhjDw6pSh3JFUwwJAF/eZbKdGGN9TU9dDVtY2x2Wc2jt37uL+ fHEsT14BHRdn/P054Fsi3uJtod4tD+ug/YeTYP7+UM91L1QNHUzOwz/YJnsh0qRJk7hkl9CBBsb3 vLzD3MvhzfMa6GgAAi9E7RXlYDy0D2z3rnUWGwmN7JnvE5MF2vnLZPNw1xVjYmKgqqpasPwCa2lC Qy/BggXzualeiemuRrv2jRnpoE+MA9st56yg67ie+uy0WBiy9UfQLVrTb4CjDRg60tLoOXvexvz8 I11pggEJOm9ob++ayI0c2Hj47MlevLfr4TzcRiYkxIuqwOovTBN4NbyIWihRqB4/gxxQvAJMGPnY 8Q8ENkT6VlDiEpKHYfioqKgQLMnAcjss2Rg0oKtDZoA2IZXUwZCvWp08NSuS0fRgYHJyMilV2SL4 RYppYMmg68iDCn0MoKy/iF1Eio6WkaKjsP734CBSnUsjIT5tLO7bExPXQWnpZZqY43Gl0oJSBQTN 4yZ2r4IuQEqisTTaJy0ddO+uJOen9JRw96TB15Ls6Uo8mnrmdNCuJp69cCFgnuZ5pQEBOuZidHFr wGe2Z0X8g/WleD28WGprgZ0gPcU6WIF2tNvroDsa839pP5cfRwP95f0HN8yA0D1xOrwAAAAASUVO RK5CYII= --f46d041824ee69575404c01f4390--