• HBase操作（Shell与Java API）

    版权声明：本文为博主原创文章，未经博主允许不得转载。

     
     

    转： http://blog.csdn.net/u013980127/article/details/52443155

    下面代码在Hadoop 2.6.4 + Hbase 1.2.2 + centos 6.5 + jdk 1.8上运行通过。

    HBase操作

    一般操作

    命令说明
    status 显示集群状态. 选项：‘summary’, ‘simple’, or ‘detailed’. 默认值：‘summary’. 
    hbase> status 
    hbase> status ‘simple’ 
    hbase> status ‘summary’ 
    hbase> status ‘detailed’
    version 显示版本。
    hbase> version
    whoami 显示当前用户与组。
    hbase> whoami

    表管理

    1. alter

    修改表结构必须先disable

    Shell：

    语法：alter 't1', {NAME => 'f1'}, {NAME => 'f2', METHOD => 'delete'}
必须指定列族。示例：
表t1的列族f1，修改或增加VERSIONS为5

hbase> alter ‘t1’, NAME => ‘f1’, VERSIONS => 5

也可以同时修改多个列族：

hbase> alter ‘t1’, ‘f1’, {NAME => ‘f2’, IN_MEMORY => true}, {NAME => ‘f3’, VERSIONS => 5}

删除表t1的f1列族：

hbase> alter ‘t1’, NAME => ‘f1’, METHOD => ‘delete’
或
hbase> alter ‘t1’, ‘delete’ => ‘f1’

也可以修改table-scope属性，例如MAX_FILESIZE, READONLY,
MEMSTORE_FLUSHSIZE, DEFERRED_LOG_FLUSH等。
例如，修改region的最大大小为128MB：

hbase> alter ‘t1’, MAX_FILESIZE => ‘134217728’

也可以设置表的coprocessor属性：

hbase> alter ‘t1’,
‘coprocessor’=>’hdfs:///foo.jar|com.foo.FooRegionObserver|1001|arg1=1,arg2=2’

可以设置复数个coprocessor，这时会自动添加序列以唯一标示coprocessor。

coprocessor属性设置语法：
[coprocessor jar file location] | class name | [priority] | [arguments]

也可以设置configuration给表或列族：

hbase> alter ‘t1’, CONFIGURATION => {‘hbase.hregion.scan.loadColumnFamiliesOnDemand’ => ‘true’}
hbase> alter ‘t1’, {NAME => ‘f2’, CONFIGURATION => {‘hbase.hstore.blockingStoreFiles’ => ’10’}}

也可以移除table-scope属性：

hbase> alter ‘t1’, METHOD => ‘table_att_unset’, NAME => ‘MAX_FILESIZE’

hbase> alter ‘t1’, METHOD => ‘table_att_unset’, NAME => ‘coprocessor$1’

可以通过一个命令进行多项修改：

hbase> alter ‘t1’, { NAME => ‘f1’, VERSIONS => 3 },
{ MAX_FILESIZE => ‘134217728’ }, { METHOD => ‘delete’, NAME => ‘f2’ },
OWNER => ‘johndoe’, METADATA => { ‘mykey’ => ‘myvalue’ }

    Java实现：

    /**
 * 修改表结构,增加列族
 *
 * @param tableName 表名
 * @param family    列族
 *
 * @throws IOException
 */
public static void putFamily(String tableName, String family) throws IOException {
    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Admin admin = connection.getAdmin()
    ) {
        TableName tblName = TableName.valueOf(tableName);
        if (admin.tableExists(tblName)) {
            admin.disableTable(tblName);
            HColumnDescriptor cf = new HColumnDescriptor(family);
            admin.addColumn(TableName.valueOf(tableName), cf);
            admin.enableTable(tblName);
        } else {
            log.warn(tableName + " not exist.");
        }
    }
}

# 调用示例
putFamily("blog", "note");

    　　

    2. create

    创建表。

    Shell：

    语法：
create 'table', { NAME => 'family', VERSIONS => VERSIONS } [, { NAME => 'family', VERSIONS => VERSIONS }]

示例：

