Re: Step by Step Guide?

2018-03-21 Thread Petr Ivanov
Hi, Tim! At what step exactly are you experiencing problems? > On 22 Mar 2018, at 00:59, Tim Heizer wrote: > > Is there a step by step guide on setting up an Ignite cluster in AWS. I found > the documentation here: https://apacheignite.readme.io/docs/aws-deployment >

RE: Get all data of one cache in Ignite without creating a new ignite node

2018-03-21 Thread linrick
Hi Pavel, I knew the rest api way to get/put data. But, I am looking for an easier way to get/put data. It likes the relationship between Redis and Jedis. Thanks Rick From: Pavel Vinokurov [mailto:vinokurov.pa...@gmail.com] Sent: Thursday, March 22, 2018 2:49 PM To: user@ignite.apache.org Subj

Re: Get all data of one cache in Ignite without creating a new ignite node

2018-03-21 Thread Pavel Vinokurov
Hi Rick, You could use rest api that documented in https://apacheignite.readme.io/docs/rest-api . Thanks, Pavel 2018-03-22 9:44 GMT+03:00 : > Dear all, > > > > My settings of running environment is as: > > OS: Ubuntn 14.04.3 LTS > > JAVA: JDK 1.7 > > Ignite: 2.4.0 > > > > I would like to get al

Get all data of one cache in Ignite without creating a new ignite node

2018-03-21 Thread linrick
Dear all, My settings of running environment is as: OS: Ubuntn 14.04.3 LTS JAVA: JDK 1.7 Ignite: 2.4.0 I would like to get all data of one cache in Ignite Without creating a new ignite node, I do not know how to get data by another executive java program (without the Ignition.getOrStart(cfg)).

Re: Re: Did update SQL support joiner?

2018-03-21 Thread aa...@tophold.com
Thanks Evgenii, We will check further. Regards Aaron Aaron.Kuai From: ezhuravlev Date: 2018-03-22 01:41 To: user Subject: Re: Did update SQL support joiner? Hi, First of all, you need to check that all data is collocated since by default join will be performed on each node on the collocate

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
Also it makes sense to use new 2.4 version. 2018-03-22 8:37 GMT+03:00 Vinokurov Pavel : > >> IgniteCache igniteCache = ignite.getOrCreateCache(" > testCache "); > please, change to ignite.cache("testCache") to be sure the we use > configuration from the file. > > 2018-03-22 8:19 GMT+03:00 Vinoku

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
>> IgniteCache igniteCache = ignite.getOrCreateCache("testCache "); please, change to ignite.cache("testCache") to be sure the we use configuration from the file. 2018-03-22 8:19 GMT+03:00 Vinokurov Pavel : > You already showed the cache configuration, but could you show jdbc > connection initia

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
You already showed the cache configuration, but could you show jdbc connection initialization 2018-03-22 7:59 GMT+03:00 Vinokurov Pavel : > Hi, > > Could you please show the "PATH/example-cache.xml" file. > > 2018-03-21 9:40 GMT+03:00 : > >> Hi Vinokurov, >> >> >> >> Thanks for your reply. >> >>

RE: Is backup copy always stored on different host - is it host-awarereplication

2018-03-21 Thread Naveen
Thanks Stan. I am creating the cache thru SQL DDL with below statement CREATE TABLE MAP_ASSOCIATED (PARTY_ID VARCHAR, ASSOCIATED_LIST VARCHAR, UPDATEDDATETIME TIMESTAMP, UPDATEDBY VARCHAR, PRIMARY KEY (PARTY_ID))WITH "template=partitioned,backups=1,cache_name=MAP_ASSOCIATED, value_type=com.ril.ed

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
Hi, Could you please show the "PATH/example-cache.xml" file. 2018-03-21 9:40 GMT+03:00 : > Hi Vinokurov, > > > > Thanks for your reply. > > I try to write batches by 100 entries. > > And I got a worse result. > > The writing speed is down to 12.09 KB per second. > > Below is my code which I try

Service Grid launching Compute Tasks

2018-03-21 Thread Neeraj Vaidya
Hi, Is it advisable to launch compute tasks from the execute method of a Service implementation task ? Are there any shortcomings ? The service execute methods are long running back ground method waiting for data arrival in queues/pipes, tcp connections, file system folders, etc. Regards, Neera

Re: Can one application connect to multiple Ignite clusters as client?

2018-03-21 Thread Amir Akhmedov
Hi, Of course you can. Just bring up two Ignite instances inside an application with different configurations. On Wed, Mar 21, 2018 at 9:04 PM, sherryhw wrote: > Hi, I am dealing with a case that one application may need to get access to > two Ignite fabric clusters. > Both of them are using Tcp

Can one application connect to multiple Ignite clusters as client?

2018-03-21 Thread sherryhw
Hi, I am dealing with a case that one application may need to get access to two Ignite fabric clusters. Both of them are using TcpDiscoveryJdbcIpFinder for TcpDiscoverySpi, but with different datasource (database table and sever different.) Is this approach possible? -- Sent from: http://apache-

