Doris Routine Load正则表达实战
1. Kafka安装
wget https://dlcdn.apache.org/kafka/3.2.0/kafka_2.13-3.2.0.tgz
$ tar -xzf kafka_2.13-3.2.0.tgz
$ cd kafka_2.13-3.2.0
$ nohup bin/zookeeper-server-start.sh config/zookeeper.properties &
$ nohup bin/kafka-server-start.sh config/server.properties &
$ bin/kafka-topics.sh --create --topic test --bootstrap-server localhost:9092
2. Doirs库、表、Routine Load任务创建
create database kafka_doris;
use kafka_doris;
CREATE TABLE IF NOT EXISTS kafka_doris.clicklog
(
`clickTime` DATETIME NOT NULL COMMENT "点击时间"