hbase> create ‘t1’, {NAME => ‘f1’, VERSIONS => 5}
hbase> create ‘t1’, {NAME => ‘f1’}, {NAME => ‘f2’}, {NAME => ‘f3’}
hbase> # The above in shorthand would be the following:
hbase> create ‘t1’, ‘f1’, ‘f2’, ‘f3’
hbase> create ‘t1’, {NAME => ‘f1’, VERSIONS => 1, TTL => 2592000, BLOCKCACHE => true}
hbase> create ‘t1’, {NAME => ‘f1’, CONFIGURATION => {‘hbase.hstore.blockingStoreFiles’ => ’10’}}

    Java示例：

    /**
 * 创建表
 *
 * @param tableName   表名
 * @param familyNames 列族
 *
 * @throws IOException
 */
public static void createTable(String tableName, String[] familyNames) throws IOException {

    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Admin admin = connection.getAdmin()
    ) {
        TableName table = TableName.valueOf(tableName);
        if (admin.tableExists(table)) {
            log.info(tableName + " already exists");
        } else {
            HTableDescriptor hTableDescriptor = new HTableDescriptor(table);
            for (String family : familyNames) {
                hTableDescriptor.addFamily(new HColumnDescriptor(family));
            }
            admin.createTable(hTableDescriptor);
        }
    }
}

# 调用例
createTable("blog", new String[]{"author", "contents"});

    3. describe

    查询表结构

    hbase> describe ‘t1’

    4. disable

    无效化指定表

    hbase> disable ‘t1’

    5. disable_all

    无效化（正则）匹配的表

    hbase> disable_all ‘t.*’

    6. is_disabled

    验证指定的表是否是无效的

    hbase> is_disabled ‘t1’

    1

    7. drop

    删除表。表必须是无效的。

    Shell：

    hbase> drop ‘t1’
    • 1
    • 1

    Java实现：

    /**
 * 删除表
 *
 * @param tableName 表名
 *
 * @throws IOException
 */
public static void dropTable(String tableName) throws IOException {

    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Admin admin = connection.getAdmin()
    ) {

        TableName table = TableName.valueOf(tableName);
        if (admin.tableExists(table)) {
            admin.disableTable(table);
            admin.deleteTable(table);
        }
    }
}

#调用例
dropTable("blog");

    8. drop_all

    删除所有正则匹配的表。

    hbase> drop_all ‘t.*’
    • 1
    • 1

    9. enable

    使指定表有效化。

    hbase> enable ‘t1’
    • 1
    • 1

    10. enable_all

    使正则匹配的所有表有效。

    hbase> enable_all ‘t.*’
    • 1
    • 1

    11. is_enabled

    验证指定表是否有效

    hbase> is_enabled ‘t1’
    • 1
    • 1

    12. exists

    指定表是否存在。

    hbase> exists ‘t1’
    • 1
    • 1

    13. list

    列出HBase中所有表，可以通过正则过滤。

    hbase> list
hbase> list ‘abc.*’
    • 1
    • 2
    • 1
    • 2

    14. show_filters

    显示所有过滤器。

    hbase> show_filters

hbase(main):066:0> show_filters
DependentColumnFilter                                                           
KeyOnlyFilter                                                                   
ColumnCountGetFilter                                                            
SingleColumnValueFilter                                                         
PrefixFilter                                                                    
SingleColumnValueExcludeFilter                                                  
FirstKeyOnlyFilter                                                              
ColumnRangeFilter                                                               
TimestampsFilter                                                                
FamilyFilter                                                                    
QualifierFilter                                                                 
ColumnPrefixFilter                                                              
RowFilter                                                                       
MultipleColumnPrefixFilter                                                      
InclusiveStopFilter                                                             
PageFilter                                                                      
ValueFilter                                                                     
ColumnPaginationFilter

    15. alter_status

    获取alter执行的状态。 
    语法：alter_status ‘tableName’

    hbase> alter_status ‘t1’
    • 1
    • 1

    16. alter_async

    异步执行alter，通过alter_status获取执行状态。

    数据操作

    1. count

    统计表的行数。

    Shell：

    该操作执行的时间可能会比较长 (运行mapreduce执行统计 '$HADOOP_HOME/bin/hadoop jar hbase.jar rowcount'). 
