manticoresearch icon indicating copy to clipboard operation
manticoresearch copied to clipboard

If data is being written, execute group by to obtain duplicate data

Open imgoby opened this issue 6 months ago • 0 comments

Bug Description:

(1)columnar table: mysql> desc test_table; +-----------+-----------+---------------------+ | Field | Type | Properties | +-----------+-----------+---------------------+ | id | bigint | columnar fast_fetch | | biz_code | string | columnar fast_fetch | | user_id | string | columnar fast_fetch | | charge | uint | columnar fast_fetch |

(2)See duplicate data:

mysql> SELECT biz_code,user_id from test_table group by biz_code,user_id; +--------------------------+--------+ | biz_code | user_id | +--------------------------+--------+ | test | 200002 | | test | 200002 |

(3)How to resolve? My current solution is to statistics data from a few minutes ago.

Manticore Search Version:

9.3.2

Operating System Version:

Docker

Have you tried the latest development version?

None

Internal Checklist:

To be completed by the assignee. Check off tasks that have been completed or are not applicable.

  • [ ] Implementation completed
  • [ ] Tests developed
  • [ ] Documentation updated
  • [ ] Documentation reviewed

imgoby avatar May 29 '25 06:05 imgoby