cleverxiao001 opened a new issue, #1251:
URL: https://github.com/apache/cloudberry/issues/1251
### Apache Cloudberry version
2.0.0-incubating-rc2
### What happened
table structure:
create table reference_info
(
uid text,
country text,
ref_uid text,
ref_country text,
ref_year varchar(32)
)
There are 20 million data entries in the database table.
I run sql:
select t.country, t.ref_year, ref_quantity, ref_frequency
from (select country, ref_year, count(*) as ref_frequency from
reference_info group by country, ref_year) t
join
(select country, ref_year, count(*) as ref_quantity
from (select country, ref_year, ref_uid from reference_info group by
country, ref_year, ref_uid) t
group by country, ref_year) u
on t.country = u.country and t.ref_year = u.ref_year;
or
select ref_country, ref_year, count(distinct ref_uid) as cited_quantity,
count(*) as cited_frequency
from reference_info
where country = 'USA'
group by ref_country, ref_year;
is all worked.But
select country, ref_year, count(*) as ref_frequency, count(distinct ref_uid)
as ref_quantity
from reference_info
group by country, ref_year;
is failed ,log is:
2025-07-22 21:37:15.905016
EDT,"gpadmin","db",p4122615,th294045888,"192.168.23.218","33828",2025-07-22
21:27:15 EDT,0,con3154,cmd2,seg-1,,dx1344140,,sx1,"ERROR","58M01","Error on
receive from seg7 slice1 192.168.18.164:6007 pid=4123699: server closed the
connection unexpectedly This probably means the server terminated
abnormally
before or while processing the
request.",,,,,,,0,,"cdbdispatchresult.c",510,"Stack trace:
1 0x7fab13df44a8 libpostgres.so errstart + 0x258
2 0x7fab13dfa3f6 libpostgres.so ThrowErrorData + 0x16
3 0x7fab13a4919f libpostgres.so mppExecutorFinishup + 0xdf
4 0x7fab13a37b2e libpostgres.so standard_ExecutorEnd + 0xee
5 0x7fab139cc629 libpostgres.so PortalCleanup + 0x79
6 0x7fab13e3973b libpostgres.so PortalDrop + 0x3b
7 0x7fab13e39de5 libpostgres.so PreCommit_Portals + 0x125
8 0x7fab13889e5c libpostgres.so <symbol not found> + 0x13889e5c
9 0x7fab1388bd45 libpostgres.so CommitTransactionCommand + 0x2d5
10 0x7fab13c8f007 libpostgres.so PostgresMain + 0x1327
11 0x7fab13bd5b62 libpostgres.so <symbol not found> + 0x13bd5b62
12 0x7fab13bd6c41 libpostgres.so PostmasterMain + 0xe61
13 0x4027eb postgres main (main.c:200)
14 0x7fab12e295d0 libc.so.6 <symbol not found> + 0x12e295d0
15 0x7fab12e29680 libc.so.6 __libc_start_main + 0x80
16 0x402985 postgres _start + 0x25
"
### What you think should happen instead
_No response_
### How to reproduce
select country, ref_year, count(*) as ref_frequency, count(distinct ref_uid)
as ref_quantity
from reference_info
group by country, ref_year;
### Operating System
rocky 9.6
### Anything else
_No response_
### Are you willing to submit PR?
- [ ] Yes, I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of
Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
