Denny [DBA at Innervate]

trace

merged: * https://github.com/ClickHouse/ClickHouse/pull/62852

https://github.com/ClickHouse/ClickHouse/issues/56228#issuecomment-1789933636

Can you please share ``` show create table table0_tiered; select * from system.parts where table = 'table0_tiered' and name = '2_168_168_0_182' format Vertical; select * from system.parts_columns where table =...

I guess you added this `c77071` column today ? How many columns is in the table ? Ballpark ?

try as a workaround/test to disable compact parts ``` alter table table0_tiered modify setting min_bytes_for_wide_part = 0; ```

I see `RENAME COLUMN IF EXISTS value30 TO c68311` May be c77071 is also a result of rename column `RENAME COLUMN IF EXISTS .... TO c77071` , but that mutation...

Does it work if you change `orders.event_time` to `event_time` ? I reproduced some other issue `UNKNOWN_IDENTIFIER` ``` select arrayFilter(x -> toUnixTimestamp(parseDateTime64BestEffortOrZero( JSONExtractString(x,'event_time'))) > toUnixTimestamp(event_time),workflows) from orders limit 10 ``` https://fiddle.clickhouse.com/7e2399a7-8a29-4571-a94a-3798330bd638...

It needs a reproducer. @neel-bp Can you please share `` (do you use default database or secret?), and share `show create table orders`.

@neel-bp what about `` (do you use default database or secret?) ? >we roll backed to 23.3.22 and everything is fine now, And you can disable `allow_experimental_analyzer` with 24.3