Skip to content

Instantly share code, notes, and snippets.

@kavirajk

kavirajk/query_params_chgo.go

Created November 11, 2025 07:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kavirajk/98517052add7aaadc87612eccb57a9ec to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kavirajk/98517052add7aaadc87612eccb57a9ec to your computer and use it in GitHub Desktop.
Download ZIP
Query params ch-go array
Raw
query_params_chgo.go
package main
import (
"context"
"fmt"
"github.com/ClickHouse/ch-go"
"github.com/ClickHouse/ch-go/proto"
)
func main() {
ctx := context.Background()
c, err := ch.Dial(ctx, ch.Options{Address: "localhost:9000"})
if err != nil {
panic(err)
}
var (
numbers int
data proto.ColUInt64
)
params := ch.Parameters(map[string]any{
"array": "['a', 'b', 'c', 'heltlo', 'testing']",
"column": "number",
"database": "system",
"table": "numbers",
})
if err := c.Do(ctx, ch.Query{
// Body: "SELECT number FROM system.numbers LIMIT 500000000",
Body: "SELECT {column:Identifier} v, {array:Array(String)} a FROM {database:Identifier}.{table:Identifier} LIMIT 1 OFFSET 100",
Result: proto.Results{
{Name: "number", Data: &data},
},
// OnResult will be called on next received data block.
OnResult: func(ctx context.Context, b proto.Block) error {
numbers += len(data)
return nil
},
Parameters: params,
}); err != nil {
panic(err)
}
fmt.Println("numbers:", numbers)
}
@kavirajk
Copy link
Author

kavirajk commented Nov 11, 2025 

panic: handle packet: CANNOT_PARSE_INPUT_ASSERTION_FAILED (27): DB::Exception: Cannot parse input: expected ']' at end of stream: value [ cannot be parsed as Array(String) for query parameter 'array'

goroutine 1 [running]:
main.main()
        /home/kavi/src/play-go2/query_params_chgo.go:41 +0x517
exit status 2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment