Skip to content

Network error querying hybrid tables #363

Description

@xieandrew

What happened

On the deployed SQL browser in the antalya demo cluster, running a query on a hybrid table results in a network error.

Query:

SELECT
    Carrier,
    count() AS flights,
    round((100 * countIf(ArrDel15 = 0)) / count(), 1) AS on_time_pct
FROM ontime.fact_ontime_hybrid
WHERE (Year >= 2012) AND (Carrier IN ('WN'))
GROUP BY Carrier
ORDER BY on_time_pct DESC

After running, the query results don't show up due to a "Network error". Request response in browser network tab:

{"progress":{"read_rows":"11546","read_bytes":"2261595","elapsed_ns":"636463255"}}
{"progress":{"read_rows":"35944","read_bytes":"6756395","elapsed_ns":"747434687"}}

__exception__
pkwzqpecqitkjwli
Code: 210. DB::Exception: Connection reset by peer, while reading from socket (peer: 127.0.0.1:9000, local: 127.0.0.1:53960): while receiving packet from chi-antalya-antalya-0-0:9000, 127.0.0.1, local address: 127.0.0.1:53960: While executing Remote. (NETWORK_ERROR) (version 26.3.10.20001.altinityantalya (altinity build))
324 pkwzqpecqitkjwli
__exception__

This error doesn't occur querying MergeTree (ontime.fact_ontime) or Iceberg tables (ice.`ontime.fact_ontime`) with the same query. Also had this error querying a different Hybrid table (tripdata.taxi_trips_hybrid).

Environment

  • Browser + version: Firefox
  • ClickHouse server (version / Antalya or OSS): Antalya 26.3
  • Auth mode (OAuth IdP / credentials): OAuth
  • App version (from the build, if shown): Deployed version in antalya.demo

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions