Re: SQL Syntax error in cross-cache query

i think "select id from personCache.Person p limit 5" should work. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Syntax-error-in-cross-cache-query-tp15097p15099.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Affinity key does not seem to be working

Hi, I have a simple use case, but affinity key does not seem to be working. AffinityKey is placed on clientId which is same for everyone. So all the data should go to one node. However ignite visor shows that the data is different on each nodes, with each node having 3000+ entries. using 1.9.0 al

getting a basic error while running ignite

Hi, I am trying to run ignite server from the command line and client from the java code(the way it would happen for us). So, ignite server is started by bin/ignite.sh The Java code for the client is package test.ignite; import org.apache.ignite.Ignite; import org.apache.ignite.IgniteCompu

Re: Basic question on scaling of reads with ignite sql queries

sorry, i meant partitioned cache instead of replicated cache. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Basic-question-on-scaling-of-reads-with-ignite-sql-queries-tp11975p12265.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Basic question on scaling of reads with ignite sql queries

Thanks Andrew for the explanation. Just one additional question. Lets say i have an apache ignite cluster running on 2 different machines, and we give noOfBackups of a replicated cache as 1, each of the 2 machines will hold 1/2 of the primary partitions and 1/2 of the backup partition. Currently,

Re: Basic question on scaling of reads with ignite sql queries

Thanks Andrew, A follow up question, if i have 4 machines comprising a cluster of a distributed cache with backups set as 1, will 2 machines be master and 2 be slaves, or each machine will hold the 1/4th data of master data and 1/4th of slave data of another master. If it is former, then we read

Re: Basic question on scaling of reads with ignite sql queries

If SQL queries would execute not only on all masters, but on at least one instances from (M1,S11,S12)+(M2,S21,S22)+(M3,S31,S32), then the reads could be scaled linearly by increasing the no of slaves. ie a query would execute not on all masters, but on any combination of nodes where complete data w

Re: Basic question on scaling of reads with ignite sql queries

There is an option 'readFromBackup' in CacheConfiguration. Does it work for both cache.get() calls and SQL queries or only for cache.get() calls? Thanks -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Basic-question-on-scaling-of-reads-with-ignite-sql-queries-t

Re: Basic question on scaling of reads with ignite sql queries

Thanks, The default value of queryParallelism is 1. What is the recommended value? Does it depend on cores etc of the machine. Regards Tuco -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Basic-question-on-scaling-of-reads-with-ignite-sql-queries-tp11975p12005.

Re: Basic question on scaling of reads with ignite sql queries

Thanks, a follow up. If i have 2 replicas(no of backups =2), then will each SQL query still use all masters/slaves or a combination. Basically i am trying to find out if the reads can scale with SQL query if we increase the replication factor. -- View this message in context: http://apache-igni