S
Size: a a a
S
VB
CREATE MATERIALIZED VIEW monitor.events_mv TO monitor.insert_monitor
SELECT
today() AS date,
now() AS ts,
'events' AS table,
count(*) AS rows,
FQDN() AS hostname,
'kafka' AS source
FROM
db_name.events
GROUP BY
date,
ts,
table
VB
ИТ
ИТ
CREATE MATERIALIZED VIEW monitor.events_mv TO monitor.insert_monitor
SELECT
today() AS date,
now() AS ts,
'events' AS table,
count(*) AS rows,
FQDN() AS hostname,
'kafka' AS source
FROM
db_name.events
GROUP BY
date,
ts,
table
VB
insert_monitor
c MergeTree на KafkaИТ
insert_monitor
c MergeTree на KafkaVB
ИТ
VB
ИТ
A
TU
DC
FixedString(8) MATERIALIZED unhex(reinterpretAsString(hex_string))
DC
DC
DC
A
A
CREATE ROW POLICY show_perm ON sample_data.a AS RESTRICTIVE FOR SELECT USING data_type in ('type_a', 'type_b') TO sample_user;
A