Re: Exception when Ignite server starts up and also when a new node joins the cluster

Jaipal, I'm also getting same issue. Were you able to find a solution for this? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Exception-when-Ignite-server-starts-up-and-also-when-a-new-node-joins-the-cluster-tp13684p15156.html Sent from the Apache Ignite Users

Custom SQL Functions

Hello, I have a couple of questions on custom SQL functions: 1) Can functions be overloaded, ie. could there be a to_string( Date) and a to_string( Double) function? 2) If yes, how is the applicable function identified? Based on parameters? Or does the function need to be qualified with the

write behind problems

Hi: As the updated data is more than 50,so I set write behind parameters to true with java code . but it did not work .It's still wait until all data is persisted. When I debug the code ,I found my cache's cacheconfiguration is correctly set to true; the setting is:

Re: Re: Did Ignite query support embed DML ?

Thanks Val, This A is the parent table, B is children table, we want to SUM the value in B table and set back to the A. they join by the id, possible data like this A: id, total abc, 0 xyz, 1 B: id, count abc, 1 abc, 2 abc, 5 xyz, 3 xyz, 1 Thanks for your time! Regards Aaron

Re: Re: How does node vistor task can work?

Got very appreciate, thanks Mikhail! Regards Aaron aa...@tophold.com From: mcherkasov Date: 2017-07-19 22:29 To: user Subject: Re: How does node vistor task can work? Hi Arron, you use internal classes that isn't part of public api, please read this article:

Re:Re: encountering a character encoding problem when DML SQL is used

I called it from Java, and i am using Ignite 2.0. seems many chinese developer are encountering this problem. is there any configuration that can set as encoding? or is there any API method can do this? thanks, Martin At 2017-07-20 00:34:45, "afedotov"

Re: Inserting Data From Spark to Ignite

One problem is that peer class loading did not match between the server and the client (being started inside the Spark container). That required a change in the server start up configuration because the spark client starts with a default of "true". It was a needle in the haystack that I found

Data loss validation. TopologyValidator

Hi, Whats the best way to check to see if the cache data is lost (partially) ? I was looking at 'Topology Validator' as an option. Scenario : If there any multiple node failures occurred at the same time and ignite loses primary and as well as backup copies of partitions and how to know if this

Re: Did Ignite query support embed DML ?

You don't have table A in the subquery, I guess that's the reason for the failure. What exactly are you trying to achieve with this query? What is the purpose of 'WHERE b.id = a.id' clause? -Val -- View this message in context:

Re: same cache cannot update twice in one transaction

Your code works for me. What exactly do you mean by 'not working'? And btw, you should ALWAYS call Transaction#close() in the finally block after transaction is finished. Your current code cause unfinished transactions and hangs. -Val -- View this message in context:

Re: Issue with Ignite + Zeppelin

It looks like you didn't add Ignite libraries to Zeppelin. IgniteJdbcDriver is included in ignite-core.jar and this JAR has to be on classpath. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-Ignite-Zeppelin-tp14990p15144.html Sent from the

Re: Large value of idleConnectionTimeout in TcpCommunicationSpi

Amit, Default idle timeout is actually 10 minutes. Therefore connection will be closed only it is not used for at least 10 minutes, not 30 seconds. Are you sure that delay is caused by reopening a closed connection? If yes, are you sure it's caused by idle timeout? Answering your questions: 1.

Re: Enforcing data to be stored in Heap only

Hi Amit, Primary data storage in 2.0 is off-heap and it always has all the in-memory data. You can have additional on-heap cache, but its generally limited and it duplicates the off-heap data. Why don't you want to use off-heap? -Val -- View this message in context:

Enforcing data to be stored in Heap only

Hello Everyone, I am using Ignite 2.0 and want to use heap to cache my data. I have enabled it through the api setOnheapCacheEnabled provided in the CacheConfiguration. Let's say I have a total RAM size of 12 GB. I have set both Xms and Xmx to 8 GB while starting the Ignite server. The reason I

Re: Ignite 2.1?

Keep an eye on the voting threads named like this one "[VOTE] Apache Ignite 2.1.0 RC2”. One the vote is passed and all the issues are resolved the release is to be rolled out. In any case, an announcement will be sent to the @dev list as well. — Denis > On Jul 19, 2017, at 10:26 AM, Muthu

Re: SQL Syntax error in cross-cache query

Bob, Original query is wrong for sure. \\\" means that you actually have a slash in SQL string which is obviously wrong. As for the second error, it looks like a misconfiguration. Please provide more information on what exactly you did, your configuration, etc. -Val -- View this message in

Large value of idleConnectionTimeout in TcpCommunicationSpi

