Hologres问题能否帮忙解答下?-- 1 SELECT bac_no, umi, rb_or_cardinality_agg(active_channel_code::roaringbitmap) FROM dws.dws_shop_order_umi_di_1d WHERE end_date_key = '20230423' GROUP BY bac_no, umi;
-- 2 SELECT bac_no, umi, rb_cardinality(active_channel_code) FROM dws.dws_shop_order_umi_di_1d WHERE end_date_key = '20230423';
-- 2165 SELECT COUNT(*) FROM dws.dws_shop_order_umi_di_1d WHERE end_date_key = '20230423'; sql-1 不能返回结果,sql-2可以,sql-1的错误日志如下 [16:10:41] 错误原因:ERROR: status { code: SERVER_INTERNAL_ERROR message: "query next from pg executor failed from 10.247.19.211:21987: ERPC_ERROR_CONNECTION_CLOSED, reason: Drain packet failed, peer address: 10.247.19.211:21987[query_id:40121035102141771]" } Where: [query_id:40121035102141771]hgprecn-cn-zvp2awpkg00d-cn-beijing.hologres.aliyuncs.com:80
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。