mogdb select RATIO_TO_REPORT ERROR: compressed data is corrupt

我来答

2024-10-11

在mogdb 5.0 中正常子查询可以执行，但是在外层包了RATIO_TO_REPORT(CONNECT_COUNT) OVER () 就报错ERROR: compressed data is corrupt

MogDB=#SELECT HOSTIP, SUM(CONNECT_COUNT) CONNECT_COUNT
#                               FROM RD_DB_LSNR
#                               WHERE BATCHID = 235
#                                 AND TIME = '2023-07-26T21:00:00'::timestamp
#                               GROUP BY HOSTIP;
     hostip     | connect_count 
----------------+---------------
 192.168.18.33  |            34
 192.168.18.107 |           613
 192.168.18.108 |           113
(3 rows)

MogDB=#SELECT HOSTIP, CONNECT_COUNT, ROUND(100 * RATIO_TO_REPORT(CONNECT_COUNT) OVER ()) CONNECT_PCT
#                         FROM (SELECT HOSTIP, SUM(CONNECT_COUNT) CONNECT_COUNT
#                               FROM RD_DB_LSNR
#                               WHERE BATCHID = 235
#                                 AND TIME = '2023-07-26T21:00:00'::timestamp
#                               GROUP BY HOSTIP
#                              )
#                         ORDER BY CONNECT_COUNT DESC
#                         LIMIT '3'
#;
ERROR:  compressed data is corrupt
复制

我来答

添加附件

问题补充

1条回答

默认

最新

章芋文

临时将 RATIO_TO_REPORT 改成了 CONNECT_COUNT / SUM(CONNECT_COUNT) OVER()规避了这个bug

SELECT HOSTIP, CONNECT_COUNT, ROUND(100 * CONNECT_COUNT / SUM(CONNECT_COUNT) OVER()) CONNECT_PCT
                            FROM (SELECT HOSTIP, SUM(CONNECT_COUNT) CONNECT_COUNT
                                  FROM RD_DB_LSNR
                                  WHERE BATCHID = 235
                                    AND TIME = '2023-07-26T21:00:00'::timestamp
                                  GROUP BY HOSTIP
                                 )
                            ORDER BY CONNECT_COUNT DESC
                            LIMIT 3;
复制

有用 1

打赏 0

回答交流

Markdown

请输入正文

导入word

提交

问题信息

请登录之后查看

邀请回答

暂无人订阅该标签，敬请期待~~

墨值悬赏