Author: Alexey Milovidov, 2020-04-04.
Zoom: https://yandex.zoom.us/j/845102379
YouTube: https://www.youtube.com/c/ClickHouseDB
Telegram chat: https://telegram.me/clickhouse_ru, clickhouse_en
Yandex.Eda, promo code: ClickHouse_break
(only for first 100 participants)
Tiered Storage DDL queries for dictionaries CONSTRAINTs Prepared Statements Format ORC Format Template ORDER BY optimization WITH FILL text_log metric_log Query Profiler Globs for File/URL/HDFS RPM packages neighbor os_schedule_priority ALTER MODIFY SETTING SELECT FROM VALUES COLUMNS matcher LIVE VIEW Settings constraints Row Level Security Secondary Indices TTL expressions MySQL protocol Adaptive index granularity Advanced text search JSON functions Cascade MATERIALIZED VIEWs WITH ROLLUP/CUBE ASOF JOIN Redis dictionary source Parallel parsing Template format CustomSeparated format VALUES optimization s3 import/export gzip/brotli import/export geoDistance
And also user, access and role management with SQL queries.
CREATE USER / DROP USER
CREATE ROLE / DROP ROLE
GRANT / REVOKE role TO user
GRANT / REVOKE SELECT columns ON db.table TO role/user
Доступно в версии 20.4. Разработчик — Виталий Баранов.
demo?
... and ALTER RENAME COLUMN
Доступно в версии 20.4. Разработчик — Александр Сапин.
ALTER MATERIALIZE TTL
ALTER MOVE PARTITION
SET join_algorithm = 'auto'
Automatic switching between Hash Join and Merge Join
depending on memory usage.
Доступно в версии 20.3. Разработчик — Артём Зуйков.
demo?
Date with time with more than second precision.
DateTime64(3) — milliseconds.
DateTime64(6) — microseconds.
...
Доступно в версии 20.1. Разработчик — Василий Немков, Altinity.
В разработке — расширенный диапазон.
Currently 1970–2106.
CREATE TABLE test.hits_compact AS test.hits
ENGINE = MergeTree ORDER BY ...
SETTINGS min_bytes_for_wide_part = '10M'
Speeds up small inserts.
Experimental feature.
Доступно в версии 20.3. Разработчик — Антон Попов.
demo?
Avro Format
Regexp Format
Prometheus Handler
Async mode for cache dictionaries
Memory Profiler
system.stack_trace
Network connections limiting
Full h3 support
Version 20.3 (March 2020) becomes LTS
(alpha version)
Runs on the weakest server in Yandex.Cloud.
LDAP for authentication
Kerberos for authentication
LDAP for storing rights and roles
ALTER RENAME COLUMN
Non-blocking CREATE/DROP/RENAME queries
Buffering and WAL for MergeTree
Cold data storage on top of S3 and HDFS.
Automated builds for FreeBSD x86_64 and Linux ppc64le.
Query result caching
Configurable HTTP handlers
Data encryption at rest
Geographical dictionaries
https://clickhouse.com/docs/ru/extended_roadmap/
~ 500 задач с подробным описанием — зависимости, исполнители...
63 of them are already done :)