StarRocks/starrocks

Support using JSON as GROUP BY

開放

#62,502 建立於 2025年8月29日

 (4 則留言) (0 個反應) (1 位負責人)Java (1,246 個分叉)batch import
good first issuetype/enhancement

倉庫指標

星標
 (5,717 顆星)
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.

貢獻者指南