|<- <- -> ->|

Remote execution

Each node has a database with a table named request. Find the total number of requests in all databases.

    [jao@zack]$ osh @jao \
                [ sql 'select count(*) from request' ] ^ \
                agg 0 'total, node, count: total + count' $
    (13,)

agg 0 'total, node, count: total + count': Accumulate total , initializing it to 0 . Each input to agg has (node, count). 'total, node, count: total + count' is the aggregation function.