[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Aggregation of Set Data Type

You will need to use user defined aggregates for this 

Le 23 oct. 2018 16:46, "Joseph Wonesh" <joseph.wonesh@xxxxxxxxxxxxxx> a écrit :
Hello all,

 I am trying to aggregate rows which each contain a column of Set<BIGINT>. I would like the result to contain the sum of all sets, where null would be equivalent to the empty set. I expected a query like: "select sum(my_set_column) from my_table group by my_key_column" to do this, but the set type is not supported by this aggregate. Does anyone know of a way to aggregate this using existing cassandra built-ins? Thanks!

This message is private and confidential. If you have received message in error, please notify us and remove from your system.