Problems with INSERT and SELECT operations when the number of rows falls between 100 millions and 1 billion

Customer reported:

Description: During some tests, we found that working with an increasing batch of data (1K, 10K, 100K, 1M, 10M, 100M, 1B rows) the ColumnStore worked as expected till we launched a SQL statement that acts on more than 100M rows. In this case, the operation stopped with the following error:

#1815 - Internal error: InetStreamSocket::readToMagic: Remote is closed

The SQL statement and the corresponding log are in the attached file.

Date/time: 2020-12-04 16:21:06
Signal: 11

/usr/bin/ExeMgr(+0x24ad0)[0x55ab2a6d3ad0]
/lib64/libpthread.so.0(+0xf630)[0x7f48765ee630]
/lib64/libjoblist.so(_ZN7joblist21DistributedEngineComm5SetupEv+0xd9d)[0x7f487621b31d]
/lib64/libjoblist.so(_ZN7joblist21DistributedEngineComm6ListenEN5boost10shared_ptrIN11messageqcpp18MessageQueueClientEEEj+0x2cb)[0x7f487621c85b]
/lib64/libjoblist.so(+0x10bb13)[0x7f487621cb13]
/lib64/libboost_thread-mt.so.1.53.0(+0xd1da)[0x7f48725931da]
/lib64/libpthread.so.0(+0x7ea5)[0x7f48765e6ea5]
/lib64/libc.so.6(clone+0x6d)[0x7f486ff3a96d]