chdb-io / chdb-go

Go bindings and cli for chDB, an in-process SQL OLAP Engine powered by ClickHouse
https://chdb.io
Apache License 2.0
78 stars 2 forks source link

`Memory` engine is not working? #14

Open ventaquil opened 4 weeks ago

ventaquil commented 4 weeks ago

I am experimenting with chDB and Memory engine - Memory Table Engine.

It looks like it's not working at all.

All experiments are made in Docker container.

# go version
go version go1.22.2 linux/amd64
# /root/go/bin/chdb-go 'SELECT version()'
"24.5.1.1"
# /root/go/bin/chdb-go
Enter your SQL commands; type 'exit' to quit.
:) CREATE DATABASE testdb;

:) USE testdb;

:) CREATE TABLE memory (i UInt32) ENGINE = Memory SETTINGS min_rows_to_keep = 100, max_rows_to_keep = 1000;

:) INSERT INTO memory SELECT * FROM numbers(0, 1600);

:) SELECT total_bytes, total_rows FROM system.tables WHERE name = 'memory' and database = currentDatabase();
0,0
auxten commented 3 weeks ago

Current chdb session implementation does not support Memory Engine. We are implementing the new one. See https://github.com/chdb-io/chdb/issues/197