Re: HBase table - distinct values

2012-10-10 Thread Jean-Marc Spaggiari
Hi Raviprasad, What you can do, if deptno is you key, or the first part of you key, is to scan for the first entry, then increment it by one and scan with this value. Let's take an example. Key format is DEPTNO + ID (XXYY) You table content is: 0101 0102 0106 0207 0212 0243 0419 0441 If you sca

RE: HBase table - distinct values

2012-10-10 Thread Anoop Sam John
Hi Your schema? 'deptno' is a cf:qualifier? -Anoop- From: raviprasa...@polarisft.com [raviprasa...@polarisft.com] Sent: Wednesday, October 10, 2012 4:29 PM To: user@hbase.apache.org; hbase-u...@hadoop.apache.org Subject: HBase table - distinct values Hi

Re: HBase table - distinct values

2012-10-10 Thread Doug Meil
Typically this is something done as a MapReduce job. http://hbase.apache.org/book.html#mapreduce.example 7.2.4. HBase MapReduce Summary to HBase Example However, if this is an operation to be performed frequently by an application then doing frequent MapReduce jobs for summaries probably isn'

RE: HBase table - distinct values

2012-10-10 Thread raviprasad . t
From: Anoop Sam John Date: 10/10/2012 06:18PM Subject: RE: HBase table - distinct values Hi Your schema? 'deptno' is a cf:qualifier? -Anoop- From: raviprasa...@polarisft.com [raviprasa...@polarisft.com] Sent: Wednesday, October 10, 2012 4:29 PM To

RE: HBase table - distinct values

2012-10-10 Thread Anoop Sam John
e you asked about. :) -Anoop- From: raviprasa...@polarisft.com [raviprasa...@polarisft.com] Sent: Wednesday, October 10, 2012 7:51 PM To: user@hbase.apache.org Cc: hbase-u...@hadoop.apache.org; user@hbase.apache.org Subject: RE: HBase table - distinct value

RE: HBase table - distinct values

2012-10-10 Thread Ramkrishna.S.Vasudevan
ei.com] > Sent: Thursday, October 11, 2012 9:32 AM > To: user@hbase.apache.org > Cc: hbase-u...@hadoop.apache.org > Subject: RE: HBase table - distinct values > > Hi Ravi > If dept_no is a CF:qualifier, to know all the dept numbers > (distinct or not) you need a full

Re: HBase table - distinct values

2012-10-11 Thread yutoo yanio
> Sent: Thursday, October 11, 2012 9:32 AM > > To: user@hbase.apache.org > > Cc: hbase-u...@hadoop.apache.org > > Subject: RE: HBase table - distinct values > > > > Hi Ravi > > If dept_no is a CF:qualifier, to know all the dept numbers > > (distinc

RE: HBase table - distinct values

2012-10-11 Thread raviprasad . t
. Thanks Regards Raviprasad. T Mobile :- 91- 9894769541 -Anoop Sam John wrote: - To: "user@hbase.apache.org" From: Anoop Sam John Date: 10/11/2012 09:33AM Cc: "hbase-u...@hadoop.apache.org" Subject: RE: HBase table - distinct values Hi Ravi If dept_no i

RE: HBase table - distinct values

2012-10-11 Thread Nitin Pawar
nct deptno . > > Thanks > Regards > Raviprasad. T > Mobile :- 91- 9894769541 > > > -Anoop Sam John wrote: - > To: "user@hbase.apache.org" > From: Anoop Sam John > Date: 10/11/2012 09:33AM > Cc: "hbase-u...@hadoop.apache.org" > Subject: RE