hyperdx can't show gauge metrics on large tables

[arnitolog]

HyperDX cannot display metrics (tested with Gauge only) if the table is large.
I have a standard setup:
otel agent -> otel aggregator -> clickhouse -> hyperdx
I've created 2 identical DBs: o11y and otel with the same set of standard clickstack tables.
The difference is only the size:

And now, if I set o11y DB in HyperDX i can see only Sum and Histograms:

even specifying an explicit metric name doesn't work.

But if I switch to otel DB everything works fine - i see a lot of gauge metrics:

So, the question is it is expected and if so, how to deal with large tables?

I'm using HyperDX 2.8.0