clickhouse使用rabbitMq表引擎

最新推荐文章于 2024-01-23 02:19:41 发布

荆方冰

最新推荐文章于 2024-01-23 02:19:41 发布

阅读量1.2k

点赞数

分类专栏： javaWeb

本文链接：https://blog.youkuaiyun.com/qq_39733781/article/details/115375210

版权

javaWeb 专栏收录该内容

11 篇文章

订阅专栏

本文介绍如何使用SQL语法在ClickHouse中创建数据库、表及视图，并通过RabbitMQ实现数据同步。具体包括定义数据表结构、设置RabbitMQ参数及创建Materialized View进行数据转换。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE DATABASE IF NOT EXISTS event;

USE event;

CREATE TABLE IF NOT EXISTS event (
    `timestamp` DateTime,
    `id` UInt32,
    `body` String
) Engine = Memory;

CREATE TABLE IF NOT EXISTS rabbitmq_entry
(
    `timestamp` UInt64,
    `id` UInt32,
    `body` String
) ENGINE = RabbitMQ SETTINGS
    rabbitmq_host_port = 'rabbitmq:5672',
    rabbitmq_exchange_name = 'clickhouse-exchange',
    rabbitmq_routing_key_list = 'myqueue',
    rabbitmq_format = 'JSONEachRow',
    rabbitmq_exchange_type = 'fanout',
    rabbitmq_num_consumers = 1,
    rabbitmq_routing_key_list = 'myqueue'
    ;

CREATE MATERIALIZED VIEW IF NOT EXISTS event_view
TO event AS
SELECT
    toDateTime(toUInt64(divide(timestamp, 1000000000))) AS timestamp,
    id AS id,
    body AS body
FROM rabbitmq_entry;