Aggregate functions are not supported in Kundera

[AntonYudin]

I'm using cassandra 3.11.0 and it looks that aggregate functions are not supported.
A simple query like:
SELECT MAX(field) FROM Table t WHERE id = :value
is translated to CQL by kundera as
SELECT * FROM "Table" WHERE "id" = value
and getSingleResult() returns an Entity object instead of a field.

Are there any plans to add support for standard aggregate functions?

[karthikprasad13]

Hi @AntonYudin

Aggregate queries are not yet supported since there is no native support for aggregations in many NoSQL databases supported by Kundera.

As a workaround, you can use createNativeQuery for running aggregations in Cassandra.

Check this testcase for more info

-Karthik

[AntonYudin]

Thanks for the reply.

It would work if kundera supported setting parameters on native queries.
According to this issue and my own tests, setting parameters on native queries is not supported.

Thanks.

[devender-yadav]

Reference - #983