Step by Step Guide?

2018-03-21 Thread Tim Heizer
Is there a step by step guide on setting up an Ignite cluster in AWS. I found the documentation here: https://apacheignite.readme.io/docs/aws-deployment but I am finding it difficult to fill all the gaps that aren't discussed in the documentation. A clear step by step for all steps and prerequis

[HIRE] Calling all ignite and inMemory Committers/Afficionados

2018-03-21 Thread Anirudha Jadhav
// Do you // Love Ignite Breathe in-Memory compute.. Work on a diverse set of challenging problems, while contributing to open source. please contact me at ajadh...@bloomberg.net NYC based position Ani

Re: Apache Ignite nightly release builds

2018-03-21 Thread Dmitry Pavlov
Hi Raymond, You could sign up using valid email address. Please write to @dev list if link still is not available. Sincerely, Dmitriy Pavlov ср, 21 мар. 2018 г. в 22:34, Raymond Wilson : > The link to build artifacts requires a Team City login. Is there a public > access location? > > > > *From

RE: Apache Ignite nightly release builds

2018-03-21 Thread Raymond Wilson
The link to build artifacts requires a Team City login. Is there a public access location? *From:* Petr Ivanov [mailto:mr.wei...@gmail.com] *Sent:* Wednesday, March 21, 2018 10:59 PM *To:* dev ; user@ignite.apache.org *Subject:* Re: Apache Ignite nightly release builds OK, I guess I can prese

Re: Kubernetes - Access Ignite Cluster Externally

2018-03-21 Thread David Wimsey
To access ignite from outside of kubernetes, you need to enable hostNetwork in the kubernetes cluster for your ignite server pods (this is not enabled with default permissions as it goes against many of the core principals of kubernetes). This will allow the ignite server to attach directly the

Re: Ignite Client is taking a long time to connect with large number of Client connections

2018-03-21 Thread ilya.kasnacheev
Hello! Ignite Clients are called "Thick", and indeed, they are pretty heavy-weight. They are full functional nodes, and as such, they have to join topology when starting and properly leave topology when stopping. This is long process. It also has to wait for any pending transactions in cluster, th

Re: 答复: Ignite cluster always throw java.lang.NoClassDefFoundError

2018-03-21 Thread ilya.kasnacheev
Hello! Here is the error that you are seeing: ignite 13:25:25.163 [main] WARN o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creati

Re: Did update SQL support joiner?

2018-03-21 Thread ezhuravlev
Hi, First of all, you need to check that all data is collocated since by default join will be performed on each node on the collocated data. Also, I don't see FROM in UPDATE grammar in H2: http://www.h2database.com/html/grammar.html#update So, I would recommend to rewrite it using subquery. Rega

Re: Error: Failed to parse query: SELECT * FROM ...

2018-03-21 Thread Wilhelm
Super - Thanks a lot Alex. So the first one works well (sqlline, dbeaver and java) SELECT * FROM B.B0; But the second one failed (dbeaver and sqlline), SELECT * FROM A.A; So I thought may be if the cache name is different from object type the it might work so instead of "Cache/Schema.ObjectClas

Re: Kubernetes - Access Ignite Cluster Externally

2018-03-21 Thread ilya.kasnacheev
Hello Ryan! I might be terribly wrong, but my first guess is, you should use TcpDiscoveryKubernetesIpFinder for Server nodes inside container, and TcpDiscoveryVmIpFinder for outside client nodes. If you're reaching for setAddresses(), that's the one you should take. With regards to breakage, ther

Re: .Net ICacheEntryFilter

2018-03-21 Thread Alexey Popov
Hi, Can you share a simple reproducer project for [InstanceResource] within ICacheEntryFilter? I can't find unit tests for that case in Apache Ignite source code. > but the field _ignite is null and we have no access to cache to get it. That sounds like a bug that should be fixed. Thanks, Alex

Re: Is backup copy always stored on different host - is it host-aware replication

2018-03-21 Thread Ivan Rakov
My bad: I didn't catch that there would be two nodes on one host. Stan already provided correct answer below. Best Regards, Ivan Rakov On 21.03.2018 17:44, Ivan Rakov wrote: Hi Naveen, Yes, all copies of partition (primary and all backups) are hosted on different nodes. There would be no sens

Re: How to achieve writethrough with ignite data streamer

2018-03-21 Thread ezhuravlev
if skipStore flag is enabled, then data won't be propagated to the store are you sure that you have writeThrough flag enabled? Additionally, you need to check your CacheStore implementation, if you don't have any ideas, you can post it here, the community will check it. Evgenii -- Sent from:

RE: Is backup copy always stored on different host - is it host-awarereplication

2018-03-21 Thread Stanislav Lukyanov
Hi, To make sure that two nodes on the same host don’t have primary and backup versions of the same partition you can use cacheConfiguration.setAffinity(new RendezvousAffinityFunction(true)); See https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/affinity/rendezvous/Re

Re: Ignite reads are slower with getAll

2018-03-21 Thread Stanislav Lukyanov
Hi, Increasing IOPS (I'm assuming we're talking about disk IOPS) is not always the solution since disk performance is not always the bottleneck. It may also be network, CPU, etc. Usually one needs to use profiling and monitoring tools, e.g. dstat, to measure the usage of the system resources. If d

Re: Is backup copy always stored on different host - is it host-aware replication

2018-03-21 Thread Ivan Rakov
Hi Naveen, Yes, all copies of partition (primary and all backups) are hosted on different nodes. There would be no sense in storing two copies on one node - we'd lose all of them in case of node failure. Best Regards, Ivan Rakov On 21.03.2018 17:37, Naveen wrote: Hi Using ignite 2.3 When w

Re: ContinuousQuery - SqlFieldsQuery as InitialQuery

2018-03-21 Thread au.fp2018
Thanks for your answer Pavel. But that does not help. 'q' is already a ContinuousQuery am I not sure what good the additional cast does. Anyway I tried that and also explicitly casting the initialQuery, didn't work. As I was suggesting in my first post the types don't line-up. In my search I came

Is backup copy always stored on different host - is it host-aware replication

2018-03-21 Thread Naveen
Hi Using ignite 2.3 When we use backup as 1, does it mean that backup copy is store in another host Lets say, if we have cluster with 3 hosts H1, H2, H3, each host running 2 ignite nodes H1 is holding the primary copy, backup copy should be on H2 or H3, it should not be on H1, but on different

Re: New feature with 2.4 - Using 3rd Party Persistence With Native Persistence

2018-03-21 Thread Naveen
Hi Denis It works perfectly fine, probably I am first one to try dual backing stores - native and Oracle. I was able to update the data in underlying backing store Oracle with below settings All the updates al

Re: Ignite Expiry Inconsistency with Native Persistence

2018-03-21 Thread Subash Chaturanga
I tried with proper ignite.stopAll() and it worked as expected!! So with a node crash, those expiration related metadata not got persisted. Is there a time for it to write and flush to disk ? On Wed, Mar 21, 2018 at 12:55 AM Subash Chaturanga wrote: > Hi Val, > Only one node running. And at ste

Re: Partition Id for a Data key in case of data colocation

2018-03-21 Thread Stanislav Lukyanov
What do you mean by "store the data in appropriate bucket"? Affinity key is used to locate the partition, but the (regular) key is used to store the entry itself, so entries don't override each other since each entry has a unique key. Stan prasadbhalerao1983 wrote > Hi, > > With affinity key ig

Re: Segmentation policy configuration

2018-03-21 Thread Stanislav Lukyanov
To specify a configuration parameter in the XML config you need to put the names of the properties in the tags, like this: http://www.springframework.org/schema/beans"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:util="http://www.springframework.org/schema/util";

Re: Affinity Key column to be always part of the Primary Key

2018-03-21 Thread David Harvey
Based this latest description, simply not specifying an affinity key here would be sufficient. But presumably you were specifying the affinity key to cause co-location. The reason a lookup on the K of the KV pair is fast is because it can hash to a node. If the affinity key was not included

Re: Error: Failed to parse query: SELECT * FROM ...

2018-03-21 Thread Alex Plehanov
Hello, Wilhelm! Default SQL schema is PUBLIC, when you create tables via SQL or query tables without specifying schema - default schema is used. When you create tables via java - cache name is used as schema. Your sqlline output shows that there are two tables A and B0 were created in schemas A an

Re: Apache Ignite nightly release builds

2018-03-21 Thread Petr Ivanov
OK, I guess I can present renewed Apache Ignite Nightly Releases. Link to artifacts of the latest successful build: https://ci.ignite.apache.org/viewLog.html?buildId=lastSuccessful&buildTypeId=Releases_NightlyRelease_RunApacheIgniteNightlyRelease&tab=artifacts

Re: Sorting or ranking TextQuery?

2018-03-21 Thread piyush
Is Ranking implemented in latest version 2.4 or at least in roadmap ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Large durable caches

2018-03-21 Thread Alexey Goncharuk
Hi Larry, Recently we've fixed the ticket [1] which may cause a major performance degradation when page replacement is present. Can you please try building Ignite from the master branch and check if the issue is still present? [1] https://issues.apache.org/jira/browse/IGNITE-7638 2018-03-15 19:2

Re: AffinityKey Configuration in order to achieve multiple joins across caches

2018-03-21 Thread Dmitriy Setrakyan
On Thu, Mar 15, 2018 at 9:51 PM, StartCoding wrote: > Hi Mike, > > Thanks for your quick response. > > I am afraid denormalizing will work for me because I have just given a > simple example. There are 16 tables which in that case needs to be joined > into single entity. Replication was an approa