Re: Null Pointer Error in GridDhtPartitionsExchangeFuture

Hi Ilya, Thank you for your reply. I have done this test a few times and I consistently get stalling grids during failover/scaling/server swapping I have tried tuning some parameters, according to ignite production prep docs . I ha

Re: Continuous Query Questions

Hi Evgeni, There will be several thousands notifications/day if I have it send notification only when certain patterns are visited, in about 100+ caches, which brings up another question: wouldn't having 100+ CQs be creating too much overhead? thanks. On Tue, Feb 18, 2020 at 2:17 PM Evgenii Zhur

Transaction Ids associated with Cache Put (Atomicity mode TRANSACTIONAL)

I am also noticing when I do insert from the dbeaver( jdbc thin client ) the transaction id associated with the TX_STARTED/TX_COMMITTED event is different from the xid parameter sent with the Cache_PUT event . Why is this so ? Should the both not be the same ? -- Sent from: http://apache-ig

visor mcompact command?

what's mcompact about? it says only this: visor> help mcompact mcompact Finds and fills gap in Visor console memory variables. What are these gaps?

Re: Apache Ignite downloads are redirecting from https to http

::Bump:: Devin On 2/17/20 5:42 PM, Devin Anderson wrote: Hi all, I'm not sure if this is the correct mailing list to bring up this issue.  If I'm writing the wrong mailing list, please let me know and I'll gladly send my message to a more appropriate list/person. When I attempt to run `apt

Re: Continuous Query Questions

Hi, How many notifications do you want to get? If it's just a several notifications, then you can even register separate CQ for each of the entry with its own remote filters. At the same time, if you have a requirement to send these notifications for a lot of entries, then this approach will creat

Re: Ignite Cluster and Kubernetes Cluster

It is possible to have multiple Ignite clusters inside a K8 Cluster. For each ignite cluster: 1. create a service that allows the pods within the ignite cluster to identify each other. 2. put the service as as spec into the statefulset/deployment yaml. 3. put the service into the ignite disco

Re: Ignite on yarn doesn't started

https://issues.apache.org/jira/browse/IGNITE-12697 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Regarding TRANSACTIONAL_SNAPSHOT

Hi, 1. TRANSACTIONAL_SNAPSHOT is still in beta version. Perhaps the current version of MVCC will be completely redone in the future. So, it is not a good idea to use it in production systems right now. 2. Events are not implemented for MVCC yet. As well as several other features that presented in

Re: Data Load from Oracle to Ignite is very slow

