Search code examples
hbase

my rowfilter for regexstring is wrong

I want to get all rows end with 2017-04-12. Shell command is scan 'tr_log_v2', {FILTER => "RowFilter(=, 'regexstring:*2017-04-12')"}. And an error happens Incorrect filter string RowFilter(=, 'regexstring:*2017-04-12'). What is the right way to do this?

Solution

  • Try this comparator 'regexstring:2017-04-12$'

    The scan statement would be,

    scan 'tr_log_v2', {FILTER => "RowFilter(=, 'regexstring:2017-04-12$')"}