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.