Re: Type of Scan to be used for real time analysis

2015-12-18 Thread anil gupta
Hi RajeshKumar, IMO, type of scan is not decided on the basis of response time. Its decided on the basis of your query logic and data model. Also, Response time cannot be directly correlated to any filter or scan. Response time is more about how much data needs to read, cpu, network IO, etc to

Re: Type of Scan to be used for real time analysis

2015-12-18 Thread Rajeshkumar J
Hi Anil, I have about 10 million rows with each rows having more than 10k columns. I need to query this table based on row key and which will be the apt query process for this Thanks On Fri, Dec 18, 2015 at 5:43 PM, anil gupta wrote: > Hi RajeshKumar, > > IMO, type

RE: Type of Scan to be used for real time analysis

2015-12-18 Thread beeshma r
Hi Rajesh, Why you can't index all rows using Solr. Check this out Hbase indexer(NG data) Regards Beeshma Ramakrishnan -Original Message- From: Rajeshkumar J Sent: 18-12-2015 PM 05:59 To: user@hbase.apache.org Subject: Re: Type of Scan to be used for real time analysis Hi Anil, I

Re: Type of Scan to be used for real time analysis

2015-12-18 Thread anil gupta
If you know exact rowkey of row that you need to fetch then you just need to use GET. If you know just the prefix of rowkey, then you can use range scans in HBase. Does the above 2 scenario's cover your use case? On Fri, Dec 18, 2015 at 4:29 AM, Rajeshkumar J wrote:

Re: Type of Scan to be used for real time analysis

2015-12-18 Thread Rajeshkumar J
Hi, On Fri, Dec 18, 2015 at 7:30 PM, anil gupta wrote: > If you know exact rowkey of row that you need to fetch then you just need > to use GET. If you know just the prefix of rowkey, then you can use range > scans in HBase. Does the above 2 scenario's cover your use

Re: Type of Scan to be used for real time analysis

2015-12-18 Thread Rajeshkumar J
Hi, yes I am currently using range scan but it takes more than 10 seconds based on the number of columns. But I want to bring this down to a second. Is there any other which I can do to achieve this Thanks On Fri, Dec 18, 2015 at 7:30 PM, anil gupta wrote: > If you