Return-Path: X-Original-To: apmail-accumulo-user-archive@www.apache.org Delivered-To: apmail-accumulo-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 8BB4C10361 for ; Tue, 1 Oct 2013 19:49:00 +0000 (UTC) Received: (qmail 82575 invoked by uid 500); 1 Oct 2013 19:48:59 -0000 Delivered-To: apmail-accumulo-user-archive@accumulo.apache.org Received: (qmail 82296 invoked by uid 500); 1 Oct 2013 19:48:58 -0000 Mailing-List: contact user-help@accumulo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@accumulo.apache.org Delivered-To: mailing list user@accumulo.apache.org Received: (qmail 82288 invoked by uid 99); 1 Oct 2013 19:48:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Oct 2013 19:48:58 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of wilhelm.von.cloud@accumulo.net does not designate 209.85.216.170 as permitted sender) Received: from [209.85.216.170] (HELO mail-qc0-f170.google.com) (209.85.216.170) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Oct 2013 19:48:50 +0000 Received: by mail-qc0-f170.google.com with SMTP id m20so5210725qcx.1 for ; Tue, 01 Oct 2013 12:48:29 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=gca1AxVy21SxHitmWtOr+bUSW7q5q2+0UUqtUTQ/wsY=; b=T3+RV6OkTJVlsAmoQwcmAV8TW1v9ejHQ4bP4TH2U46aZJB3ljYXXCVNRjiOqsQdc2O L+q5IcOQqhsncXnw1JzJCyM1g8v0pjvjps6g9v9GMuVnS8rz9D15N47E/hN5uQFUQQ6G OlVaXrrxhXIFjSc+weOy7Eg3YrgRFPVSAUc1jrRooZhCuLaGTNsgKeIFZI/+gDpQ9kLx HYOx+qIKHqgL4zLgU2qmlpJgamQkIBmrvNOMDflmKrc7B66SScHG6X9Ro/8FsHntvmce duFH6CDIwZod27kj1e1j3cgs8e9oS2uSNTomA7cz/a9XH72ubuU0CTH/7ViUv2ZhSIsI 8wNg== X-Gm-Message-State: ALoCoQmWoPjw5oIPAul5PCgHv0ye0qmz641Tr/pd9KGqrKkKg5SBA1YfxuvRd5AACFpK/v3z7N2S MIME-Version: 1.0 X-Received: by 10.224.25.8 with SMTP id x8mr23218292qab.77.1380656908745; Tue, 01 Oct 2013 12:48:28 -0700 (PDT) Received: by 10.229.12.198 with HTTP; Tue, 1 Oct 2013 12:48:28 -0700 (PDT) X-Originating-IP: [173.69.165.106] In-Reply-To: <8AD139F524D0DA40BF0E96FF02522E15299267CF@shark6.netcentric.local> References: <8AD139F524D0DA40BF0E96FF02522E15299267CF@shark6.netcentric.local> Date: Tue, 1 Oct 2013 15:48:28 -0400 Message-ID: Subject: Re: Trouble with IntersectingIterator From: William Slacum To: user@accumulo.apache.org Content-Type: multipart/alternative; boundary=001a11c2dc3c9a6c8004e7b33c4b X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2dc3c9a6c8004e7b33c4b Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable That iterator is designed to be used with a sharded table format, where in the index and record each occur within the same row. See the Accumulo examples page http://accumulo.apache.org/1.4/examples/shard.html On Tue, Oct 1, 2013 at 3:35 PM, Heath Abelson w= rote: > I am attempting to get a very simple example working with the > Intersecting Iterator. I made up some dummy objects for me to do this wor= k: > **** > > ** ** > > A scan on the =93Mail=94 table looks like this:**** > > ** ** > > m1 mail:body [U&(USA)] WTF?**** > > m1 mail:receiver [U&(USA)] mgiordano**** > > m1 mail:sender [U&(USA)] habelson**** > > m1 mail:sentTime [U&(USA)] 1380571500**** > > m1 mail:subject [U&(USA)] Lunch**** > > m2 mail:body [U&(USA)] I know right?**** > > m2 mail:receiver [U&(USA)] jmarcolla**** > > m2 mail:sender [U&(USA)] habelson**** > > m2 mail:sentTime [U&(USA)] 1380571502**** > > m2 mail:subject [U&(USA)] Lunch**** > > m3 mail:body [U&(USA)] exactly!**** > > m3 mail:receiver [U&(USA)] habelson**** > > m3 mail:sender [U&(USA)] mgiordano**** > > m3 mail:sentTime [U&(USA)] 1380571504**** > > m3 mail:subject [U&(USA)] Lunch**** > > m4 mail:body [U&(USA)] Dude!**** > > m4 mail:receiver [U&(USA)] mcross**** > > m4 mail:sender [U&(USA)] habelson**** > > m4 mail:sentTime [U&(USA)] 1380571506**** > > m4 mail:subject [U&(USA)] Lunch**** > > m5 mail:body [U&(USA)] Yeah**** > > m5 mail:receiver [U&(USA)] habelson**** > > m5 mail:sender [U&(USA)] mcross**** > > m5 mail:sentTime [U&(USA)] 1380571508**** > > m5 mail:subject [U&(USA)] Lunch**** > > ** ** > > A scan on the =93MailIndex=94 table looks like this:**** > > ** ** > > receiver habelson:m3 [] habelson**** > > receiver habelson:m5 [] habelson**** > > receiver jmarcolla:m2 [] jmarcolla**** > > receiver mcross:m4 [] mcross**** > > receiver mgiordano:m1 [] mgiordano**** > > sender habelson:m1 [] habelson**** > > sender habelson:m2 [] habelson**** > > sender habelson:m4 [] habelson**** > > sender mcross:m5 [] mcross**** > > sender mgiordano:m3 [] mgiordano**** > > sentTime 1380571500:m1 [] 1380571500**** > > sentTime 1380571502:m2 [] 1380571502**** > > sentTime 1380571504:m3 [] 1380571504**** > > sentTime 1380571506:m4 [] 1380571506**** > > sentTime 1380571508:m5 [] 1380571508**** > > subject Lunch:m1 [] Lunch**** > > subject Lunch:m2 [] Lunch**** > > subject Lunch:m3 [] Lunch**** > > subject Lunch:m4 [] Lunch**** > > subject Lunch:m5 [] Lunch**** > > ** ** > > If I use an IntersectingIterator with a BatchScanner and pass it the term= s > =93habelson=94,=94mgiordano=94 (or seemingly any pair of terms) I get zer= o results. > If, instead, I use the same value as both terms (i.e. > =93habelson=94,=94habelson=94) I properly get back the records that conta= in that > value.**** > > ** ** > > My code is almost identical to the userguide example, and I am using > Accumulo 1.4.3**** > > ** ** > > Any help would be appreciated**** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > Heath Abelson**** > > NetCentric Technology, Inc.**** > > 3349 Route 138, Building A**** > > Wall, NJ 07719**** > > Phone: 732-544-0888 x159**** > > Email: habelson@netcentricinc.com **** > > ** ** > --001a11c2dc3c9a6c8004e7b33c4b Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
That iterator is designed to be used with a sharded table = format, where in the index and record each occur within the same row. See t= he Accumulo examples page http://accumulo.apache.org/1.4/examples/shard.html


