Re: SQL MERGE INTO with SELECT UNION

2020-04-24 Thread Courtney Robinson
Hi Illya, I did end up just doing select then insert/update in the end to work around this. I didn't try selecting over a temp. table though. There are no additional guarantees as far as I know either but there used to be a performance impact. We're migrating functionality from using

Re: Ignite crashes with CorruptedTreeException: "B+Tree is corrupted" on a composite BinaryObject scenario

2020-04-24 Thread Ilya Kasnacheev
Hello! I have added comment to this ticket describing why does it happen and how to fix it. In Ignite, when you get key from your value binary object, it's actually a wrapper pointing at some position in its parent (value) binary object. When you try to put it to cache, indexing cannot process

Re: Unable to initiate IgniteContext in spark-shell

2020-04-24 Thread Ilya Kasnacheev
Hello! Caused by: java.io.InvalidClassException: javax.cache.configuration.MutableConfiguration; local class incompatible: stream classdesc serialVersionUID = 201405, local class serialVersionUID = 201306200821 I think this is caused by different versions of jcache dependency on your nodes. One

Re: How can I delete entries from a table using pyignite?

2020-04-24 Thread Ilya Kasnacheev
Hello! If there are any images, we never got to see these. Can you link them on some external resource? Thanks, -- Ilya Kasnacheev пн, 20 апр. 2020 г. в 18:25, Jueverhard : > I have a Apache Ignite database running which I want to interact with using > Python thin client (pyignite). I've

Re: How to clear table data quickly?

2020-04-24 Thread Ilya Kasnacheev
Hello! You can do cache.clear() or you can drop and create table (or cache). I'm not sure what will be faster. It depends, since the latter will cause a Partition Map Exchange, while former will be executed entirely in background. Regards, -- Ilya Kasnacheev вт, 21 апр. 2020 г. в 05:39,

Re: EPOCH seconds in future!

2020-04-24 Thread Ilya Kasnacheev
Hello again! I guess that EPOCH is calculated relative to current time zone, not UTC. This means you will have to adjust it: ~/Downloads/apache-ignite-2.8.0-bin% date Пт апр 24 18:16:55 MSK 2020 ~/Downloads/apache-ignite-2.8.0-bin% bin/sqlline.sh sqlline version 1.3.0 sqlline> !connect

Re: EPOCH seconds in future!

