--任一列值='TEST' ，ValueFilter(=,'binary:TEST')

scan 'FAB_MES:TO_BSLOTQUEUETIME',FILTER=>"ValueFilter(=,'binary:TEST')"

--任一列值包含'TEST'，不区分大小写ValueFilter(=,'substring:test')

scan 'FAB_MES:TO_BSLOTQUEUETIME',FILTER=>"ValueFilter(=,'substring:test')"

--单一列值包含

scan 'FAB_MES:TO_BSLOTQUEUETIME',{FILTER=>"SingleColumnValueFilter('CF','FACTORY',=,'test')",LIMIT=>1}

--以列名前缀ColumnPrefixFilter('F')，多个列名前缀MultipleColumnPrefixFilter('a','c')，区分大小写，AND 和OR需大写

scan 'FAB_MES:TO_BSLOTQUEUETIME',FILTER=>"ValueFilter(=,'substring:test') AND ColumnPrefixFilter('F')"

--以列范围过滤， minColumn - 列范围的最小值，如果为空，则没有下限； minColumnInclusive - 列范围是否包含minColumn；maxColumn - 列范围最大值，如果为空，则没有上限；maxColumnInclusive - 列范围是否包含maxColumn

scan 'FAB_MES:TO_BSLOTQUEUETIME',{FILTER=>"ColumnRangeFilter('F',true,'G',false)"}

--列名正则匹配以RY结尾或包含RY

scan 'FAB_MES:TO_BSLOTQUEUETIME',{FILTER=>"QualifierFilter(=,'regexstring:.RY$') OR QualifierFilter(=,'substring:PY')",LIMIT=>1}

--rowkey 以F为前缀，区分大小写，FirstKeyOnlyFilter() 取最新的版本，KeyOnlyFilter()只要key 不要value

scan 'FAB_MES:TO_BSLOTQUEUETIME',FILTER=>"ValueFilter(=,'substring:test') AND PrefixFilter('111') AND FirstKeyOnlyFilter() AND KeyOnlyFilter()"

--指定rowkey检索的范围，左闭右开

scan 'FAB_MES:TO_BSLOTQUEUETIME',{STARTROW=>'111111',STOPROW=>'333333',FILTER=>"ValueFilter(=,'substring:test')"}

--以rowkey值过滤，rowkey包含111

scan 'FAB_MES:TO_BSLOTQUEUETIME',{FILTER=>"RowFilter(=,'substring:111')"}

HBASE建表语句

https://blog.csdn.net/gingerredjade/article/details/63704636

合并小region

normalizer_enabled

查看HBASE元数据(hbase:meta)(https://www.cnblogs.com/niurougan/p/3976543.html)

scan 'hbase:meta',{FILTER=>"RowFilter(=,'substring:MDW:DWR_GLS')"}

deleteall 'MDW:DWR_LOT','111111111'