ExternalDistributed

    See a detailed description of the CREATE TABLE query.

    • Column names should be the same as in the original table, but you can use just some of these columns and in any order.
    • Column types may differ from those in the original table. ClickHouse tries to values to the ClickHouse data types.

    Engine Parameters

    • host:port — MySQL or PostgreSQL server address.
    • database — Remote database name.
    • table — Remote table name.
    • — User name.

    Implementation Details

    When specifying replicas, one of the available replicas is selected for each of the shards when reading. If the connection fails, the next replica is selected, and so on for all the replicas. If the connection attempt fails for all the replicas, the attempt is repeated the same way several times.

    See Also