Skip to content

system.parts is not filterable by partitions. #3109

@crakjie

Description

@crakjie

the following query return all database partitions.

SELECT
	partition,
	database,
	table
FROM
	system.parts
group by partition, database, table

but the following is returning nothing, while the first request is returning this partition.
but filtering on table name is working.

SELECT
	partition,
	database,
	table
FROM
	system.parts
WHERE  
     partition = 'b710e103-3d07-481e-afc0-1687a8782b73'
group by partition, database, table

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions