查看表、存储信息、压缩比等。 

select 
	database,
	table,
	formatReadablesize(size) as size,
	formatReadableSize(bytes_on_disk) as bytes_on_disk,
	formatReadableSize(data_uncompressed_bytes) as data_uncompressed_bytes,
	formatReadableSize(data_compressed_bytes) as data_compressedbytes,
	compress_rate,
	rows
from
(
	select
		database,
		table,
		sum(bytes) as size,
		sum(rows) as rows,
		sum(bytes_on_disk) as bytes_on_disk,
		sum(data_uncompressed_bytes) as data_uncompressed_bytes,
		sum(data_compressed_bytes)as data_compressed_bytes,
		(data_compressed_bytes/data_uncompressed_bytes)*100 as compress_rate
	from system.parts
	where active 
	and partition='2022-03-02'
	and database='ads_ck'
	and table='ADS_TMP_ALL'
	group by 
	database,
	table
)

 

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