Reputation: 1844
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
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