ClickHouse: DB::Exception: Cannot read all data. Bytes read: 2538.

I have table

CREATE TABLE IF NOT EXISTS orgs_stats_views (
            date  Date,
            id_item UInt64,
            id_user Nullable(UInt64),
            platform UInt8,
            is_app UInt8,
            id_country Nullable(UInt8),
            id_region Nullable(UInt8),
            id_city Nullable(UInt8)
        ) engine=MergeTree(date, (id_item, platform, is_app), 8192)

query

SELECT count() as hit, date
FROM (SELECT * FROM orgs_stats_views WHERE (id_item = 85660) AND (date BETWEEN '2019-01-01' AND '2019-12-31')) t
GROUP BY date
ORDER BY date

error

Code: 33, e.displayText() = DB::Exception: Cannot read all data. Bytes read: 2538. Bytes expected: 33102.: (while reading column date): (while reading from part /var/lib/clickhouse/data/xxxx/orgs_stats_views/20190101_20190118_9742_9747_1/ from mark 14 with max_rows_to_read = 8192)

How i can resolve this problem?

About this issue

  • Original URL
  • State: closed
  • Created 5 years ago
  • Reactions: 1
  • Comments: 30 (6 by maintainers)

Most upvoted comments

Hello! Meet the same error.

ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 33, host: {HOST}, port: {PORT}; Code: 33, e.displayText() = DB::Exception: Cannot read all data. Bytes read: 1. Bytes expected: 2. (version 20.4.9.110 (official build))