Skip to Content
1
Jun 29, 2020 at 06:31 PM

Simple Count aggregation on CAP's CQL

1122 Views

Hi,

I'm trying to build a simple select. It would be something like this:

select <one_field, count(<one_field>) from aTable group by <one_field>

Quite simple, huh? But unfortunately it looks like count, sum, max and so on are not supported in CQL. Or maybe I wasn't able to find a way to do it.

Will I have to do all the calculations in the events? Or there is a way to ask Hana to do the "hard job" (not a big deal for Hana, anyway)?

Thanks in advance for your help,

David R.