How initialize the result of groupArray function of the ClickHouse to the array

Question

In my Go application, I make a request to the ClickHouse database via clickhouse-go package. This query which I make return always only one record and it's an array of integers. Is there any way to initialize that result to the array in Go?

var ids []int

ids, err := database.ClickHouse.Exec("SELECT groupArray(ID) FROM layers;")
if err != nil {
    fmt.Println(err)
}

I tried such code but it raises an error: cannot assign Result to ids (type []int) in multiple assignment.

Azeem · Accepted Answer · 2019-12-13 05:20:52Z

1

The Exec method doesn't return the rows, it returns driver.Result and error.

func (stmt *stmt) Exec(args []driver.Value) (driver.Result, error)
                                             ^^^^^^^^^^^^^

And, the driver.Result type has the following definition (comments removed):

type Result interface {
    LastInsertId() (int64, error)
    RowsAffected() (int64, error)
}

What you're looking for is Query method that returns driver.Rows:

func (stmt *stmt) Query(args []driver.Value) (driver.Rows, error)
                                              ^^^^^^^^^^^

You can then iterate over the rows to generate the array you want.

An example has been listed in the README.md (copied here):

rows, err := connect.Query("SELECT country_code, os_id, browser_id, categories, action_day, action_time FROM example")
if err != nil {
    log.Fatal(err)
}
defer rows.Close()

for rows.Next() {
    var (
        country               string
        os, browser           uint8
        categories            []int16
        actionDay, actionTime time.Time
    )
    if err := rows.Scan(&country, &os, &browser, &categories, &actionDay, &actionTime); err != nil {
        log.Fatal(err)
    }
    log.Printf("country: %s, os: %d, browser: %d, categories: %v, action_day: %s, action_time: %s", country, os, browser, categories, actionDay, actionTime)
}

Hope that helps!

answered Dec 13, 2019 at 5:20

Azeem

15.1k4 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Nurzhan Nogerbek Over a year ago

Hello! I don't need to return rows. I know that Query method return rows but in my case, I need to return only one row. So I thought this method is inappropriate here. As I said before groupArray function of ClickHouse return array of integers as one row. As I understand in this package there are only 2 methods: Exec and Query, right?

Azeem Over a year ago

@NurzhanNogerbek: But, the Exec method does not return row so you need to use the Query method to extract the values you want. It also has a QueryContext method but it also returns rows. You can write your own wrapper method on top of Query and use that.

Nurzhan Nogerbek Over a year ago

Can you show me an example of the QueryContext method, please?

Azeem Over a year ago

@NurzhanNogerbek: Check this: github.com/ClickHouse/clickhouse-go/blob/….

Nurzhan Nogerbek Over a year ago

I think QueryRowContext is that what I was looking for but I don't understand how correctly use it. What do think about this method?

|

SG Computers · Accepted Answer · 2022-05-04 11:28:08Z

0

var ids []int64

err := database.ClickHouse.QueryRow("SELECT groupArray(ID) FROM layers").Scan(&ids)
if err != nil {
    fmt.Println(err)
}
fmt.Println(ids)

answered May 4, 2022 at 11:28

SG Computers

1

Collectives™ on Stack Overflow

How initialize the result of groupArray function of the ClickHouse to the array

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related