Getting cannot read all data having too many marks in file. about clickhouse HOT 5 CLOSED

23.7 is out of support. You should upgrade to a supported version: https://github.com/ClickHouse/ClickHouse/pulls?q=is%3Aopen+is%3Apr+label%3Arelease

from clickhouse.

Ok, but what could be the possible issue?

from clickhouse.

Do you have skip (secondary) indexes #52433 ?

v23.7.6.111-stable.md:* Fix recalculation of skip indexes and projections in ALTER DELETE queries #52530 (Anton Popov).
v23.8.1.2992-lts.md:* Fix recalculation of skip indexes and projections in ALTER DELETE queries #52530 (Anton Popov).

from clickhouse.

I don't have any secondary index.

This is my create table syntax:

CREATE TABLE test_db.log_events
(
id UUID DEFAULT generateUUIDv4(),
created_at Nullable(DateTime) CODEC(DoubleDelta, ZSTD(1)),
updated_at Nullable(DateTime) CODEC(DoubleDelta, ZSTD(1)),
version UInt32 CODEC(Delta(4), ZSTD(1)),
payload Object('json')
)
ENGINE = MergeTree
ORDER BY tuple()
SETTINGS index_granularity = 8192

from clickhouse.

it's because of payload Object('json')

Object('json') is experimental is not supported and obsolete.

https://clickhouse.com/docs/en/sql-reference/data-types/json The JSON data type is an obsolete feature. Do not use it.

from clickhouse.