sql query large data set which is larger than memory

2016-07-11 Thread November
Hi I have a large data set larger than memory. I want to do some sql operation on it. So I enabled swap space. But the program still run out of memory. Below is my cache configuration code. Is there any thing wrong? Thanks var cache = ignite.GetOrCreateCache(new CacheConfiguration

Create cache configuration error

2016-07-11 Thread deleerhai
Hi, Create cache configuration error. 七月 12, 2016 10:13:19 上午 org.apache.catalina.core.ApplicationContext log 严重: StandardWrapper.Throwable javax.cache.CacheExcept

Issue with concurrent users on Ignite 1.6.0 ODBC

2016-07-11 Thread Agneeswaran
Hi Team, We are running the script with 16 users concurrently on Ignite ODBC node. Some of the user processors are interrupted and stopped in between.And also this issue happens even with 2 user concurrent test. The same scenario works with Ignite 1.5.0. Please suggest, do we need to modify any

Re: CassandraCacheStoreFactory injection error while trying to use Cassandra as persistent store

2016-07-11 Thread ghughal
I converted my config to XML and still getting same error ("Failed to get Cassandra DataSource cause Spring application context wasn't injected into CassandraCacheStoreFactory"). I looked at SpringApplicationContextResource documentation and it's supposed to be used within instance of following cl

Re: CassandraCacheStoreFactory injection error while trying to use Cassandra as persistent store

2016-07-11 Thread ghughal
It looks like I'll have to convert all Ignite and cache configuration to XML. Just putting cassandra config in XML doesn't seem to work. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/CassandraCacheStoreFactory-injection-error-while-trying-to-use-Cassandra-as-

Update performance

2016-07-11 Thread ionut_s
Hi, I would like to understand which is the best solution to simulate a transactional "update x where y" logic. >From what I understand the transaction coordinator has to know all the modified rows. Is there a way to avoid that and have the entire logic (reading filtered data + updates) locally

Re: Performance issue on Ignite ODBC API

2016-07-11 Thread Igor Sapego
Hi Agneeswaran, Thats a great thing to hear. I'm going to change the default value to something more appropriate. Let us know if there are any other issues you are facing. Best Regards, Igor On Mon, Jul 11, 2016 at 8:53 PM, Agneeswaran < agneeswaran.ponnuraman...@nielsen.com> wrote: > Hi Igor

Re: Performance issue on Ignite ODBC API

2016-07-11 Thread Agneeswaran
Hi Igor, The solution works perfectly fine.It completes in ~12 seconds ( before ~4 minutes ). Thanks for your support. With regards, Agneeswaran -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Performance-issue-on-Ignite-ODBC-API-tp5908p6212.html Sent from the

Re: Cache Partitioned Mode

2016-07-11 Thread daniels
-"it will load it from the cache store, puts into memory and returns for the client. " It means that load occurrs on server node by server node loader (and not by client node loader)and then puts in memory on server side and returns for client. Doesnt it? -- View this message in context: ht

Re: Cassandra Cache Store Example

2016-07-11 Thread Denis Magda
Hi Kamal, Please create a ticket in JIRA for that and share a link to it over there. Hope that someone from the community will pick it up and implement. If you’re interested in this kind of contribution then it would be perfect. — Denis > On Jul 11, 2016, at 3:05 PM, Kamal C wrote: > > Hi, >

Performance in case of 1 server node

2016-07-11 Thread daniels
Hi , I have one server node (embedded Ignite). My ignite and cache configurations is bellow, please help me to add or remove configs for better performance P.S. I read Performan

Cassandra Cache Store Example

2016-07-11 Thread Kamal C
Hi, Can anyone add Cassandra CacheStore example in the examples[1] like JDBC CacheStore example? It will be useful to configure and test the feature quickly. [1]: https://github.com/apache/ignite/tree/master/examples/src/main/java/org/apache/ignite/examples/datagrid/store --Kamal

Re: How to stop a IgniteService gracefully?

2016-07-11 Thread Kamal C
When a node which provides the service have high CPU and heap memory usage. Can I switch the service from that node to the other eligible node ? On Mon, Jul 11, 2016 at 4:40 PM, Vladislav Pyatkov wrote: > Hello Kamal, > > - How to tell Ignite to move a clustered singleton service from one node

Re: How to stop a IgniteService gracefully?

2016-07-11 Thread Vladislav Pyatkov
Hello Kamal, - How to tell Ignite to move a clustered singleton service from one node to another with external scripts? What are you mean when say: "move a clustered singleton service from one node to another"? If singleton service was deployed on cluster group, it will stay until, last node lea

Re: Cache Partitioned Mode

2016-07-11 Thread Denis Magda
Hi, When the client executes a query like cache.get(key1) the request will be directed to a server node that holds a value for key1. If key1 is missing in the memory on the server side then it will load it from the cache store, puts into memory and returns for the client. — Denis > On Jul 11,