Ranger数据脱敏(1) Demo 1、准备工作 进入Hive客户端,输入如下SQL创建Demo必要的库表和数据。 plaintext CREATE DATABASE IF NOT EXISTS rangermaskdemo; USE rangermaskdemo; DROP TABLE IF EXISTS usersensitiveinfo; CREATE TABLE usersensitiveinfo ( userid BIGINT, username STRING, phonenumber STRING, idcard STRING, email STRING, bankcard STRING, address STRING, birthday DATE ) STORED AS PARQUET; INSERT INTO usersensitiveinfo VALUES (1, 'Alice', '13812345678', '110101199001011234', 'alice@example.com', '6222020202020202020', 'Beijing Chaoyang District', DATE '19900101'), (2, 'Bob', '13987654321', '310101198805083456', 'bob@example.com', '6222020202020202021', 'Shanghai Pudong New Area', DATE '19880508'), (3, 'Charlie', '13711112222', '440301199512123333', 'charlie@example.com', '6222020202020202022', 'Shenzhen Nanshan District', DATE '19951212'), (4, 'David', '13699990000', '330102199203154444', 'david@example.com', '6222020202020202023', 'Hangzhou Xihu District', DATE '19920315'), (5, 'Eva', '13588887777', '420106199811226666', 'eva@example.com', '6222020202020202024', 'Wuhan Hongshan District', DATE '19981122'); SELECT FROM usersensitiveinfo; 2、脱敏模式测试 Redact Redact:会将字段中的所有字符统一替换为固定字符,通常是X,并且替换后的字符串长度保持不变。测试结果如下: Hive测试结果 Spark测试结果
来自: