2 ms·
Not exciting. Most of the array processing / streaming facilities are steaming piles. You have Hadoop/MR and Monet in the OSS group. SysbaseIQ, KDB, Teradata,
by jnordwick 10y ago
Not exciting. Most of the array processing / streaming facilities are steaming piles.
You have Hadoop/MR and Monet in the OSS group. SysbaseIQ, KDB, Teradata, Vertica, VectorWise, etc. all provide either extended SQL or additional query support to use ordering information in some (often weak) way.
You can even count Oracle In Memory Analytics with TSQL with its cursor model if you really want.
For example for KDB to get the last price and sum of volumer for each second of AAPL you would do in KSQL:
select last px, sum vol by time.second from trade where sym=`AAPL
on it can be done in its lower level language K/Q as (approx, I'm a little rusty)
g:group trade.time.second @ where trade.sym=`AAPL
flip`px`vol!(last each trade.px g; sum each trade.vol g)