Burst
Burst

Reputation: 1844

HBase: How to skip row with specific column in hbase?

is there any filter can be used to skip rows that contains specific column ? eg

      name price invalid
r1       a    10
r2       b     5       1
r3       c    20

i just want row without invalid column (r1, r3)

i tried SingleColumnValueFilter but it always skip row when the column is missing

Upvotes: 0

Views: 429

Answers (1)

Adit
Adit

Reputation: 118

You can try this.. Use the same SingleColumnValue filter and and compare with a value that can never be set to that column, like if you are planning to store integer have a comparision with charecter!

SingleColumnValueFilter('ColumnFamily','Qualifier',!=,'binary:x',false,true)

Let me know if this works for you!

Upvotes: 2

Related Questions