413331861 opened a new issue #238: palo的count统计出来的结果会使某些数据count值变多，但实际查询还是1条 URL: https://github.com/apache/incubator-doris/issues/238 查询sql： select loan_id,count(1) count from loan_application_v7 group by loan_id having count > 1; 结果：+-------------+-------+ | loan_id | count | +-------------+-------+ | 9992910006 | 2 | | 6219310002 | 2 | | 9988650003 | 2 | | 11507850002 | 2 | | 6214400003 | 2 | | 11509960008 | 2 | | 11520870001 | 2 | | 9988140009 | 2 | | 9988160010 | 2 | | 9990600007 | 2 | | 6213530003 | 2 | | 6221520003 | 2 | | 9989650002 | 2 | | 6216700006 | 2 | | 11515600008 | 2 | | 11516580007 | 2 | | 6213200006 | 2 | | 11514860009 | 2 | +-------------+-------+ select count(1) from loan_application_v7 where loan_id = 9992910006; +----------+ | count(1) | +----------+ | 1 | +----------+
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
