Using multiple column filters with HappyBase

Question

I'm using HappyBase as Python Thrift client to connect to HBase.

I'm scanning the table and need to use filters on multiple columns. How this can be achieved in HappyBase? Java gives an option for this using Filterlist.

Answer 1

As specified on the github page, Happybase is using Thrift. You should use the same syntax as thrift.

On your scan function, you can specify a filter string :

SingleColumnValueFilter(‘’, ‘, , ‘’)

For example, if you need to scan all rows with the column blah:blouh = batman :

hbase_table.scan(filter="SingleColumnValueFilter ('blah','blouh',=,'regexstring:^batman$')")

You can use AND or OR to put several filters, just remember to surround everything with parenthesis.

Thrift Documentation : http://hbase.apache.org/book/thrift.html

Be careful when creating filters on string, you will have to use a specific comparator (like regexstring in my example).