Re: How to increase scan speed in Hbase

2015-11-25 Thread Rajeshkumar J
Hi Ted Yu, No I have not major compacted the table. Can you tell me how to do this or suggest me a link. Thanks, RajeshKumar J On Wed, Nov 25, 2015 at 9:26 PM, Ted Yu wrote: > After loading the data, have you major compacted the table ? > > You can include STARTROW, STOPROW and TIMERANGE f

[ANNOUNCE] CFP open for ApacheCon North America 2016

2015-11-25 Thread Rich Bowen
Community growth starts by talking with those interested in your project. ApacheCon North America is coming, are you? We are delighted to announce that the Call For Presentations (CFP) is now open for ApacheCon North America. You can submit your proposed sessions at http://events.linuxfoundation.o

Re: Hbase Aggregation

2015-11-25 Thread Ted Yu
Please take a look at: http://hbase.apache.org/book.html#_endpoint_example The Endpoint Coprocessor runs server side. So it should be very efficient. Cheers On Wed, Nov 25, 2015 at 6:03 AM, Arul wrote: > Hi, > > I am new to Hbase and doing an POC. We have a detail table in which rows > are > c

Re: How to increase scan speed in Hbase

2015-11-25 Thread Ted Yu
After loading the data, have you major compacted the table ? You can include STARTROW, STOPROW and TIMERANGE for your scan to narrow the scope. FYI On Wed, Nov 25, 2015 at 2:36 AM, Rajeshkumar J wrote: > Hi, > > > I am new to Apache Hbase and I am using hbase-0.98.13 and I have created a > tab

Hbase Aggregation

2015-11-25 Thread Arul
Hi, I am new to Hbase and doing an POC. We have a detail table in which rows are continuously added (1000's of rows added every few minute). We want to build an summary table from UI read and display it to user. The summary table would be aggregate of detail table. I was thinking to use Map Reduce

Re: timestamp/ttl of a cell

2015-11-25 Thread Jean-Marc Spaggiari
Very good question. From the shell, I'm not sure this is doable. From the java API, you will have to use Mutation.setTTL http://hbase.apache.org/book.html#ttl JMS 2015-11-25 8:40 GMT-05:00 Shushant Arora : > Thanks! > Whats the syntax to set it in shell and java ? > > On Wed, Nov 25, 2015 at 6:

Re: timestamp/ttl of a cell

2015-11-25 Thread Shushant Arora
Thanks! Whats the syntax to set it in shell and java ? On Wed, Nov 25, 2015 at 6:05 PM, Jean-Marc Spaggiari < jean-m...@spaggiari.org> wrote: > This? HBASE-10560 > > 2015-11-25 6:45 GMT-05:00 Shushant Arora : > > > Hi > > > > Can TTL of rows be set/updated instead of complete column family? > >

Re: timestamp/ttl of a cell

2015-11-25 Thread Jean-Marc Spaggiari
This? HBASE-10560 2015-11-25 6:45 GMT-05:00 Shushant Arora : > Hi > > Can TTL of rows be set/updated instead of complete column family? > or > Can timestamp version of a cell be decreased ? Aim is to delete some rows > whose timestamp > is set to old values so that it matches TTL of column famil

timestamp/ttl of a cell

2015-11-25 Thread Shushant Arora
Hi Can TTL of rows be set/updated instead of complete column family? or Can timestamp version of a cell be decreased ? Aim is to delete some rows whose timestamp is set to old values so that it matches TTL of column family if tTL of row/cell cannot be specified.

How to increase scan speed in Hbase

2015-11-25 Thread Rajeshkumar J
Hi, I am new to Apache Hbase and I am using hbase-0.98.13 and I have created a table sample with column family sample_family. And I have loaded the output from pig script to hbase table. when I try to scan the table based on one of the column in column family it takes more than 2 minutes. Here i