cuike wrote > Thank you ,I understand what you mean. > > I want to store data day by day，like Time Series DataBase. > My data is very big, so a day store today's data. > When I want data of a week, I should use like sql 'select * from > table_201208024 union select * from table_201208025,...' > > Thank you again,It works: > https://github.com/sdcuike/Ignite-2015/blob/master/src/main/java/com/doctor/ignite/example/spring/SqlUnion.java
Your approach will also work, but you actually do not need separate caches for this. I would just add an indexed timestamp field and query by the required timeframe. This looks more flexible, because what if you need data for some part of the day only? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-can-query-data-from-multiple-caches-like-sql-UNION-tp1082p1112.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