On Tue,= Oct 1, 2013 at 3:35 PM, Heath Abelson <HAbelson@netcentricinc.co= m> wrote:

I am attempting to get a very simple example working= with the Intersecting Iterator. I made up some dummy objects for me to do = this work:

=A0

A scan on the =93Mail=94 table looks like this:

=A0

m1 mail:body [U&(USA)]=A0=A0=A0 WTF?

m1 mail:receiver [U&(USA)]=A0=A0=A0 mgiordano=

m1 mail:sender [U&(USA)]=A0=A0=A0 habelson

m1 mail:sentTime [U&(USA)]=A0=A0=A0 1380571500

m1 mail:subject [U&(USA)]=A0=A0=A0 Lunch<= u>

m2 mail:body [U&(USA)]=A0=A0=A0 I know right?=

m2 mail:receiver [U&(USA)]=A0=A0=A0 jmarcolla=

m2 mail:sender [U&(USA)]=A0=A0=A0 habelson

m2 mail:sentTime [U&(USA)]=A0=A0=A0 1380571502

m2 mail:subject [U&(USA)]=A0=A0=A0 Lunch<= u>

m3 mail:body [U&(USA)]=A0=A0=A0 exactly!<= u>

m3 mail:receiver [U&(USA)]=A0=A0=A0 habelson<= /u>

