Re: Map Reduce with multiple scans

2013-02-27 Thread Paul van Hoven
> Nick > > [0]: > http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/PrefixFilter.html > [1]: > http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/FilterList.html > > On Tue, Feb 26, 2013 at 5:41 AM, Paul van Hoven < > paul.van.ho...@googl

Map Reduce with multiple scans

2013-02-26 Thread Paul van Hoven
My rowkeys look something like this: md5( date ) + md5( ip address ) So an example would be md5( "2013-02-08") + md5( "192.168.187.2") For one particular date I got several rows. Now I'd like to query different dates, for example "2013-01-01" and "2013-02-01" and some other. Additionally I'd lik

Re: Question about filtering data

2013-02-20 Thread Paul van Hoven
gle column value, but does not emit the > > * tested column. This will enable a performance boost over > > * {@link SingleColumnValueFilter}, if the tested column value is not > actually > > * needed as input (besides for the filtering itself). > > On Wed, Feb 20, 2013 at

Question about filtering data

2013-02-20 Thread Paul van Hoven
Suppose I had the following data in a table: hbase(main):007:0> scan 'ToyDataTable' ROWCOLUMN+CELL \x01\x07\x0C\xF8C\xF2\xCAE\xE3\xD4\xEC|\x02\x column=CF:creativeId, timestamp=1361383021175, value=100 C5%Q\x04~\xF9\x1C#\xA4\xCEUG\xA8\x84:\xAD\xFB n\

Re: Scanning a row for certain md5hash does not work

2013-02-19 Thread Paul van Hoven
Sorry, I had a mistake in my rowkey generation. Thanks for reading! 2013/2/19 Paul van Hoven : > I'm currently reading a book about hbase (hbase in action by manning). > In this book it is explained how to perform a scan if the rowkey is > made out of a md5 hash (page 45 in the bo

Scanning a row for certain md5hash does not work

2013-02-19 Thread Paul van Hoven
I'm currently reading a book about hbase (hbase in action by manning). In this book it is explained how to perform a scan if the rowkey is made out of a md5 hash (page 45 in the book). My rowkey design (and table filling method) looks like this: SimpleDateFormat dateFormatter = new SimpleDateForma

Re: Rowkey design question

2013-02-19 Thread Paul van Hoven
So it's better to hash the keys in order to make > them go to all the machines equally. HTH > > BTW, did that range query work?? > > Warm Regards, > Tariq > https://mtariq.jux.com/ > cloudfront.blogspot.com > > > On Tue, Feb 19, 2013 at 9:54 PM, Paul van Hov

Re: Rowkey design question

2013-02-19 Thread Paul van Hoven
ing. > Just add a hash to your rowkeys so that data is distributed evenly on all > the RSs. > > Warm Regards, > Tariq > https://mtariq.jux.com/ > cloudfront.blogspot.com > > > On Tue, Feb 19, 2013 at 9:41 PM, Paul van Hoven < > paul.van.ho...@googlemail.com> wrot

Rowkey design question

2013-02-19 Thread Paul van Hoven
Hi, I'm currently playing with hbase. The design of the rowkey seems to be critical. The rowkey for a certain database table of mine is: timestamp+ipaddress It looks something like this when performing a scan on the table in the shell: hbase(main):012:0> scan 'ToyDataTable' ROW

Re: Table deleted after restart of computer

2013-02-19 Thread Paul van Hoven
tandalone mode ? > > Thanks > > On Tue, Feb 19, 2013 at 5:23 AM, Paul van Hoven < > paul.van.ho...@googlemail.com> wrote: > >> I just started with hbase. Therefore I created a table and filled this >> table with some data. But after restarting my computer all the data >&

Table deleted after restart of computer

2013-02-19 Thread Paul van Hoven
I just started with hbase. Therefore I created a table and filled this table with some data. But after restarting my computer all the data has gone. This even happens when stopping hbase with stop-hbase.sh. How can this happen?

Re: Cannot connect to local hbase database

2013-02-12 Thread Paul van Hoven
ache.org/apidocs/org/apache/hadoop/hbase/client/HTablePool.html#HTablePool() > > Maybe you should try it like this: > > Configuration conf = HBaseConfiguration.create(); > HTablePool pool = new HTablePool(conf, 10); > > Cheers > > > > > On Tue, Feb 12, 2013 at 11:50

Cannot connect to local hbase database

2013-02-12 Thread Paul van Hoven
I'm trying to connect to my hbase database via java program but I cannot access my database because I get an error message. I checked that the database is actually running correctly. Java program: public class HBaseDemo { public static void main(String[] args ) { t