Hi We are doing POC, as a result of which we are running it in local mode. Currently it is taking 25min to load 2 records with Cache JDBC POJO Store. Even i am giving the initial filter to reduce unnecessary records. ignite.cache("PieProductRiskCache").loadCache(null,"ignite.e

Regarding TRANSACTIONAL_SNAPSHOT

Hi, 1. We wanted to try TRANSACTIONAL_SNAPSHOT Atomicity Mode. Wanted to know if it is production version ?Asking since I noticed the below in the documentation . Not sure if this applies for the TRANSACTIONAL_SNAPSHOT atomicity mode as well . (https://apacheignite.readme.io/docs/transactions)

Re: Data Load from Oracle to Ignite is very slow

Hello! The code that you have provided will not have any edge over CacheStore. I'm not sure that running two nodes on the same machine is a sound approach for benchmarking data load speed. Are you sure that performance is not sufficient? What is actual run time and your expectations? Regards, --

Re: Column name in lower case

Hello! Doesn't seem to match my observations: ~/Downloads/apache-ignite-2.7.6-bin% bin/sqlline.sh sqlline version 1.3.0 sqlline> !connect jdbc:ignite:thin://localhost Enter username for jdbc:ignite:thin://localhost: Enter password for jdbc:ignite:thin://localhost: 0: jdbc:ignite:thin://localhost

Re: Data Load from Oracle to Ignite is very slow

I am having two nodes running on local machine. Following is the logic i implemented to load data using Data Steamer.Can you please check whether the implementation is correct and also can you please share sample code on how to push entries to data streamer from multiple threads public class Per

Re: Column name in lower case

As I said if we create table with “table” Then select would be like select * from “table” and not select * from table and same for every column where by default it makes table as TABLE and select * from table or Table or TABLE everything works fine . Regards > On 18-Feb-2020, at 7:15 PM, Ilya

Re: Column name in lower case

Hello! Have you tried using case-sensitive column names, such as CREATE TABLE "table" ("lowercaseid" INT PRIMARY KEY, "mixedCaseVal" VARCHAR); Maybe it will help with your use case. Regards, -- Ilya Kasnacheev вт, 18 февр. 2020 г. в 15:09, Igor Sapego : > There are no such way in ODBC, but m

Re: Data Load from Oracle to Ignite is very slow

Hello! Load Cache will pull all rows from result set on all nodes. How many nodes do you have? 10 million rows is actually a very modest number. I could understand you worrying if you had 10B rows. The best approach is to partition your table and push entries to data streamer from multiple threa

Data Load from Oracle to Ignite is very slow

Hi, I have multiple oracle tables with more than 10 million rows. I want to load these tables into Ignite cache.To load the cache I am using Cache JDBC Pojo Store by getting the required project structure from Web Console. But Loading the data using cache JDBC POJO Store (i.e. ignite.cache("Cache

Re: Load cache data into another POJO with SQL

Hello! I'm not sure the rest of Ignite community will approve, but you can actually try to write an SQL extension function, which will serve as factory method for MyPojo. https://apacheignite-sql.readme.io/docs/custom-sql-functions This is used in conjunction with Geometry with some success. It

Re: Need help for Access Violation

Hello! Since it is Windows (build once, run everywhere no sh!t), maybe you can just share the compiled project with general public, or just the .exe? We could try running it, see if it fails. BTW, did you try to run it on a different box? Regards, -- Ilya Kasnacheev пт, 7 февр. 2020 г. в 00:2

Re: Ignite on yarn doesn't started

Hello! Can you please also file a ticket against Apache Ignite JIRA? https://issues.apache.org/jira/projects/IGNITE/issues I think it would not be a problem to merge it. Regards, -- Ilya Kasnacheev вт, 18 февр. 2020 г. в 11:04, v.shinkevich : > Hi, > > I found problem, but it is correct : >

Re: Loading cache from Oracle Table

Hi Prasad, Is there a improvement in performance. If so can you please share the sample code as i am also looking for a similar solution. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Column name in lower case

There are no such way in ODBC, but maybe SQL guys can suggest some solution here. Anyway this is weird, as software that uses ODBC can actually query ODBC driver for the case of the returned SQL symbols, and our driver clearly states that it uses upper case. Best Regards, Igor On Tue, Feb 18, 2

Re: JDBC thin client incorrect security context

1. Another thing I noticed is that during a update through jdbc client, there could be 2 kinds of threads acting on it. The 'client-connector' thread and the 'sys-stripe'. If the client-connector thread completes the transaction and calls the record on storagemanager, it is able to send a 'cache_pu

Re: Ignite Web Console requires root?

I suspect it’s missing a “not” in there somewhere. You certainly do not need root access. Regards, Stephen > On 17 Feb 2020, at 22:32, Andrew Munn wrote: > >  > https://www.gridgain.com/docs/web-console/latest/deploying-web-console > > says: > > By default, the Web Console control process w

Column name in lower case

Hi, I am using UNIX ODBC and since create table command causes column name in UPPER case , and so SQLDescribeCol returns column name in UPPER case . Some of the application servers like Asterisk which checks the column name breaks as they expect the column name to be lower case . Is there a way to

Re: Ignite on yarn doesn't started

Hi, I found problem, but it is correct : # The HDFS path to the Apache Ignite build. This property can be useful when the yarn # is cluster running in net without internet access. IGNITE_PATH = hdfs:///ignite/apache-ignite-2.7.6-bin.zip The problem was in the Yarn configuration or other cluster