# hbase-tools

**Repository Path**: wl4g/hbase-tools

## Basic Information

- **Project Name**: hbase-tools
- **Description**: 一个通用的 HBase/Phoenix 表数据运维工具
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2022-10-22
- **Last Updated**: 2022-12-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Phoenix Tools

> A general Phoenix-HBase table data faker/cleaner operation tools.

## Quick start (example):

### Initial example data:

- [mysql-init.sql](testdata/mysql-init.sql)

- [phoenix-init.sql](testdata/phoenix-init.sql)

- import sqls with sqlline.py

```bash
sqlline.py localhost:2181 ./phoenix-init.sql
```

### Generate meta CSV SQLs

- for example:

```bash
SELECT
    c.customerName,
    e.equipmentName,
    e.addrIP,
    e.addrIPOrder,
    t.templateMark
FROM
    ed_equipmentinfo e
    INNER JOIN ed_customer c ON c.customerId = e.customerId
    INNER JOIN ed_equiptemplate t ON t.templateId = e.templateId 
WHERE
    e.workingStatus = 1
    AND e.`status` = 0
    AND c.isEnabled = 0
    AND t.`status` = 0
    AND c.customerName LIKE '%佛山市xxx印染%'
    AND e.addrIP IS NOT NULL 
    AND e.addrIPOrder > 0
```

### Startup runner

- [Generating missing data with Faker](./README_FAKER.md)

- [Removing useless data with Cleaner](./README_CLEANER.md)

## Developer guide

- Building

```bash
git clone git@github.com/wl4g/phoenix-tools.git
mvn clean package -DskipTests -Pphoenix4 -Pbuild:springjar
```

## FAQ

- How the generating GraalVM `relfect-config.json`. Notice: The success passed tested versions are: `graalvm-ce-java8-21.0.0.2`, and the failed versions are: `graalvm-ce-java11-22.1.0`

```bash
/usr/local/graalvm-ce-java8-21.0.0.2/bin/java -jar \
-agentlib:native-image-agent=config-merge-dir=/tmp/configdir/ \
phoenix-tools-1.0.0-bin.jar \
--spring.datasource.url=jdbc:phoenix:localhost:2181 ...
```