Logo

ClickHouse MonitoringMonitoring

  • Overview
Breadcrumb: could not get list database
Error: Setting query_cache_system_table_handling is neither a builtin setting nor started with the prefix 'SQL_' registered for user-defined settings.

MaterializedView: prodenv.C2C_CAN_LATEST

1
CREATE MATERIALIZED VIEW prodenv.C2C_CAN_LATEST
(
    `id` String,
    `date` Date,
    `insert_timestamp` DateTime64(3),
    `timestamp` DateTime64(3),
    `sequence` UInt32,
    `byte1` UInt8,
    `byte2` UInt8,
    `byte3` UInt8,
    `byte4` UInt8,
    `byte5` UInt8,
    `byte6` UInt8,
    `byte7` UInt8,
    `byte8` UInt8,
    `can_id` UInt32,
    `dbc_ver` UInt16
)
ENGINE = ReplacingMergeTree(timestamp)
ORDER BY id
SETTINGS index_granularity = 8192
AS SELECT *
FROM prodenv.C2C_CAN