默认每1000行（可以指定步数）显示当前总行数。Scan
caching默认开启，默认大小为10，也可以设置：

hbase> count ‘t1’
hbase> count ‘t1’, INTERVAL => 100000
hbase> count ‘t1’, CACHE => 1000
hbase> count ‘t1’, INTERVAL => 10, CACHE => 1000

也可以通过表的引用执行：

hbase> t.count
hbase> t.count INTERVAL => 100000
hbase> t.count CACHE => 1000
hbase> t.count INTERVAL => 10, CACHE => 1000

    Java实现：

    /**
 * 统计行数
 *
 * @param tableName 表名
 *
 * @return 行数
 *
 * @throws IOException
 */
public static long count(String tableName) throws IOException {

    final long[] rowCount = {0};

    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Table table = connection.getTable(TableName.valueOf(tableName))
    ) {
        Scan scan = new Scan();
        scan.setFilter(new FirstKeyOnlyFilter());
        ResultScanner resultScanner = table.getScanner(scan);
        resultScanner.forEach(result -> {
            rowCount[0] += result.size();
        });
    }
    System.out.println("行数: " + rowCount[0]);
    return rowCount[0];
}

#调用示例
count("blog");

    2. delete

    删除指定数据。

    Shell：

    语法：delete 'table', 'rowkey',  'family:column' [, 'timestamp']
删除t1表的r1行、c1列并且时间戳为ts1的数据：

hbase> delete ‘t1’, ‘r1’, ‘c1’, ts1

也可以通过表引用调用该命令：

hbase> t.delete ‘r1’, ‘c1’, ts1

    Java实现：

    /**
 * 删除指定数据
 * <p>
 * columns为空, 删除指定列族的全部数据;
 * family为空时, 删除指定行键的全部数据;
 * </p>
 *
 * @param tableName 表名
 * @param rowKey    行键
 * @param family    列族
 * @param columns   列集合
 *
 * @throws IOException
 */
public static void deleteData(String tableName, String rowKey, String family, String[] columns)
        throws IOException {
    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Table table = connection.getTable(TableName.valueOf(tableName))
    ) {
        Delete delete = new Delete(Bytes.toBytes(rowKey));

        if (null != family && !"".equals(family)) {
            if (null != columns && columns.length > 0) { // 删除指定列
                for (String column : columns) {
                    delete.addColumn(Bytes.toBytes(family), Bytes.toBytes(column));
                }
            } else { // 删除指定列族
                delete.addFamily(Bytes.toBytes(family));
            }
        } else { // 删除指定行
            // empty, nothing to do
        }
        table.delete(delete);
    }
}

# 调用示例
deleteData("blog", "rk12", "author", new String[] { "name", "school" });
deleteData("blog", "rk11", "author", new String[] { "name" });
deleteData("blog", "rk10", "author", null);
deleteData("blog", "rk9", null, null);

    3. deleteall

    删除行。

    语法：deleteall 'tableName', 'rowkey' [, 'column', 'timestamp']

hbase> deleteall ‘t1’, ‘r1’
hbase> deleteall ‘t1’, ‘r1’, ‘c1’
hbase> deleteall ‘t1’, ‘r1’, ‘c1’, ts1

也可以通过表引用调用该命令：

hbase> t.deleteall ‘r1’
hbase> t.deleteall ‘r1’, ‘c1’
hbase> t.deleteall ‘r1’, ‘c1’, ts1

    4. get

    获取某行数据。

    Shell：

    语法：
get 'tableName', 'rowkey',[,....]
选项包括：列集合、时间戳、时间范围或版本
示例：

hbase> get ‘t1’, ‘r1’
hbase> get ‘t1’, ‘r1’, {TIMERANGE => [ts1, ts2]}
hbase> get 'blog', 'rk1', 'author:name'
hbase>get 'blog', 'rk1', { COLUMN => 'author:name' }
hbase> get ‘t1’, ‘r1’, {COLUMN => ‘c1’, TIMESTAMP => ts1}
hbase> get ‘t1’, ‘r1’, {COLUMN => ‘c1’, TIMERANGE => [ts1, ts2], VERSIONS => 4}
hbase> get ‘t1’, ‘r1’, {COLUMN => ‘c1’, TIMESTAMP => ts1, VERSIONS => 4}
hbase> get ‘t1’, ‘r1’, {FILTER => “ValueFilter(=, ‘binary:abc’)”}
hbase> get ‘t1’, ‘r1’, ‘c1’
hbase> get ‘t1’, ‘r1’, ‘c1’, ‘c2’
hbase> get ‘t1’, ‘r1’, [‘c1’, ‘c2’]

也可以在列上指定FORMATTER，默认toStringBinary。
可以使用org.apache.hadoop.hbase.util.Bytes中预定义的方法 (例如：toInt, toString) ；
也可以自定义方法：'c(MyFormatterClass).format'。
例如 cf:qualifier1 and cf:qualifier2：

hbase> get ‘t1’, ‘r1’ {COLUMN => [‘cf:qualifier1:toInt’,
‘cf:qualifier2:c(org.apache.hadoop.hbase.util.Bytes).toInt’] }

注：只能在列上指定FORMATTER，不能针对列族的所有列。

表的引用（通过get_table or
create_table获得引用）也可以使用get命令，例如
t是表t1的引用（t = get_table 't1'），则：

hbase> t.get ‘r1’
hbase> t.get ‘r1’, {TIMERANGE => [ts1, ts2]}
hbase> t.get ‘r1’, {COLUMN => ‘c1’}
hbase> t.get ‘r1’, {COLUMN => [‘c1’, ‘c2’, ‘c3’]}
hbase> t.get ‘r1’, {COLUMN => ‘c1’, TIMESTAMP => ts1}
hbase> t.get ‘r1’, {COLUMN => ‘c1’, TIMERANGE => [ts1, ts2], VERSIONS => 4}
hbase> t.get ‘r1’, {COLUMN => ‘c1’, TIMESTAMP => ts1, VERSIONS => 4}
hbase> t.get ‘r1’, {FILTER => “ValueFilter(=, ‘binary:abc’)”}
hbase> t.get ‘r1’, ‘c1’
hbase> t.get ‘r1’, ‘c1’, ‘c2’
hbase> t.get ‘r1’, [‘c1’, ‘c2’]

    Java实现：

    /**
 * 获取指定数据
 * <p>
 * column为空, 检索指定列族的全部数据;
 * family为空时, 检索指定行键的全部数据;
 * </p>
 *
 * @param tableName 表名
 * @param rowKey    行键
 * @param family    列族
 * @param columns   列名集合
 *
 * @throws IOException
 */
public static void getData(String tableName, String rowKey, String family, String[] columns)
        throws IOException {

    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Table table = connection.getTable(TableName.valueOf(tableName))
    ) {
        Get get = new Get(Bytes.toBytes(rowKey));
        Result result = table.get(get);
        if (null != family && !"".equals(family)) {
            if (null != columns && columns.length > 0) { // 表里指定列族的列值
                for (String column : columns) {
                    byte[] rb = result.getValue(Bytes.toBytes(family), Bytes.toBytes(column));
                    System.out.println(Bytes.toString(rb));
                }
            } else { // 指定列族的所有值
                Map<byte[], byte[]> columnMap = result.getFamilyMap(Bytes.toBytes(family));
                for (Map.Entry<byte[], byte[]> entry : columnMap.entrySet()) {
                    System.out.println(Bytes.toString(entry.getKey())
                            + " "
                            + Bytes.toString(entry.getValue()));
                }
            }
        } else { // 指定行键的所有值
            Cell[] cells = result.rawCells();
            for (Cell cell : cells) {
                System.out.println("family => " + Bytes.toString(cell.getFamilyArray(), cell.getFamilyOffset(), cell.getFamilyLength()) + "
"
                        + "qualifier => " + Bytes.toString(cell.getQualifierArray(), cell.getQualifierOffset(), cell.getQualifierLength()) + "
"
                        + "value => " + Bytes.toString(cell.getValueArray(), cell.getValueOffset(), cell.getValueLength()));
            }
        }

    }
}

# 调用示例
getData("blog", "rk1", null, null);
getData("blog", "rk1", "author", null);
getData("blog", "rk1", "author", new String[] { "name", "school" });

    5. get_counter

    获取计数器的值。

    语法：get_counter 'tableName', 'row', 'column'
