Ignite Index - unique or non unique

2018-01-24 Thread Rajesh Kishore
Hi All, Wanted to know - what does ignite supports unique or non -unique index. I have requirement to create non unique index on a field / group of field. Whats the way? Also, with the EXPLAIN plan , we can get to know the index used for a query, sometimes my log is not getting generated

RE: getAll Latency

2018-01-24 Thread rajivgandhi
Sorry - pls delete this thread. I just reviewed our code and the bug is in our code. thank you. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Can writeSynchronizationMode be modified online?

2018-01-24 Thread gunman524
Hi there, A simple question, can writeSynchronizationMode be modified online? As my cache currently in 'full_sync" mode, can it be modified to 'primary_sync' online? like by restful or visor? BTW, the cache I created by DDL CREATE TABLE IF NOT EXISTS person ( id int,orgId LONG, name VARCHAR,

Re: Data lost when primary nodes down.

2018-01-24 Thread rizal123
Hi Denis, Would you mind clarification my statement? I'm a little bit confuse with primary and backup nodes. And where the data is stored. Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: getAll Latency

2018-01-24 Thread rajivgandhi
Hi Stan, Please find the below information. Num Nodes in Production: 7-9 Cache Mode: Partitioned, off heap Atomicity Mode: Transactional Concurrency Mode: Optimistic Isolation Mode: Serializable Please find the stacktrace attached (this is from stage environment). Unfortunately, it is in

Re: Ignite 2.x upgrade guidelines

2018-01-24 Thread bintisepaha
Thanks Evgenii. We will let you know how it goes. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Native persistence

2018-01-24 Thread Humphrey
Hello, I'm trying something out in minikube/minishift with native persistence and scaling. I created persistent volume and a persistence volume claim and have the IGNITE_HOME variable pointed to it. They are bounded correctly. I can see it's making a directory ${IGNITE_HOME}/work/db with

Re: How to use BinaryObject from existing data

2018-01-24 Thread Humphrey
Is it possible to create a table by SQL and then add the QueryEntity (probably when creating the table) so later we are able to search with SqlFieldsQuery property? I mean without creating first a POJO first and defined in the cache configuration. -- Sent from:

Re: How to use BinaryObject from existing data

2018-01-24 Thread ezhuravlev
Hi, In your case, you, most possibly use Id as key, and it could be Long or Int. So, you just need to get it by this key. The example you provided describes the case with complex primary key. Evgenii -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Memory usage by ignite nodes

2018-01-24 Thread dkarachentsev
Hi Ranjit, That metrics should be correct, you also may check [1], because Ignite anyway keeps data in offheap. But if enabled on-heap, it caches entries in java heap. [1] https://apacheignite.readme.io/docs/memory-metrics Thanks! -Dmitry -- Sent from:

RE: getAll Latency

2018-01-24 Thread Stanislav Lukyanov
Hi Rajeev, Generally `getAll` should behave in a more optimized manner, not simply delegate to `get`. If you have a stack trace could you please share it ? It would help to pinpoint the code path that needs to be looked at. Also, can you show some code and tell a bit about your configuration?

Re: Discovery node port range

2018-01-24 Thread Ranjit Sahu
Hi Val, What are the issue you guys have discovered with embededmode deploy ? If we lost nodes in spark, the back up\replication should take care of those is what i am thinking. There is a overhead of rebalancing but how much is that compared to having a stand alone cluster which we may not

Re: Ignite performing slow on cluster.

2018-01-24 Thread Ganesh Sarde
Hi , Following is the java code as requested. sql = INSERT INTO Mon1_0 ( T_ID,kpi4,kpi5,id,kpi2,kpi3,kpi1) VALUES(?,?,?,?,?,?,?) preparedStatement = con.prepareStatement(sql. toString(), ResultSet.

How to use BinaryObject from existing data

2018-01-24 Thread Thomas Isaksen
Hi I have created a table with three columns which I populated using sql. The table is called descriptor and the columns are id,name,description Now I wonder, how can I query this table to get a list of BinaryObjects? In the documentation I found this example: BinaryObject key =