[MCOL-1028] sum(colname) is giving different values sometimes Created: 2017-11-11 Updated: 2020-04-24 Resolved: 2020-04-24 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Smit Thakkar | Assignee: | Unassigned |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS |
||
| Issue Links: |
|
||||||||||||
| Epic Link: | ColumnStore Compatibility Improvements | ||||||||||||
| Description |
|
I am trying to run a simple sum query as stated below but it is giving me different results sometimes. I googled this problem but wasn't able to find it so I am putting it here. Is this a common behaviour, if so then is there a way to avoid it since we are a financial institute and accuracy of metrics is key for us. After successive trails and putting the results in excel we noticed that the delta between any of the results is always multiple of 4 and 32. select sum(loanAmount), grade from loans group by grade; |
| Comments |
| Comment by David Thompson (Inactive) [ 2017-11-13 ] |
|
Is it possible for you to provide a simplified test case that reproduces the specific problem you have? I'm not aware of any specific issues related to how you have described this. Also more details on your deployment os, columnstore version, number of pms(the columnstore support output would be very helpful for that? Also are you loading data concurrently? |
| Comment by David Thompson (Inactive) [ 2017-11-27 ] |
|
Hi smitthakkar96 - any chance you can provide more details on this as right now there is not enough information to troubleshoot / reproduce? |
| Comment by David Hall (Inactive) [ 2020-04-24 ] |
|
This problem is most likely resolved. We can't reproduce and the complainant hasn't given us a usable way to reproduce. |