Hello Everyone, One of our cache access pattern is that it is accessed beyond an interval of 30 seconds (which is the default connection timeout). Every time it happens the first call to the cache takes a long time to fetch the results. I am planning to increase the idleConnectionTimeout to a

Re: Ignite 2.1?

Thanks Vyacheslav!..i am looking forward to it. Regards, Muthu -- The real danger with modern technology isn't that machines will begin to think like people, but that people will begin to think like machines. -- Faith is to believe what you do not see; the reward of this faith is to see what you

Re: Ignite client not seeing cache created by server

Hi Maureen, Make sure that at cfg.setIndexedTypes(GeoCoordinate.class, SurveyImage.class) you are specifying key-value pairs for each type you want to register. I mean it should be cfg.setIndexedTypes(SomeGeoCoordinateKey.class, GeoCoordinate.class, SomeSurveyImageKey.class, SurveyImage.class)

Re: Multi Cloud Deployment Issue

HI Mikhail, Thanks for the response. I am aware that the data center replication/HA is available in the paid version of Ignite. At this point, I don't have the option to go for it. What I am trying instead is to minimize my risk by distributing the data between different clouds not necessarily

Re: encountering a character encoding problem when DML SQL is used

Hi Martin, I've checked the same with 2.0 and it works on my side. Which version of Ignite do you use? Do you call it from Java, .NET or C++ ? Please check that source files encoding is consistent. It's better to stick with UTF-8. Kind regards, Alex. On Wed, Jul 19, 2017 at 4:47 AM, Martin

Re: Ignite2.0 Affinity Key Distribution

Hi Ajay, you question isn't fully correct,in both questions we should talk about affinity key, if you don't define affinity key, normal key is affinity key. for simplicity I can say yes: all key/object pairs will be distributed equally, at least for big amount of data with good key's hashcode.

Re: Ignite2.0 Affinity Key Distribution

Hi, Keys are distributed among partitions according to affinity function. Partitions are distributed among nodes according to affinity function. This chain "key->partition->node" is designed to simplify data exchange between nodes on topology changing and due to performance reasons.

Re: Ignite client not seeing cache created by server

Hi Maureen, Could you please share a reproduce for this as pom based project? Thanks, Mikhail. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-client-not-seeing-cache-created-by-server-tp15070p15130.html Sent from the Apache Ignite Users mailing list

Re: Ignite Cache Console

You can use visor command utility. It is available @ ignite_install/bin/ignite visor.sh and your configuration xml should be @ ignite_install/config folder. On 19 Jul 2017 20:17, "Ajay [via Apache Ignite Users]" < ml+s70518n15125...@n6.nabble.com> wrote: > Hi, > > Can we see the cache resides in

Re: Ignite Cache Console

https://apacheignite.readme.io/docs/getting-started#ignite-visor-admin-console On Wed, Jul 19, 2017 at 4:47 PM, Ajay wrote: > Hi, > > Can we see the cache resides in ignite cluster with any console or tool > etc. > ? > > Thanks, > Ajay. > > > > -- > View this message in

Problem with Messages after client reconnect

Hi. I just started with Ignite messaging and I encountered the following problem: I have a simple Setup with 1 server and 1 client. Sending messages from the client to the server works fine. But after a server restart I encounter the problem that when I send a message with a custom class I get

Re: Multi Cloud Deployment Issue

Hi Amit, it's expected penalty, ignite is cluster solution that requires fast and reliable network. Do you need share data between data centers for HA? if so, you can implement your own data center replication: install listener for cache changes, batch data and send them to remote data center,

Ignite Cache Console

Hi, Can we see the cache resides in ignite cluster with any console or tool etc. ? Thanks, Ajay. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-Cache-Console-tp15125.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How does node vistor task can work?

Hi Arron, you use internal classes that isn't part of public api, please read this article: https://apacheignite.readme.io/docs/memory-and-cache-metrics it explains how to get memory and cache metrics. Thanks, Mikhail. -- View this message in context:

Ignite2.0 Affinity Key Distribution

Hi, I want to know scenarios, 1)I have 10 affinity keys like 1-10 suppose when i load this keys between two servers(2 nodes) it will equally distribute or randomly distribute? 2)I have 10 normal keys like 1-10 suppose when i load this keys between two servers(2 nodes) it will equally distribute

Re: Re: How does node vistor task can work?

got thanks!!! aa...@tophold.com From: ezhuravlev Date: 2017-07-19 21:21 To: user Subject: Re: How does node vistor task can work? You don't need to use Visor tasks to get statistics. Try this: ignite.cluster().metrics() or ignite.cluster().node(node).metrics() Evgeniii -- View

Re: How does node vistor task can work?

