HBase基本操作

--任一列值='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.youkuaiyun.com/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'

转载于:https://www.cnblogs.com/csyusu/p/11132879.html