https://wiki.noc.co.ua/ Mon, 18 May 2026 06:23:35 +0000 FeedCreator 1.8 https://wiki.noc.co.ua/lib/tpl/dokuwiki/images/favicon.ico https://wiki.noc.co.ua/ https://wiki.noc.co.ua/software:clickhouse?rev=1627903788&do=diff Хелперы работы с clickhouse SELECT partition, name, table FROM system.parts WHERE active ss SELECT * FROM system.parts WHERE active limit 1 ss SELECT name, type, formatReadableSize(data_compressed_bytes) AS compressed, formatReadableSize(data_uncompressed_bytes) AS uncompressed, data_uncompressed_bytes / data_compressed_bytes AS ratio, compression_codec FROM system.columns WHERE (database = 'traffic') AND (table = 'raw') ORDER BY data_compressed_bytes DESC… anonymous@undisclosed.example.com (Anonymous) software Mon, 02 Aug 2021 14:29:48 +0000