Re: H2 SQL query optimiser strategy in Ignite

2019-05-08 Thread joseheitor
Hi Ignite Team, Have the system architects explored the option of maintaining table statistics on each node (as Postgres and other legacy SQL engines do), and then distributing the raw SQL query to each node and letting each node execute the query planner locally, optimising the query based on

Re: What is the convenient way to import data from a large number of files in HDFS?

2019-05-08 Thread Denis Magda
Hi, You can load data with Spark that connects to Hadoop in one end and to Ignite on the other. Denis On Wednesday, May 8, 2019, liyuj <18624049...@163.com> wrote: > Hi, > > What is the convenient way to import data from a large number of files in > HDFS? > > > -- -- Denis Magda

What is the convenient way to import data from a large number of files in HDFS?

2019-05-08 Thread liyuj
Hi, What is the convenient way to import data from a large number of files in HDFS?

Re: Web Console: Monitoring?

2019-05-08 Thread Denis Magda
GridGain is not planning to donate this feature. Not sure if the community is willing to implement it from scratch. - Denis On Wed, May 8, 2019 at 12:13 AM sv wrote: > Are there any plans to add Monitoring to Web Console? Seems like a highly > desirable feature. > > > > -- > Sent from:

Re: SQL delete command is slow and can cause OOM

2019-05-08 Thread Stanislav Lukyanov
Hi, You have to also fetch values to do a "compare-and-delete". Before deleting each entry you check if it has been concurrently modified. If it was then it's possible that the entry doesn't match your WHERE anymore. So yes, for now deleting a large number of entries is heap-intensive. It should

Re: Ignite statistics in the logs

2019-05-08 Thread Loredana Radulescu Ivanoff
Yes, thank you, I guess I missed setting the IGNITE_QUIET to false when I tried it out. As far as performance overhead, do you have any pointers? Of course, every environment is different, but I am hoping setting the 'metricsLogFrequency' to something like once every 5 minutes would not be too

Re: Ignite statistics in the logs

2019-05-08 Thread Vladimir Pligin
Hi, As far as I know this information should be shown in Ignite logs with default setup. The only thing you need to do is to run ignite.sh with -v option or set system property IGNITE_QUIET to false if you run a node without ignite.sh. In my setup it looks like

Re: Ignite with Hibernate 5.3

2019-05-08 Thread Tomasz Prus
When it will be released? > On 8 May 2019, at 15:29, Vladimir Pligin wrote: > > Hi Tomasz, > > It seems like Hibernate 5.3 support has been already added to Ignite in the > master branch. > I suppose this feature will be delivered as a part of upcoming Ignite > release. Here is the

Ignite statistics in the logs

2019-05-08 Thread Loredana Radulescu Ivanoff
Hello, I would like to see some periodic basic topology health statistics in the logs, such as CPU, heap/off heap usage etc. What would be a preferred way to configure that in a production like environment, without a significant performance overhead? Thank you, Loredana Radulescu Ivanoff

Re: Error installing Ignite on K8s

2019-05-08 Thread Vladimir Pligin
Hi, As far as can see you're facing an issue related to k8s service configuration. It's quite difficult to say whether you have issues with Ignite pods at this stage. So let's try to figure it out step by step. I suppose that the error is related to load balancing. As far as I know AWS provides

Re: Ignite with Hibernate 5.3

2019-05-08 Thread Vladimir Pligin
Hi Tomasz, It seems like Hibernate 5.3 support has been already added to Ignite in the master branch. I suppose this feature will be delivered as a part of upcoming Ignite release. Here is the corresponding ticket https://issues.apache.org/jira/browse/IGNITE-9893, fix version is 2.8. -- Sent

Ignite with Hibernate 5.3

2019-05-08 Thread Tomasz Prus
Hi, we are developing Spring application with Hibernate 5.3... Does Ignite works with Hibernate 5.3? What Maven dependencies i can use? Thanks, Tomasz Prus

Re: Web Console: Monitoring?

2019-05-08 Thread sv
Are there any plans to add Monitoring to Web Console? Seems like a highly desirable feature. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Behavior of Ignite during PME on new nodes added to the cluster

2019-05-08 Thread Ivan Pavlukhina
Evangelos, Thank you for your feedback! Regarding your questions: 1. Sounds quite widely. To avoid misunderstanding I try to give a general hint only. Actually a decision to rebalance data or not is made after PME. So, it is true that not every PME leads to a rebalance. (one more example when