Multi column query on Hbase

Question

I have a customer table with customer ID as rowkey. I now have a requirement to query customer by fist name and last name. How can I scan table with both the columns in where clause using HBase Shell. I know how to do it for a single column.

Answer 1

There are some filters that can be used during hbase scan (value filter)

see more Scan HTable rows for specific column value using HBase shell