Mailing-List: contact user-help@accumulo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@accumulo.apache.org
Received-SPF: pass (athena.apache.org: domain of rkreddy@gmail.com designates
 209.85.215.50 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAGUtCHq6FQ-g_BgszH5CWreOfP_Fn0FPsczXpnAfLQrkB1AFSA@mail.gmail.com>
References: 
 <CA+jL2q33Ov64gBzwx=qEOXva2XKTektc=LO8SfQ3kZaMK7WKLA@mail.gmail.com>
	<CAGUtCHq6FQ-g_BgszH5CWreOfP_Fn0FPsczXpnAfLQrkB1AFSA@mail.gmail.com>
Date: Wed, 17 Apr 2013 22:40:18 -0400
Message-ID: 
 <CA+jL2q0N4zVkU6NqewPJgXK10GWgeer93b8VPBO1HdMZtuyKoA@mail.gmail.com>
Subject: Re: row count
From: Venkat <rkreddy@gmail.com>
To: user@accumulo.apache.org
Content-Type: multipart/alternative; boundary=089e0115ef06e7e77c04da99857b

--089e0115ef06e7e77c04da99857b
Content-Type: text/plain; charset=ISO-8859-1

I did the RowIterator and did a count of the rows ... it came out pretty
fast but definitely not the best efficient wise.  Thanks everyone.


On Wed, Apr 17, 2013 at 10:42 AM, Keith Turner <keith@deenlo.com> wrote:

> On Tue, Apr 16, 2013 at 9:33 PM, Venkat <rkreddy@gmail.com> wrote:
> > I am sure this question has been asked several times but I could not get
> to
> > the answer using usual searches - which iterator is the right one to
> count
> > the number of rows for a given value or a pattern of value ?
>
> Take a look at org.apache.accumulo.core.iterators.FirstEntryInRowIterator.
>  Does anyone know why this is not in the user iterator package?  Is
> there an issue with it?  This will bring back the first key/value for
> each row, then you could count those on the client side.   This will
> work for a range.  For a pattern, David's suggestion of the regex
> filter may be useful.   You could also look in the
> org.apache.accumulo.core.iterators.user.RowFilter.
>
> You could use FirstEntryInRowIterator and RegEx or RowFilter, but you
> would have to be careful about the order of the iterators.
>
> >
> > Venkat.
>

--089e0115ef06e7e77c04da99857b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I did the RowIterator and did a count of the rows ... it c=
ame out pretty fast but=A0definitely=A0not the best efficient wise. =A0Than=
ks everyone.</div><div class=3D"gmail_extra"><br><br><div class=3D"gmail_qu=
ote">On Wed, Apr 17, 2013 at 10:42 AM, Keith Turner <span dir=3D"ltr">&lt;<=
a href=3D"mailto:keith@deenlo.com" target=3D"_blank">keith@deenlo.com</a>&g=
t;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div class=3D"HOEnZb"><div class=3D"h5">On T=
ue, Apr 16, 2013 at 9:33 PM, Venkat &lt;<a href=3D"mailto:rkreddy@gmail.com=
">rkreddy@gmail.com</a>&gt; wrote:<br>

&gt; I am sure this question has been asked several times but I could not g=
et to<br>
&gt; the answer using usual searches - which iterator is the right one to c=
ount<br>
&gt; the number of rows for a given value or a pattern of value ?<br>
<br>
</div></div>Take a look at org.apache.accumulo.core.iterators.FirstEntryInR=
owIterator.<br>
=A0Does anyone know why this is not in the user iterator package? =A0Is<br>
there an issue with it? =A0This will bring back the first key/value for<br>
each row, then you could count those on the client side. =A0 This will<br>
work for a range. =A0For a pattern, David&#39;s suggestion of the regex<br>
filter may be useful. =A0 You could also look in the<br>
org.apache.accumulo.core.iterators.user.RowFilter.<br>
<br>
You could use FirstEntryInRowIterator and RegEx or RowFilter, but you<br>
would have to be careful about the order of the iterators.<br>
<br>
&gt;<br>
&gt; Venkat.<br>
</blockquote></div><br></div>

--089e0115ef06e7e77c04da99857b--