Re: Is apache ignite suitable for sql querying on ignite cache?

2022-05-09 Thread Stephen Darlington
The JDBC connector maps columns in the underlying datasource to Ignite. You don’t have to map all the columns if you don’t want to. You can also choose to pre-load only some records (see the loadCache method). If you want to denormalise the data on the way into Ignite there are a couple of opti

RE: Re[2]: Is apache ignite suitable for sql querying on ignite cache?

2022-05-09 Thread Reshma Bochare
Hi Zhenya, Thanks for replying. It was not actually typo. We are thinking to start stand-alone servers of 32 GB and then if more memory is required it will store onto the disk hence I said persistence mode enabled Will it work in this way? Thanks, Reshma. From: Zhenya Stanilovsky Sent: Thur

RE: Re: Is apache ignite suitable for sql querying on ignite cache?

2022-05-09 Thread Reshma Bochare
Thanks Stephen for valuable feedback. I went through the link. I read below line on the link you can store objects as a set of fields and can configure the mapping between table columns and objects fields via the configuration I am not copying the entire oracle table as it is. As we are into re

Re: Unable to remove cache key entries after Ignite server restart

2022-05-09 Thread Sumit Deshinge
Hi Maxim, Thank you for your reply. 1. Read-Repair - I am using cache write sync mode FULL_SYNC and cache rebalance mode as SYNC along with REPLICATED cache mode. So read repair may not work in this case, right ? 2. Also I verified partition checksum and the result was no conflicts found. Even cac