HBase scan

scan 'TableName', FILTER => "ValueFilter(=, ‘binary:Search key’)"

scan 'TableName', {FILTER => "ValueFilter(=, 'binary:Search key1') OR ValueFilter(=, 'binary:Search key2’)"}

scan 'TableName', {COLUMNS => 'cf:qualifer', FILTER => "ValueFilter(>=, 'binary:Search key1') AND ValueFilter(<, 'binary:Search key1~’)"}

scan 'TableName', FILTER => "ValueFilter(=, 'binaryprefix:+8869’)"
//符合+8869開頭的

scan 'TableName', FILTER => "ValueFilter(=, 'substring:345678')"
//部分字串符合

scan 'TableName', FILTER => "RowFilter(=, 'substring:k3S')"
//Rowkey部分字串符合

scan 'TableName', FILTER => "ValueFilter(=, 'regexstring:^.*610')"
//符合610結尾
This entry was posted in HBase. Bookmark the permalink.