You don't need to use Visor tasks to get statistics. Try this: ignite.cluster().metrics() or ignite.cluster().node(node).metrics() Evgeniii -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-does-node-vistor-task-can-work-tp15095p15121.html Sent from the

Did Ignite query support embed DML ?

hi All, Will Ignite support Embed SUM DML Like this SQL updates: UPDATE A a SET a.total=( SELECT SUM(b.cnt) FROM B b WHERE b.id = a.id ) Always throw a fail to parse SQL query exception . aa...@tophold.com

Re: Question about QueryTextField

Yeah, it's clear now. You can use query syntax from Apache Lucene: https://lucene.apache.org/core/2_9_4/queryparsersyntax.html Name of the field, in this case, should be in uppercase. For example: "A:query" Evgenii 2017-07-19 12:01 GMT+03:00 iostream : > I know how to

Re: SQL Syntax error in cross-cache query

Hi, You need either adjust entity/table name to the upper case like *select ID from "personCache".PERSON p limit 5* or add a config option , in this case you will be able to perform the query in the following way *select \"id\" from \"personCache\".\"Person\" p limit 5* (note the escaping is

Re: Ignite client not seeing cache created by server

Hi, Now i can see the cache and see the objects created in it using cache.iterator(). I would like to use a query to search the cache, so i have set indexed types on the cache configuration. Server configuration: public void initCache() { Ignite ignite =

Re: CLUSTER GET HANGED SUDDENLY

Hi Varunkumar, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. Could you please try to reproduce the issue on

Re: SQL Syntax error in cross-cache query

thank afedotov. personCache definition in this xml file.

Re: Question about QueryTextField

I know how to use @QueryTextField (as can be seen in my example). When I perform a TextQuery it scans on all fields that I have used the annotation on. I want the TextQuery to run only on one field and not on all fields in my cache object. Is my question clear? -- View this message in

Re: Question about QueryTextField

Hi, As it said in JavaDoc, you can use @QueryTextField as annotation on fields Evgenii 2017-07-19 11:46 GMT+03:00 iostream : > Hi, > > Instead of performing a text query on the entire cache object as mentioned > here

Question about QueryTextField

Hi, Instead of performing a text query on the entire cache object as mentioned here (https://apacheignite.readme.io/v2.0/docs/cache-queries#text-queries), can I perform a text query on a single attribute in my cache value object? Example - public class my_object { @QuerySqlField(index =

Re: SQL Syntax error in cross-cache query

Could you please share your cache config or the full Ignite config, which is better. Kind regards, Alex 19 июля 2017 г. 11:03 AM пользователь "howfree [via Apache Ignite Users]" < ml+s70518n15109...@n6.nabble.com> написал: > Yes. > It came up with the error: Schema "PERSONCACHE" not found. > I

Re: SQL Syntax error in cross-cache query

Yes. It came up with the error: Schema "PERSONCACHE" not found. I guess it means the schema in H2 database. but this cache should be different from it. right? -- View this message in context:

Re: same cache cannot update twice in one transaction

Hi，Mikhail 　　I am the first time to mail-list,thanks for your suggestion. I had upload demo project, it is seem the problem is cache after update,requery cache with return the old value, not the update dirty data. IgniteDemoV2-log4j.zip

Re: SQL Syntax error in cross-cache query

Have you tried without any quotation? Kind regards, Alex 19 июля 2017 г. 9:16 AM пользователь "howfree [via Apache Ignite Users]" < ml+s70518n15102...@n6.nabble.com> написал: The following error came up: Schema "PERSONCACHE" not found. The style \"personCache\" can be separated from the Schema

Re: Ignite 2.1?

As far as I know, It will be shortly after the end of the vote. [1] Of course only in case of vote success. Vote started yesterday, and must finish tomorrow. Let's hope to see the new release by the end of this week. [1]

Ignite 2.1?

Folks, Any one knows when 2.1 would be coming out? As per this, the release date is July 17th...this past Monday, https://cwiki.apache.org/confluence/display/IGNITE/Apache+Ignite+2.1 Regards, Muthu -- The real danger with modern technology isn't that machines will begin to think like people,

Re: SQL Syntax error in cross-cache query

The following error came up:Schema "PERSONCACHE" not found.The style \"personCache\" can be separated from the Schema "personCache" in H2. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Syntax-error-in-cross-cache-query-tp15097p15102.html Sent from the

Re: SQL Syntax error in cross-cache query

Hi, Looks like you have wrong schema name. Please adjust \\\"personCache\\\" to \"personCache\". Kind regards, Alex 19 июля 2017 г. 8:25 AM пользователь "howfree [via Apache Ignite Users]" < ml+s70518n15097...@n6.nabble.com> написал: In ignite 2.0: when I ran those codes: SqlFieldsQuery sql =