2020-04-24 Thread Ilya Kasnacheev
Hello! I guess that EPOCH() returns -- Ilya Kasnacheev пт, 17 апр. 2020 г. в 12:07, dbutkovic : > Hi, > Ignite function EXTRACT (EPOCH from CURRENT_TIMESTAMP(3)) return seconds in > future!!! > > > Current date and time on UNIX host, I am in Zagreb/Croatia CEST GMT+2 > > [root@incumbossdev01

Re: EPOCH to timestamp

2020-04-24 Thread Ilya Kasnacheev
Hello! I came across this solution: select dateadd('s', 1587750989, '1970-01-01 00:00:00 UTC'); https://stackoverflow.com/questions/31804762/how-to-convert-timestamp-to-seconds-in-h2 Regards, -- Ilya Kasnacheev пт, 17 апр. 2020 г. в 10:06, dbutkovic : > Hi, > is there a function with which

Re: Multicast Address

2020-04-24 Thread Evgenii Zhuravlev
Hi, Server nodes should be able to communicate with each other directly, for example, for rebalancing purpose or sending current partition distribution. So, if they're able to directly communicate with each other, you can either configure all their static Ips(not necessary for Multicast Ip

Re: Unable to run several ContinuousQuery-es in parallel due to: Failed to unmarshal discovery data for component: CONTINUOUS_PROC

2020-04-24 Thread Ilya Kasnacheev
Hello! I remember this question on Stack Overflow, and the situation was, your callback was binding IgniteCache within its context. It is recommended to make your CQ callbacks inner static classes (not lambdas or anonymous inner classes). Regards, -- Ilya Kasnacheev чт, 16 апр. 2020 г. в

Re: Regarding EVT_NODE_SEGMENTED event

2020-04-24 Thread Ilya Kasnacheev
Hello! You can probably set clientReconnectDisabled to 'true' to generate this event on client. Regards, -- Ilya Kasnacheev вт, 21 апр. 2020 г. в 13:35, VeenaMithare : > Thanks Monal, > > What is the best way to generate a EVT_NODE_SEGMENTED event on the client > side for testing the event

Re: SQL queries returning incorrect results during High Load on Ignite V2.7.6

2020-04-24 Thread Ilya Kasnacheev
Hello! I've not heard of issues such as this one. It would help if you have a reproducer (one which creates a lot of load and detects cases like these). Regards, -- Ilya Kasnacheev вт, 21 апр. 2020 г. в 14:39, neerajarora100 : > > I have a table in which during the performance runs, there

Re: Enabling default persistence on existing ignite cluster

2020-04-24 Thread Ilya Kasnacheev
Hello! Have you tried supplying different group name in CollectionsConfiguration when creating a Queue? Regards, -- Ilya Kasnacheev ср, 22 апр. 2020 г. в 11:09, Sebastian Sindelar < sebastian.sinde...@nexus-ips.de>: > Hallo. > > Our application uses ignite to share data between different

Re: General error: "java.lang.ArrayIndexOutOfBoundsException: 32768"

2020-04-24 Thread Ilya Kasnacheev
Hello! I think you need to figure out how to reproduce it if we are to fix it. I have found one ticket somewhat similar to your issue: https://issues.apache.org/jira/browse/IGNITE-10501 Regards, -- Ilya Kasnacheev пт, 24 апр. 2020 г. в 15:12, 张立鑫 : > Full new node is not have work

Re: General error: "java.lang.ArrayIndexOutOfBoundsException: 32768"

2020-04-24 Thread 张立鑫
Full new node is not have work directory. I don't know reproduce this behavior, but i used `ContinuousQuery` `SqlQuery` `Sql update` and `put value` frequently on service at the same time. B+Tree is updated frequently? Ilya Kasnacheev 于2020年4月24日周五 下午7:57写道: > Hello! > > What do you mean by

Re: Inconsistency in data stored via the Redis layer

2020-04-24 Thread Ilya Kasnacheev
Hello! My recommendation is to use REST API instead of redis/memcached. Regards, -- Ilya Kasnacheev пт, 24 апр. 2020 г. в 12:08, scriptnull : > Hi, > > We are trying to use Apache Ignite via the Redis layer ( > https://apacheignite.readme.io/docs/redis ). While trying to store a > string >

Re: General error: "java.lang.ArrayIndexOutOfBoundsException: 32768"

2020-04-24 Thread Ilya Kasnacheev
Hello! What do you mean by 'full new node'? Do you know steps to reproduce this behavior? Regards, -- Ilya Kasnacheev ср, 22 апр. 2020 г. в 19:37, 张立鑫 : > Hello, > Thanks for your proposal, but i get this error for every full new node. I > can't do the next things. > > Regards > > Ilya

Re: SQL MERGE INTO with SELECT UNION

2020-04-24 Thread Ilya Kasnacheev
Hello! I think you can union a select over a temporary table of one row. such as select * from table (id bigint = ?, ...) However, maybe you should just re-write your upsert with select and then insert/update. You're not gaining any more guarantees by using MERGE, as far as I know. Regards,

Inconsistency in data stored via the Redis layer

2020-04-24 Thread scriptnull
Hi, We are trying to use Apache Ignite via the Redis layer ( https://apacheignite.readme.io/docs/redis ). While trying to store a string from a ruby redis client and retrieving back, we notice some inconsistency in the data. We believe that this has something to do with how Apache Ignite handles

Multicast Address

2020-04-24 Thread bribridnl
Hey guys, I have a very specific use case where raspberry pis are connected in a ring topology and I have a docker service running apache ignite. Now I want them to be running the same distributed database but I don't know what multicast adress to use in the config.xml file. For now each rpi has a