good first issuetype/enhancement
仓库指标
- Star
- (5,717 star)
- PR 合并指标
- (平均合并 1天 5小时) (30 天内合并 1,000 个 PR)
描述
Enhancement
MySQL root@127.1:d1> select event_date from tjson group by event_date;
(1064, 'Getting analyzing error. Detail message: Type (nested) percentile/hll/bitmap/json not support group-by.')
JSON is currently not supported in the GROUP BY clause, but enabling this functionality could be beneficial for certain scenarios.
To implement GROUP BY support for JSON, a stable hash function and comparison function are required. This can be achieved using asymmetric hash mixing techniques, such as XOR, which is already implemented in JsonValue::hash.