2948 explained code solutions for 75 technologies


clickhouseList table partitions


SELECT * FROM system.parts WHERE table = 'tbl' AND database = 'default';ctrl + c
system.parts

system table with partitions meta data

tbl

name of the table to get partitions for

default

database where tbl resides