UL
Size: a a a
UL
AG
НМ
S
НМ
НМ
S
НМ
S
В
НМ
S
SELECT
database,
table,
count() AS count_parts,
sum(rows) AS s_rows,
sum(marks) AS s_marks,
formatReadableSize(sum(marks_bytes)) AS s_marks_bytes,
formatReadableSize(sum(primary_key_bytes_in_memory)) AS s_pri_key_in_mem,
formatReadableSize(sum(primary_key_bytes_in_memory_allocated)) AS s_pri_key_in_alloc,
formatReadableSize(sum(data_compressed_bytes)) AS s_compr_bytes,
formatReadableSize(sum(data_uncompressed_bytes)) AS s_uncompr_bytes
FROM system.parts
WHERE active
GROUP BY
database,
table
ORDER BY s_rows ASC
S
НМ
AM
DB::Exception: Missing columns: '--i.url_hash' while processing queryЕсть идеи?
DB::Exception: Cannot refer column 'pictures.url_hash' to table.
SELECT pictures.url_hash FROM item_distributedвсё также прекрасно выполняется
AM
AG
DB::Exception: Cannot refer column 'pictures.url_hash' to table.
SELECT pictures.url_hash FROM item_distributedвсё также прекрасно выполняется
O
AG