Re: How to check that affinity key works?

Hi Jeremy! Thank you for your reply. Am I right that if JOIN is collocated then absence of affinity key will lead to incorrect results as data will not be fetched from other nodes? So the correct way to check influence of affinity key is to enable distributed JOIN? On 10 Jan 2023, at 10:48 PM

C# Ignite thin client - how to connect specific grid

Hi All, My requirement is to connect a specific grid(server has multiple grids) from c# thin client, since its support only 10800 ports. Regards, Charlin

Re: C# Ignite thin client - how to connect specific grid

C# thin client can connect to any port, specify it in the endpoint string like this: var clientCfg = new IgniteClientConfiguration("127.0.0.1:10901"); var client = Ignition.StartClient(clientCfg); or var clientCfg2 = new IgniteClientConfiguration { Endpoints = new[] { "127.0.0.1:10901" } };

Re: C# Ignite thin client - how to connect specific grid

Hi Pavel, Thanks for your reply. I am having two grids in one server and grid configuration as below. Which port should I use for connecting grid1 and grid2? [image: image.png] As per my understanding, I should be able to connect thin clients like this. Please correct me if I am wrong. //for Gri

Re: C# Ignite thin client - how to connect specific grid

Those ports are for thick-clients and servers. Thin clients connect to 10800. The second server to start will be on 10801, etc. You can configure the thin-client port with ClientConnectorConfiguration: getting-started-with-thin-clients

Re: C# Ignite thin client - how to connect specific grid

Set different client connector ports for different grids like this: ... On Thu, Jan 12, 2023 at 2:01 PM Stephen Darlington < stephen.darling...@gridgain.com> wrote: > Those ports are for thick-clients and servers. Thin cli

Re: C# Ignite thin client - how to connect specific grid

Hi, Thank you Stephen and Pavel. I will try these options and keep you posted. Regards, Charlin On Thu, 12 Jan 2023 at 17:45, Pavel Tupitsyn wrote: > Set different client connector ports for different grids like this: > > > > class="org.apache.ignite.configuration.C

Re: How to check that affinity key works?

Using distributed join will set a baseline for correct result set. If you get different results without distributed join, then you know there's a mismatch between join conditions and affinity. If you get the same results, then data is distributed well for this join. On Thu, Jan 12, 2023, 02:02 Айс

How to Create a Case-Insensitive Index

Hello, I am writing to inquire about creating a case-insensitive index in Ignite's XML Configuration. I have been trying to implement this feature in my current project, but I am having some difficulty. I understand that ignite supports case-sensitive indexing by default, but I would like to know i

Re: How to Create a Case-Insensitive Index

Hi, usually this can be achieved by using lower() function in index definition. I guess it should be something like: CREATE INDEX title_idx ON books (lower(title)); I'm not sure whether Ignite supports such feature, but you can give it a try. Btw, to exploit this index  you also would have to

Re: C# Ignite thin client - how to connect specific grid

Hi All, Thank you very much. I am able to connect two different grid in one server with different port configuration as below Grid 1 Grid 2 One observation I am not able to point multiple server node( Endpoints = new