Thanks Ilya, Denis.
Regards,
De : ilya.kasnacheev
Envoyé : mardi 5 juin 2018 18:15:45
À : user@ignite.apache.org
Objet : Re: Affinity colocation and sql queries
Hello!
1) Yes!
2) "almost all the time" is not a very strong constraint here. You mig
Hello!
1) Yes!
2) "almost all the time" is not a very strong constraint here. You might
need to enable distributed joins to get such (partially-collocated) queries
to perform. Your query might still benefit from collocation if query planner
realizes that all keys are located on the same node.
3)
Hi Stephane,
Affinity collocation and affinity keys are crucial concepts/APIs to make
SQL JOINs work really fast. Similar concepts are adopted in other
distributed databases like Google Spanner, MemSQL, VoltDB, etc.
This page should shed more light on your question:
https://apacheignite-sql.readm
Hi All,
I'm not sure to have well-understood Ignite affinity colocation. I have several
questions.
1/ Does sql queries benefit from affinity colocation?
2/ The use case is an sql query like :
SELECT SUBSET1.KEY AS SET1_KEY, SUBSET2.KEY AS SET2_KEY
FROM WHOLESET AS SUBSET1, WHOLESET AS SUBS
