average_state
User-defined function.
CREATE OR REPLACE FUNCTION cycling.average_state (
state tuple<int, bigint>,
val int
)
CALLED ON NULL INPUT
RETURNS tuple<int, bigint>
LANGUAGE java AS
$$
if (val != null) {
state.setInt(0, state.getInt(0) + 1);
state.setLong(1, state.getLong(1) + val.intValue());
}
return state;
$$
;
DESCRIBE FUNCTION cycling.average_state;
DROP FUNCTION IF EXISTS cycling.average_state;