chdb-go
chdb-go copied to clipboard
Table system.parts does not exist
With the following program, I'm not able to query system.parts
.
package main
import (
"fmt"
"github.com/chdb-io/chdb-go/chdb"
)
func main() {
result, err := chdb.Query("SELECT version()", "CSV")
if err != nil {
fmt.Println(err)
return
}
fmt.Println(result)
session, _ := chdb.NewSession("./data")
defer session.Close()
q := `select * from system.parts`
ret, err := session.Query(q)
if err != nil {
fmt.Println(err)
return
}
fmt.Println(ret)
}
This outputs the following:
$ CGO_LDFLAGS="-L." go run .
"23.10.1.1"
Code: 60. DB::Exception: Table system.parts does not exist. (UNKNOWN_TABLE)
I am linking downloaded chdb v1.3.0. It is curious that the version is so old. It seems like system.parts
was added in December 2023 based on these issues:
- https://github.com/ClickHouse/ClickHouse/issues/58312
- https://github.com/ClickHouse/ClickHouse/pull/58359
I'm upgrading ClickHouse engine to 24.10 on chdb main branch.