tencent cloud

CREATE TABLE hbase_table (
  rowkey INT,
  cf ROW < school_name STRING >,
  PRIMARY KEY (rowkey) NOT ENFORCED
) WITH (
  'connector' = 'hbase-1.4',                          -- Flink v1.13 supports HBase v2.2.
  'table-name' = 'hbase_sink_table',                         -- The name of the HBase table.
  'zookeeper.quorum' = 'ip:port,ip:port,ip:port'   -- The ZooKeeper address of the HBase table.
);

CREATE TABLE datagen_source_table (
  id INT,
  name STRING,
  `proc_time` AS PROCTIME()
) with (
  'connector'='datagen',
  'rows-per-second'='1'
);

CREATE TABLE hbase_table (
  rowkey INT,
  cf ROW < school_name STRING >,
  PRIMARY KEY (rowkey) NOT ENFORCED
) WITH (
  'connector' = 'hbase-1.4',                          -- Flink v1.13 supports HBase v2.2.
  'table-name' = 'hbase_sink_table',                         -- The name of the HBase table.
  'zookeeper.quorum' = 'ip:port,ip:port,ip:port'   -- The ZooKeeper address of the HBase table.
);

CREATE TABLE blackhole_sink(
  id INT,
  name STRING
) with (
  'connector' = 'blackhole' 
);

INSERT INTO blackhole_sink
     SELECT id, cf.school_name as name FROM datagen_source_table src
JOIN hbase_table FOR SYSTEM_TIME AS OF src.`proc_time` as h ON src.id = h.rowkey;