INSERT INTO FROM INFILE times out

[billsbooth]

Describe the bug
INFILE CSV insert hangs, and times out.

Running a Clickhouse in the docker container, I have copied the CSV file into the docker container, and running a Python script from the host computer that does an INFILE CSV insert.

I have verified that connection works (I can run other queries, and get results).

Insert query just hangs.

To Reproduce

def load_to_clickhouse(csv_filename, table_name='public.trades'):
    print("Loading into ClickHouse...")
    client = Client(
        host='localhost',
        port=CLICKHOUSE_PORT,
        user='default',
    )

    # Load data using local file method
    query = f"""
        INSERT INTO {table_name}
        FROM INFILE '{csv_filename}';
    """

    print(query)

    try:
        print(client.execute(query))
        print(f"Successfully loaded rows into ClickHouse")
    except Exception as e:
        print(f"Error loading data: {e}")
    finally:
        client.disconnect()

Expected behavior
CSV is imported via INFILE.

Versions

python3 --version
Python 3.13.1

SELECT version()
┌─version()──┐

1. │ 24.10.2.80 │
   └────────────┘

[den-crane]

Use the other python driver https://github.com/ClickHouse/clickhouse-connect
It works over HTTP and thus is able to ingest CSV https://clickhouse.com/docs/en/integrations/python#file-inserts