max size of Ignite cache (not memory size, i mean max amount of records)

hi Igniter, Is there a max limit for the amount of records in one cache? (is it Integer.MAX_VALUE?) what will happen when a cache reaches the max limit and we keep adding data into it? Thanks, Jeff -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Does Merge statement (DML) work with JDBC client driver

Hi We are using Ignite 2.3 We would like to have 2 Ignite clusters running - one with Ignite native persistence and second with Oracle database as persistent layer. So keeping this in mind, we would like to the build our code base which should work for both the clusters. I have read that ignite

Re: Ignite with dBeaver

Hi Wilhem, I have also been evaluating Ignite, and also followed the steps in setting up SQL tooling with DBeaver... At that final step, when you choose a driver class - I had a choice (from a pulldown list, I think) between the two classes. You can then select the Thin version for simple local c

Re: Ignite with dBeaver

Dbeaver works just fine. Or, you can even build Ignite-web-console. Regards, Neeraj > On 7 Mar 2018, at 05:53, Wilhelm Thomas wrote: > > Hello, > > I’m evaluating ignite and I need a free tool to see the tables and cache > content. > What is the best free tool to query the cache via SQL? So

Re: How to configure a cluster as a persistent, replicated SQL database

Hi Naveen, I managed to get everything up a and running...but for my testing, I have not been connecting from code. I have been using DBeaver to connect using SQL via the JDBC driver(s). Jose -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: Is ML a part of the Ignite.C# API? eom

… the reason I ask being that ML is included in the Ignite diagram in the Ignite.C# documentation page, but there is no documentation section for it. *From:* Raymond Wilson [mailto:raymond_wil...@trimble.com] *Sent:* Wednesday, March 7, 2018 3:55 PM *To:* user@ignite.apache.org *Cc:* 'd...@ignit

Re: Ignite readme.io - documentation export (pdf, etc)?

hello Prachi, thanks for the response. Yes, it would work for me now. Is the documentation for Apache Ignite 2.4 finalized already? If it's true - could you please prepare *.md export for this version? If not - I'd like to wait a bit when it's ready... Thank you in advance! -- Sent from: htt

Re: Ignite with dBeaver

Hello, I’m evaluating ignite and I need a free tool to see the tables and cache content. What is the best free tool to query the cache via SQL? Something like dBeaver or anything else that works. Thanks for your help w From: Wilhelm Thomas Reply-To: "user@ignite.apache.org" Date: Tuesday, M

Re: SELECT Statement cancellation & memory sizing

Also AFAIK, visor is very inaccurate on offheap memory measurements. at least it used to be -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SELECT Statement cancellation & memory sizing

ignite is not optimized for count queries. it visits each object to do the count and doesn't do the count off of an index (or some cached store). seems kind of silly, especially if you have a count on indexed fields. i think query cancellation only works within the API. I think you can either s

Ignite with dBeaver

Hello, I’m trying to connect to the ignite cache via dBeaver. It seems to connect (client ui display a green signal) but I see the following error on the screen of the server [00:44:26] Unknown connection detected (is some other software connecting to this Ignite port? missing SSL configura

Re: Ignite readme.io - documentation export (pdf, etc)?

Readme.io does not provide PDFs. I can provide you with .md files. Would that work? On Tue, Mar 6, 2018 at 9:36 AM, Stanislav Lukyanov wrote: > Hi Prachi, > > > > Any chance you can help with that? > > > > Thanks, > > Stan > > > > *From: *ihorps > *Sent: *6 марта 2018 г. 12:10 > *To: *user@ign

RE: Ignite readme.io - documentation export (pdf, etc)?

Hi Prachi, Any chance you can help with that? Thanks, Stan From: ihorps Sent: 6 марта 2018 г. 12:10 To: user@ignite.apache.org Subject: Ignite readme.io - documentation export (pdf, etc)? hi all I tried to find some option on readme.io to export Apache Ignite documentation into some static for

SELECT Statement cancellation & memory sizing

I have a question about SQL query via JDBC cancellation, as well as a performance question. I've connected Ignite from SQL/Workbench using the Thin driver, however via ssh -L proxy and I issued "select count(*) from table1 where indexedField = x;" and that took 1:40 (m:ss) "select count(*) from t

Re: How to reconnect Ignite client after server node bounce?

Yes, it is reproducible See client thread dump attached Server node is just logging metrics, nothing more: [13:03:10,830][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=d0ae4736, uptime=00:15:00.098] ^-- H/N/C

RE: How to reconnect Ignite client after server node bounce?

Hi Olexandr, Is it reproducible? Can you share a full thread dump? Also, are there any related messages in the logs (make sure you’re running with `java -DIGNITE_QUEIT=false` or with `ignite.sh -v`)? Thanks, Stan From: Olexandr K Sent: 6 марта 2018 г. 12:48 To: user@ignite.apache.org Subject:

Re: How to configure a cluster as a persistent, replicated SQL database

Hi Jose Did it work for you ? I had the same question. I wanted to use JDBC client driver to connect to Ignite cluster. I am trying to use Java Would you be able ot share the code snippet if you are using java to connect to the ignite cluster thru JDBC client driver Thanks Naveen -- Sent from

Re: How to configure write through persistence?

Thanks Dmitry I started server node via bin/ignite.sh but didn't override DEFAULT_CONFIG to point on my configuration As result, client node was using my config and server node used default config. Persistence is working after fixing this. On Tue, Mar 6, 2018 at 11:55 AM, Dmitry Pavlov wrote:

Re: How to configure write through persistence?

Hi Oleksandr, Could you please check Ignite logs for messages were persistence directory located? When Ignite is started from code, it is possible that Ignite is not able to locate IGNITE_WORK or IGNITE_HOME and creates work files in temp dir. Start scripts always provide this setting, but in dev

How to reconnect Ignite client after server node bounce?

Hi Team, I tried the following scenario: 1) start local ignite server node 2) start client node and put some key/value pairs 3) bounce server node 4) put some more key/value pairs from client node at step (4) ignite put(..) operation just hanged I expected ignite client to take care of auto-rec

How to configure write through persistence?

Hi Team, I'm trying to configure persistent cache. Specifically I need to cache key-value pairs and they should be also stored to persistent storage. Here is my configuration: [ignite.xml] ...

Ignite readme.io - documentation export (pdf, etc)?

hi all I tried to find some option on readme.io to export Apache Ignite documentation into some static form, let's say PDF but I was not successful. Is there a way (even transitive, like in few steps) to achieve this goal? Thank you in advance! -- Sent from: http://apache-ignite-users.70518.

RE: Re: Node can not join cluster

Hi, As Alex said before, from the log you’ve provided it’s hard to say much but what’s in this message: === [09:06:26,657][WARNING][main][TcpDiscoverySpi] Node has not been connected to topology and will repeat join process. Check remote nodes logs for possible error messages. Note