注意点
官方地址:https://ksqldb.io/quickstart-standalone-tarball.html#quickstart-content 请先安装好zookeeper和kafka 注意:kafka的版本请使用2.4.0及以上版本
1、下载安装
# 下载公钥 curl -sq http://ksqldb-packages.s3.amazonaws.com/archive/0.24/archive.key | gpg --import # 下载包 curl http://ksqldb-packages.s3.amazonaws.com/archive/0.24/confluent-ksqldb-0.24.0.tar.gz --output confluent-ksqldb-0.24.0.tar.gz curl http://ksqldb-packages.s3.amazonaws.com/archive/0.24/confluent-ksqldb-0.24.0.tar.gz.asc --output confluent-ksqldb-0.24.0.tar.gz.asc # 验证 gpg --verify confluent-ksqldb-0.24.0.tar.gz.asc confluent-ksqldb-0.24.0.tar.gz # 解压 tar -xf confluent-ksqldb-0.24.0.tar.gz -C /opt/confluent
2、修改ksql-server.properties文件
vim ./etc/ksqldb/ksql-server.properties #修改对应的kafka的bootstrap server bootstrap.servers=hadoo100:9092,hadoop101:9092,hadoop102:9092
3、启动KSQL server
./bin/ksql-server-start ./etc/ksqldb/ksql-server.properties
4、启动ksql cli端
./bin/ksql http://0.0.0.0:8088
5、http提交
##查看流表 curl -X "POST" "http://localhost:8088/ksql" \ -H "Accept: application/vnd.ksql.v1+json" \ -d $'{ "ksql": "LIST STREAMS;", "streamsProperties": {} }' ##查看数据 curl -X "POST" "http://hadoop100:8088/query" \ -H "Accept: application/vnd.ksql.v1+json" \ -d $'{ "ksql": "SELECT * FROM READINGS EMIT CHANGES;", "streamsProperties": { "ksql.streams.auto.offset.reset": "earliest"} }'