Getting a list of values using lua and aerospike aql

lua
aql

#1

Hello,

I have the following set in aerospike:

INSERT INTO test.set (PK,DAY_OF_MONTH,YEAR,value) VALUES (1,2,2017,10)
INSERT INTO test.set (PK,DAY_OF_MONTH,YEAR,value) VALUES (2,2,2017,11)
INSERT INTO test.set (PK,DAY_OF_MONTH,YEAR,value) VALUES (3,3,2017,12)
INSERT INTO test.set (PK,DAY_OF_MONTH,YEAR,value) VALUES (4,3,2017,13)

I’m new in aerospike and for the moment I just know how to retrieve a single value in LUA, but I would like to know how to retrieve and make groups of values.

For instance, I would like to know how could I return a result like the following in aql:

  AGGREGATE test.someFunction() ON test.set

    +------+--------------+------+
    | YEAR | DAY_OF_MONTH | SUMA |
    +------+--------------+------+
    | 2017 | 2            | 21   | 
    | 2017 | 3            | 25   |
    +------+--------------+------+