发布

  • [CUST-4702] [BE] Improve experiment queries (#4811)

    frostbyte_neo 发布于 2026-01-22 16:11:24 +00:00

    • [CUST-4702] [BE] Improve experiment queries

    • Remove guardrails join when not necessary

    • Fix part 2

    • Fix

    • Revision 2: Address PR review comments on ClickHouse query optimization

    • DatasetItemDAO: Use full primary key in ORDER BY clause for dataset items query
    • TraceDAO: Remove unnecessary FINAL from spans subqueries
    • DatasetsResourceTest: Fix tests to match new ordering with ClickHouse enum comparator
    • Revision 3: Fix NULL handling in test comparator to match ClickHouse ORDER BY DESC

    ClickHouse treats NULL as largest value in DESC order (NULLs come first),
    so we need to use nullsFirst with reverseOrder in the Java comparator.

    • Fix tests
    下载附件