[GitHub] [ignite] bgaraude opened a new issue, #10487: SqlFieldQueries with partitions on Calcite

[GitBox <gi...@apache.org>]

bgaraude opened a new issue, #10487:
URL: https://github.com/apache/ignite/issues/10487

   I tried to switch my existing code to Calcite on Ignite 2.14.0.
   
   We do use some SqlFieldQuery, and call .setPartitions(int...) on them to only return results from specific partitions. This works fine with the H2 engine.
   However, on calcite engine it seem to return all results for a query whatever we pass to .setPartitions(int...).
   
   Th javadoc for .setPartitions(int...) says: "The query will be executed only on nodes which are primary for specified partitions.", which makes me thinks that the correct behavior is calcite, and that H2 is incorrect.
   
   In any case, it would be better to have the same behavior whatever the engine is. Additionally, is there a way to return results for a specific partition on calcite?
   
   Here is a simple test case reproducing this issue: https://gist.github.com/bgaraude/873c40305ca0874f88f76f1ebe5dcf74
   
   


-- 
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-unsubscribe@ignite.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org