avamingli commented on issue #1251: URL: https://github.com/apache/cloudberry/issues/1251#issuecomment-3113602116
> _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: Hi, I create some random data, but couldn't reproduce that. The log is on master, so there is no much info. Could you try to explain the SQL to see if it will crash? explain(verbose) ```sql explain(verbose) select country, ref_year, count() as ref_frequency, count(distinct ref_uid) as ref_quantity from reference_info group by country, ref_year; ``` and explain(analyze) ```sql explain(verbose, analyze) select country, ref_year, count() as ref_frequency, count(distinct ref_uid) as ref_quantity from reference_info group by country, ref_year; ``` -- 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]
