Hi, Try to set Lazy flag for SQL query [1].
[1] https://apacheignite-sql.readme.io/docs/performance-and-debugging#result-set-lazy-load On Tue, Jun 19, 2018 at 8:06 PM bhaskar <[email protected]> wrote: > Hi, > I have Ignite 5 node cluster with more than dozen tables(Cache) . Our > client > are using SQL and Tableau. The node goes down when any client quries select > * from table which is bigger than RAM size. > we have 3 years data but last 2 months data is actively quried 80% of time. > > 1. How can I control such SQL when the rows are more than RAM size? > 2. We have to control on the node not client as we can't conrol client. > > Thanks > Bhaskar > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > -- Best regards, Andrey V. Mashenkov
