chdb-io/chdb-go

Table system.parts does not exist

Opened this issue · 1 comments

poundifdef commented

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:

auxten commented

I'm upgrading ClickHouse engine to 24.10 on chdb main branch.