m3 mail:sender [U&(USA)]=A0=A0=A0 mgiordano

m3 mail:sentTime [U&(USA)]=A0=A0=A0 1380571504

m3 mail:subject [U&(USA)]=A0=A0=A0 Lunch<= u>

m4 mail:body [U&(USA)]=A0=A0=A0 Dude!<= /u>

m4 mail:receiver [U&(USA)]=A0=A0=A0 mcross

m4 mail:sender [U&(USA)]=A0=A0=A0 habelson

m4 mail:sentTime [U&(USA)]=A0=A0=A0 1380571506

m4 mail:subject [U&(USA)]=A0=A0=A0 Lunch<= u>

m5 mail:body [U&(USA)]=A0=A0=A0 Yeah

m5 mail:receiver [U&(USA)]=A0=A0=A0 habelson<= /u>

m5 mail:sender [U&(USA)]=A0=A0=A0 mcross<= u>

m5 mail:sentTime [U&(USA)]=A0=A0=A0 1380571508

m5 mail:subject [U&(USA)]=A0=A0=A0 Lunch<= u>

=A0

A scan on the =93MailIndex=94 table looks like this:=

=A0

receiver habelson:m3 []=A0=A0=A0 habelson<= /u>

receiver habelson:m5 []=A0=A0=A0 habelson<= /u>

receiver jmarcolla:m2 []=A0=A0=A0 jmarcolla

receiver mcross:m4 []=A0=A0=A0 mcross<= /p>

receiver mgiordano:m1 []=A0=A0=A0 mgiordano

sender habelson:m1 []=A0=A0=A0 habelson

sender habelson:m2 []=A0=A0=A0 habelson

sender habelson:m4 []=A0=A0=A0 habelson

sender mcross:m5 []=A0=A0=A0 mcross

sender mgiordano:m3 []=A0=A0=A0 mgiordano<= /u>

sentTime 1380571500:m1 []=A0=A0=A0 1380571500=

sentTime 1380571502:m2 []=A0=A0=A0 1380571502=

sentTime 1380571504:m3 []=A0=A0=A0 1380571504=

sentTime 1380571506:m4 []=A0=A0=A0 1380571506=

sentTime 1380571508:m5 []=A0=A0=A0 1380571508=

subject Lunch:m1 []=A0=A0=A0 Lunch

subject Lunch:m2 []=A0=A0=A0 Lunch

subject Lunch:m3 []=A0=A0=A0 Lunch

subject Lunch:m4 []=A0=A0=A0 Lunch

subject Lunch:m5 []=A0=A0=A0 Lunch

=A0

If I use an IntersectingIterator with a BatchScanner= and pass it the terms =93habelson=94,=94mgiordano=94 (or seemingly any pai= r of terms) I get zero results. If, instead, I use the same value as both t= erms (i.e. =93habelson=94,=94habelson=94) I properly get back the records that contain that value.

=A0

My code is almost identical to the userguide example= , and I am using Accumulo 1.4.3

=A0

Any help would be appreciated

=A0

=A0

=A0

=A0

=A0

Heath Abelson

NetCentric Technology, Inc.

3349 Route 138, Building A

Wall, NJ=A0 07719

Phone: 732-544-0888 x159

Email:=A0 habelson@netcentricinc.com=A0

=A0


--001a11c2dc3c9a6c8004e7b33c4b--