HBase scan

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 =&gt; "ValueFilter(&gt;=, 'binary:Search key1') AND ValueFilter(&lt;, '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結尾

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.

Categories