Hello! I suggest generating a surrogate affinity key in this case, such as @AffinityKeyMapped String affKey = key1 + "-" + key2;
You can also file a feature request against Apache Ignite JIRA, but given the lack of community interest towards indexing nested objects, it is unlikely to be done. Maybe we could have composite affinity keys eventually, but I can't bet on that. Regards, -- Ilya Kasnacheev ср, 14 апр. 2021 г. в 16:12, <michal.ho...@barclays.com>: > Hello team, > > > > If we generate @AffinityKeyMapped field from multiple other fields and > then use those original fields in SQL WHERE condition, they are not used > for partition pruning: > > > https://ignite.apache.org/docs/latest/perf-and-troubleshooting/sql-tuning#partition-pruning > > > > Because Ignite doesn’t know how and from which fields to generate the > affinity key… and there’s probably no way to configure it. > > > > Could we get this feature, please? > > Regards, > Michal > > > _________________________________________________________________________________________________________________________________________________________________________________________________________________________________ > “This message is for information purposes only, it is not a > recommendation, advice, offer or solicitation to buy or sell a product or > service nor an official confirmation of any transaction. It is directed at > persons who are professionals and is not intended for retail customer use. > Intended for recipient only. This message is subject to the terms at: > www.barclays.com/emaildisclaimer. > > For important disclosures, please see: > www.barclays.com/salesandtradingdisclaimer regarding market commentary > from Barclays Sales and/or Trading, who are active market participants; > https://www.investmentbank.barclays.com/disclosures/barclays-global-markets-disclosures.html > regarding our standard terms for the Investment Bank of Barclays where we > trade with you in principal-to-principal wholesale markets transactions; > and in respect of Barclays Research, including disclosures relating to > specific issuers, please see http://publicresearch.barclays.com.” > > _________________________________________________________________________________________________________________________________________________________________________________________________________________________________ > If you are incorporated or operating in Australia, please see > https://www.home.barclays/disclosures/importantapacdisclosures.html for > important disclosure. > > _________________________________________________________________________________________________________________________________________________________________________________________________________________________________ > How we use personal information see our privacy notice > https://www.investmentbank.barclays.com/disclosures/personalinformationuse.html > > _________________________________________________________________________________________________________________________________________________________________________________________________________________________________ >
