About ranjith7rh

ranjith7rh · ‎05-10-2017

Got the solution: echo "scan 'table1' ,{ FILTER => \"(SingleColumnValueFilter('Details','col2',!=, 'binary:XYZ')) AND (QualifierFilter (=, 'binary:col1'))\"}" |hbase shell |grep ABC |awk '{print $1}'

ranjith7rh · ‎05-10-2017

I have a hbase table table1. Now i need to write a shell command to pick the row value by keeping filter on two columns like (c1='ABC' and c2<>'xyz'). Please help here. Here is the command i used: echo "scan 'table1', {COLUMNS => ['Details'],FILTER => \"(SingleColumnValueFilter('Details','ABC',=,'binary:col1',true,true)) AND (SingleColumnValueFilter('Details','XYZ',!=,'binary:col2',true,true))\"}"|hbase shell

Online	Offline
Last Visited	‎05-10-2017 11:43 AM

Member Since	‎05-10-2017 07:51 AM
Last Visited	‎05-10-2017 11:43 AM
Posts	2

Cloudera Community

Re: Hbase shell command to keep filter on multiple...

Hbase shell command to keep filter on multiple col...