HBase表设计 - 生存时间Time To Live

本文的主线 下载 => 服务 => TTL

本文基于Phoenix搭建

下载

wget http://archive.apache.org/dist/hbase/2.0.0/hbase-2.0.0-bin.tar.gz

tar xf hbase-2.0.0-bin.tar.gz

wget http://archive.apache.org/dist/phoenix/apache-phoenix-5.0.0-HBase-2.0/bin/apache-phoenix-5.0.0-HBase-2.0-bin.tar.gz

tar xf apache-phoenix-5.0.0-HBase-2.0-bin.tar.gz 

cp apache-phoenix-5.0.0-HBase-2.0-bin/phoenix-5.0.0-HBase-2.0-server.jar ~/hbase-2.0.0/lib/

服务

java -version
# openjdk version "1.8.0_272"

~/hbase-2.0.0/bin/start-hbase.sh

python2 --version
# Python 2.7.16

python2 ~/apache-phoenix-5.0.0-HBase-2.0-bin/bin/sqlline.py localhost

TTL

CREATE TABLE IF NOT EXISTS t_event (
    id BIGINT NOT NULL PRIMARY KEY,
    description VARCHAR
) TTL=10;

UPSERT INTO t_event VALUES(2001,'alarm');

SELECT * FROM t_event;

+-------+--------------+
|  ID   | DESCRIPTION  |
+-------+--------------+
| 2001  | alarm        |
+-------+--------------+
1 row selected (0.012 seconds)

-- 10秒过后
SELECT * FROM t_event;

+-----+--------------+
| ID  | DESCRIPTION  |
+-----+--------------+
+-----+--------------+
No rows selected (0.011 seconds)