How I can SUM column with condition?

45 views
Skip to first unread message

Marek

unread,
Oct 15, 2014, 7:13:37 AM10/15/14
to hyperdex...@googlegroups.com
Hi,

I want to SUM one column value between all objects that match the specified checks. SQL example:

SELECT SUM(column_name) FROM table WHERE year = 2014

My HyperDex database is huge and I don't want receive all objects (from year = 2014) and increment value in loop (in memory on client-side). I want get one long-integer value. It is possible to solve this issue in HyperDex (on server-side)?

李俊良

unread,
Feb 21, 2016, 11:38:39 PM2/21/16
to hyperdex-discuss
some patch could use sum one column

git commit : 8d8ca6781cdfa6b72869c466caa32f076576c43d

在 2014年10月15日星期三 UTC+8下午7:13:37,Marek写道:
0001-Add-function-and-Fixed-some-question.patch

李俊良

unread,
Feb 22, 2016, 3:51:44 AM2/22/16
to hyperdex-discuss
add missing files

在 2016年2月22日星期一 UTC+8下午12:38:39,李俊良写道:
0002-patch-java-and-python-interface.patch
Reply all
Reply to author
Forward
0 new messages