SaltTan
SaltTan
Always create materialized views using the TO syntax (requires an existing storage table). It is much easier to manage, especially in Atomic databases. You can convert an implicit table to...
Does it reproduce in 24.1.5.6?
A workaround is to detach the table, remove the parts that are being detached manually and attach the table back.
> > A workaround is to detach the table, remove the parts that are being detached manually and attach the table back. > > hello @SaltTan ! We encountered an...
A query to find replicas with incorrect metadata version ```sql select path, value, version, concat('set ',path,'/metadata_version ',r.version) from (select * from system.zookeeper where name = 'metadata_version' and path like '/clickhouse/tables/%replicas%'...
Another one, with a Merge table and a distributed query. 24.2+ https://fiddle.clickhouse.com/4f181521-8538-4a38-81b8-a64777db1d75 ``` create table t1 ( key Int32, value Float32 ) engine=MergeTree order by tuple(); insert into t1 values...
Works in 24.2 https://fiddle.clickhouse.com/05514b83-dcaf-42dc-89a3-78ec2939d3b7
A workaround is `settings allow_experimental_analyzer=0` https://fiddle.clickhouse.com/1bc566c9-9c3f-444d-b8ed-795c35f01ae7
workaround `set cross_to_inner_join_rewrite=0;` https://fiddle.clickhouse.com/c8a73ae1-ff38-47bb-9e85-a63890c74c32
@geldot what is your table definition? > After downgrading back to 24.6, the parts flagged by 24.7 remain detached Have you tried attaching them back after the downgrade to 24.6?