Hbase 批量删除

最新推荐文章于 2023-09-13 16:42:25 发布

qq_27593415

最新推荐文章于 2023-09-13 16:42:25 发布

阅读量4.9k

点赞数

分类专栏： hbase

本文链接：https://blog.csdn.net/qq_27593415/article/details/53167980

版权

hbase 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

hbase定期批量删除

 /**
     * 删除一段时间的表记录
     *
     * @param c
     * @param minTime
     * @param maxTime
     */
    public static void deleteTimeRange(String tableName, Long minTime, Long maxTime) {
        Table table = null;
        Connection connection = null;

        try {
            Scan scan = new Scan();
            scan.setTimeRange(minTime, maxTime);
            connection = HBaseOperator.getHbaseConnection();
            table = connection.getTable(TableName.valueOf(tableName));
            ResultScanner rs = table.getScanner(scan);

            List<Delete> list = getDeleteList(rs);
            if (list.size() > 0) {

                table.delete(list);
            }
        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            if (null != table) {
                try {
                    table.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }

            if (connection != null) {
                try {
                    connection.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }

    }

    private static List<Delete> getDeleteList(ResultScanner rs) {

        List<Delete> list = new ArrayList<>();
        try {

            for (Result r : rs) {
                Delete d = new Delete(r.getRow());
                list.add(d);
            }
        } finally {
            rs.close();
        }
        return list;
    }