ChDB fails to execute Query 21 of TPCH_SF10 about chdb HOT 5 CLOSED

I have run it successfully with v0.11.0, it will consume about 4.5GiB memory. So, how much memory do you get?

result:

              supp.S_NAME  numwait
0   b'Supplier#000062538'       24
1   b'Supplier#000032858'       22
2   b'Supplier#000063723'       21
3   b'Supplier#000089484'       21
4   b'Supplier#000007061'       20
..                    ...      ...
95  b'Supplier#000006757'       16
96  b'Supplier#000006795'       16
97  b'Supplier#000006824'       16
98  b'Supplier#000007491'       16
99  b'Supplier#000008301'       16

[100 rows x 2 columns]

from chdb.

can you provide kernel log, and about your machine information like: cpu, memory size.

run dmesg get kernel log.

run free -m get memory size.

run lscpu get cpu info.

from chdb.

my environment: chdb==0.11.0, I have run it successfully, Below is the table listing the resources I have utilized

maximum of approximately of memory

from chdb.

@reema93jain Can you help confirm it's a memory issue? Maybe also change the comment on Query 21 in PR #58

from chdb.

Hi Team,

Thank you for looking into it.

Below are the details about my system. I will remove comment on Query 21:

chdb==0.10.1, Python 3.10.6

Memory Size:

CPU Info:
![image](https://github.com/chdb-io/chdb/assets/113460610/a0505e72-9b08-4063-8be1-70f

Kernel logs
kernel_logs.txt
3534a4cdd)

Thanks
Reema Jain

from chdb.