Have you worked with ClickHouse? Share your experience.

Yes, I have worked with ClickHouse in projects related to big data analytics. My experience includes:

• Setting up connections from a Go application using the official ClickHouse client.
• Optimizing queries for fast aggregation analysis.
• Using partitioning and compression for efficient storage.

An example of a simple query from Go using the client:

import (
    "context"
    "github.com/ClickHouse/clickhouse-go/v2"
    "log"
)

func queryClickHouse() {
    conn, err := clickhouse.Open(&clickhouse.Options{
        Addr: []string{"127.0.0.1:9000"},
        Auth: clickhouse.Auth{
            Database: "default",
            Username: "default",
            Password: "",
        },
    })
    if err != nil {
        log.Fatal(err)
    }

    rows, err := conn.Query(context.Background(), "SELECT count() FROM my_table")
    if err != nil {
        log.Fatal(err)
    }
    defer rows.Close()

    var count int64
    if rows.Next() {
        if err := rows.Scan(&count); err != nil {
            log.Fatal(err)
        }
        log.Printf("Count: %d", count)
    }
}

ClickHouse is well-suited for tasks where speed of reading and processing large volumes of data is important.