示例：

hbase> get_counter ‘t1’, ‘r1’, ‘c1’

同样，也可以在表引用上使用：

hbase> t.get_counter ‘r1’, ‘c1’

    6. incr

    计数器

    Shell：

    语法：incr 'tableName', 'row', 'column', value
例如：表t1的r1行c1列增加1（可省略），或10：

hbase> incr ‘t1’, ‘r1’, ‘c1’
hbase> incr ‘t1’, ‘r1’, ‘c1’, 1
hbase> incr ‘t1’, ‘r1’, ‘c1’, 10

同样，也可以在表引用上使用

hbase> t.incr ‘r1’, ‘c1’
hbase> t.incr ‘r1’, ‘c1’, 1
hbase> t.incr ‘r1’, ‘c1’, 10

    Java实现：

    /**
 * 计数器自增
 *
 * @param tableName 表名
 * @param rowKey    行键
 * @param family    列族
 * @param column    列
 * @param value     增量
 *
 * @throws IOException
 */
public static void incr(String tableName, String rowKey, String family, String column,
                        long value) throws IOException {
    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Table table = connection.getTable(TableName.valueOf(tableName))
    ) {
        long count = table.incrementColumnValue(Bytes.toBytes(rowKey), Bytes.toBytes(family),
                Bytes.toBytes(column), value);
        System.out.println("增量后的值: " + count);
    }
}

#调用示例
incr("scores", "lisi", "courses", "eng", 2);

    7. put

    插入数据。

    Shell：

    语法：put 'table','rowkey','family:column','value'[,'timestamp']
例如：插入表t1，行r1，列c1，时间戳ts1

hbase> put ‘t1’, ‘r1’, ‘c1’, ‘value’, ts1


同样，也可以在表引用上使用

hbase> t.put ‘r1’, ‘c1’, ‘value’, ts1

    Java实现：

    /**
 * 插入数据
 *
 * @param tableName 表名
 * @param rowKey    行键
 * @param familys   列族信息(Key: 列族; value: (列名, 列值))
 */
public static void putData(String tableName, String rowKey, Map<String, Map<String, String>> familys)
        throws IOException {

    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Table table = connection.getTable(TableName.valueOf(tableName))
    ) {
        Put put = new Put(Bytes.toBytes(rowKey));

        for (Map.Entry<String, Map<String, String>> family : familys.entrySet()) {
            for (Map.Entry<String, String> column : family.getValue().entrySet()) {
                put.addColumn(Bytes.toBytes(family.getKey()),
                        Bytes.toBytes(column.getKey()), Bytes.toBytes(column.getValue()));
            }
        }
        table.put(put);
    }
}

