Hi
   I wanna to use ignite like stream database。

  I wanna to insert some logs like sale log。

  and then ignite can let me create a materialized view to auto upate the count 
number or sum num number 。

  I insert a salelog :(time,vmcode,product)value('2018-03-30 
14:00:00','21321','2123')

 a materialized view "vmSaleCountRealTime" like select 
date(time),vmcode,count(1) todaySaleCount from salelog group by 
date(time),vmcode

  ignite can auto update the todaySaleCount value  of record 
dt=2018-03-20,vmcode=21321

 Is thera have a plan for  materialized view base logs?

发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用

Reply via email to