ptupitsyn commented on issue #11614: URL: https://github.com/apache/ignite/issues/11614#issuecomment-2432637544
> 1. Can we have multiple affinity keys defined for a table/Cache Simple answer: no, don't do that. Details: affinity key is defined per type. Multiple types can be stored in one cache. Multiple SQL tables can be defined in one cache. I would not recommend any of that, keep it 1 cache = 1 table = 1 type. > 2. Is there any way to set the affinity key when we have any hierarchy such as Parent -> Child -> Child2 All children (direct and indirect) should use the same affinity key as the parent, so that the entire family is colocated. Example: https://ignite.apache.org/docs/latest/data-modeling/affinity-collocation#configuring-affinity-key -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@ignite.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org