# 调用例
// 行键1
Map<String, Map<String, String>> map1 = new HashMap<>();
// 列族author的列值
Map<String, String> author1 = new HashMap<>();
author1.put("name", "张三");
author1.put("school", "MIT");
map1.put("author", author1);
// 列族contents的列值
Map<String, String> contents1 = new HashMap<>();
contents1.put("content", "吃饭了吗?");
map1.put("contents", contents1);
putData("blog", "rk1", map1);

    8. scan

    扫描全表。

    语法：scan 'table' [, {COLUMNS => [ 'family:column', .... , LIMIT => num} ]
可以使用以下限定词：
TIMERANGE, FILTER, LIMIT, STARTROW, STOPROW, TIMESTAMP, MAXLENGTH,
, COLUMNS, CACHE。
如果没有限定词，则扫描全表。
列族的列指定为空时，扫描列族中全部数据（'col_family:'）。
指定过滤条件有两种方式:
1. 使用过滤字符串 – 详细见[HBASE-4176 JIRA](https://issues.apache.org/jira/browse/HBASE-4176)
2. 使用过滤器的整个包名称。

示例如下：

hbase> scan ‘.META.’
hbase> scan ‘.META.’, {COLUMNS => ‘info:regioninfo’}
hbase> scan ‘t1’, {COLUMNS => [‘c1’, ‘c2’], LIMIT => 10, STARTROW => ‘xyz’}
hbase> scan ‘t1’, {COLUMNS => ‘c1’, TIMERANGE => [1303668804, 1303668904]}
hbase> scan ‘t1’, {FILTER => “(PrefixFilter (‘row2’) AND
(QualifierFilter (>=, ‘binary:xyz’))) AND (TimestampsFilter ( 123, 456))”}
hbase> scan ‘t1’, {FILTER =>
org.apache.hadoop.hbase.filter.ColumnPaginationFilter.new(1, 0)}

CACHE_BLOCKS：切换block caching，默认可用。
示例：

hbase> scan ‘t1’, {COLUMNS => [‘c1’, ‘c2’], CACHE_BLOCKS => false}


RAW：扫描返回所有数据 (包括delete markers和uncollected deleted)。
该选项不能和指定COLUMNS共用。默认disable。
示例：

hbase> scan ‘t1’, {RAW => true, VERSIONS => 10}

默认使用toStringBinary格式化，scan支持对列的自定义格式化。
FORMATTER约定：

1. 使用org.apache.hadoop.hbase.util.Bytes的方法(例如toInt, toString)；
2. 使用自定义类的方法例如'c(MyFormatterClass).format'。

例如 cf:qualifier1 和 cf:qualifier2：
hbase> scan ‘t1’, {COLUMNS => [‘cf:qualifier1:toInt’,
‘cf:qualifier2:c(org.apache.hadoop.hbase.util.Bytes).toInt’] }

注：只能指定列的FORMATTER，不能指定列族中所有列的FORMATTER。

可以使用表的引用调用该方法：

hbase> t = get_table ‘t’
hbase> t.scan

    Java实现：

    /**
 * 全表扫描
 *
 * @param tableName 表名
 *
 * @throws IOException
 */
public static void scan(String tableName) throws IOException {
    try (Connection connection = ConnectionFactory.createConnection(configuration);
         Table table = connection.getTable(TableName.valueOf(tableName))
    ) {
        Scan scan = new Scan();
        ResultScanner resultScanner = table.getScanner(scan);
        for (Result result : resultScanner) {
            List<Cell> cells = result.listCells();
            for (Cell cell : cells) {
                System.out.println("row => " + Bytes.toString(CellUtil.cloneRow(cell)) + "
"
                        + "family => " + Bytes.toString(CellUtil.cloneFamily(cell)) + "
"
                        + "qualifier => " + Bytes.toString(CellUtil.cloneQualifier(cell)) + "
"
                        + "value => " + Bytes.toString(CellUtil.cloneValue(cell)));
            }
        }
    }
}

# 调用示例
scan("blog");

    9. truncate

    无效、删除并重新创建表。

    Shell：

    hbase>truncate ‘t1’
    • 1
    • 1

    Java示例：

    工具

    命令说明
    assign 分配region，如果region已经被分配，将强制重新分配。
    hbase> assign ‘REGION_NAME’
    balancer 触发集群均衡器。
    hbase> balancer
    balance_switch 切换均衡器。
    hbase> balance_switch true
    hbase> balance_switch false
    close_region 关闭region。
    hbase>close_region 'REGIONNAME', 'SERVER_NAME'
    compact Compact all regions in a table:
    hbase> compact ‘t1’
    Compact an entire region:
    hbase> compact ‘r1’
    Compact only a column family within a region:
    hbase> compact ‘r1’, ‘c1’
    Compact a column family within a table:
    hbase> compact ‘t1’, ‘c1’
    flush Flush all regions in passed table or pass a region row to flush an individual region. 
    For example:
    hbase> flush ‘TABLENAME’
    hbase> flush ‘REGIONNAME’
    major_compact Compact all regions in a table:
    hbase> major_compact ‘t1’
    Compact an entire region:
    hbase> major_compact ‘r1’
    Compact a single column family within a region:
    hbase> major_compact ‘r1’, ‘c1’
    Compact a single column family within a table:
    hbase> major_compact ‘t1’, ‘c1’
    move 随机移动到某region server
    hbase> move ‘ENCODED_REGIONNAME’
    移动region到指定的server
    hbase>move 'ENCODED_REGIONNAME', 'SERVER_NAME'
    split Split entire table or pass a region to split individual region. With the second parameter, you can specify an explicit split key for the region.
    Examples:
    split ‘tableName’
    split ‘regionName’ # format: ‘tableName,startKey,id’
    split ‘tableName’, ‘splitKey’
    split ‘regionName’, ‘splitKey’
    unassign Unassign a region. Unassign will close region in current location and then reopen it again. Pass ‘true’ to force the unassignment (‘force’ will clear all in-memory state in master before the reassign. If results in double assignment use hbck -fix to resolve. To be used by experts). Use with caution. For expert use only.
    Examples:
    hbase> unassign ‘REGIONNAME’
    hbase> unassign ‘REGIONNAME’, true
    hlog_roll Roll the log writer. That is, start writing log messages to a new file. The name of the regionserver should be given as the parameter. A ‘server_name’ is the host, port plus startcode of a regionserver. For example:
    host187.example.com,60020,1289493121758 (find servername in master ui or when you do detailed status in shell)
    hbase>hlog_roll
    zk_dump Dump status of HBase cluster as seen by ZooKeeper. Example:
    hbase>zk_dump

    集群复制

    命令说明
    add_peer Add a peer cluster to replicate to, the id must be a short and the cluster key is composed like this:
    hbase.zookeeper.quorum:hbase.zookeeper.property.clientPort:zookeeper.znode.parent This gives a full path for HBase to connect to another cluster.Examples:
    hbase>add_peer ‘1’, “server1.cie.com:2181:/hbase”
    hbase>add_peer ‘2’, “zk1,zk2,zk3:2182:/hbase-prod”
    remove_peer Stops the specified replication stream and deletes all the meta information kept about it. Examples:
    hbase> remove_peer ‘1’
    list_peers List all replication peer clusters.
    hbase> list_peers
    enable_peer Restarts the replication to the specified peer cluster, continuing from where it was disabled. Examples:
    hbase> enable_peer ‘1’
    disable_peer Stops the replication stream to the specified cluster, but still keeps track of new edits to replicate.Examples: 
    hbase> disable_peer ‘1’
    start_replication Restarts all the replication features. The state in which each stream starts in is undetermined. 
    WARNING: start/stop replication is only meant to be used in critical load situations. Examples:
    hbase> start_replication
    stop_replication Stops all the replication features. The state in which each stream stops in is undetermined. 
    WARNING: start/stop replication is only meant to be used in critical load situations. Examples: 
    hbase> stop_replication

    权限控制

    命令说明
    grant 授予用户指定权限. 
    语法：集合’RWXCA’中任意个字符。
    READ(‘R’)
    WRITE(‘W’)
    EXEC(‘X’)
    CREATE(‘C’)
    ADMIN(‘A’)
    例如：
    hbase> grant ‘bobsmith’, ‘RWXCA’
    hbase> grant ‘bobsmith’, ‘RW’, ‘t1’, ‘f1’, ‘col1’
    revoke 移除用户权限。
    语法：revoke
    hbase> revoke ‘bobsmith’, ‘t1’, ‘f1’, ‘col1’
    user_permission 显示用户权限。
    语法：user_permission ‘table’
    hbase> user_permission ‘table1’

    参考

    1. HBase shell scan 模糊查询

    2. HBase 5种写入数据方式

    3. HBase 常用Shell命令

    4. hbase 1.1.4增删查改demo

    5. java 获取 hbase数据 springdatahadoop – hbasetemplate

    6. HBase shell commands

    7. HBase Maven Dependency

    8. HBase内置过滤器的一些总结

    9. HBase（0.96以上版本）过滤器Filter详解及实例代码

    10. HBase java 统计表行数

    11. HBase之计数器
  • 相关阅读:
    Servlet 处理HTTP请求
    Servlet基础知识
    JavaWeb基础知识点①请求响应②comcat③类和类的关系
    MySQL子查询
    聚合与分组
    表联接
    LVS+KEEPALIVED
    tar命令详解
    mysql 安装
    mysql两种备份方法总结：mysqldump 和 xtrabackup
  • 原文地址：https://www.cnblogs.com/seaspring/p/6504935.html
Copyright © 2020-2023  润新知