esper 附录A

复制代码
A2
select irstream symbol, volume, price from MarketDate.win.time(5.5 sec)
select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output every 1 seconds
select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output last every 1 seconds
select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output first every 1 seconds
select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output snapshot every 1 seconds

A3
select irstream sum(price) from MarketDate.win.time(5.5 sec)
select irstream sum(price) from MarketDate.win.time(5.5 sec) output every 1 seconds
select irstream sum(price) from MarketDate.win.time(5.5 sec) output last every 1 seconds
select irstream sum(price) from MarketDate.win.time(5.5 sec) output first every 1 seconds
select irstream sum(price) from MarketDate.win.time(5.5 sec) output snapshot every 1 seconds

A4
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec)
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output every 1 seconds
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output last every 1 seconds
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output first every 1 seconds
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output snapshot every 1 seconds

A5
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol order by symbol
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output every 1 seconds
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output all every 1 seconds order by symbol
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output last every 1 seconds order by symbol 
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output first every 1 seconds
select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output snapshot every 1 seconds order by symbol

A6
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol 
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output every 1 seconds
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output all every 1 seconds order by symbol
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output last every 1 seconds order by symbol
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output first every 1 seconds 
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output snapshot every 1 seconds 

A7
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) 
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output every 1 seconds
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output all every 1 seconds
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output last every 1 seconds
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output first every 1 seconds
select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output snapshot every 1 seconds
复制代码

 

posted @   穿林度水  阅读(282)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示