Missing aggregation type "COUNT" of ZUNIONSTORE

[ts-thomas]

I couldn't find a way how to properly stack up the count of union matches to the calculation.

This is what I theoretically need:

// a set of keys
keys = [ .... ];
// initial weights to 1
weights = [ 1, 1, 1, ....];

// store union with COUNT as the new score
redis.zUnionStore(dest, keys, { AGGREGATE: "COUNT" });

// push the destination to the keys
keys.push(dest);
// add some high value to the weights to prefer the
// ordering based on count over the sum of score
weights.push(999);

// calculate final results with the right ordering
redis.zUnionStore(dest, keys, { WEIGHTS: weights, AGGREGATE: "SUM" });

In SQL something simliar is ORDER BY count DESC, score DESC

Is there a chance to add such functionality to the library? Thanks in advance

[dwdougherty]

Hi @ts-thomas. I suggest you ask your question on the Redis Discord channel. You might get some creative ideas of how to accomplish this in the absence of this feature. Alternatively, you can raise an issue on the Redis repo itself.

[ts-thomas]

@dwdougherty Thanks a lot for the quick response. The Discord was a nice hint 👍