I’m curious: why did you switch to Calcite if your deployment is in production? I would generally be cautious about putting beta software into production. Was there some critical feature that you needed?
> On 30 Jun 2023, at 09:34, y <hty1994...@163.com> wrote: > > Thanks for your suggestion. We are considering the feasibility of your > proposed solution. For complex business production environments, it is > difficult to distinguish whether the query requires setLocal or not. Anyway, > thank you for your help. > > > > > At 2023-06-30 15:18:07, "Stephen Darlington" > <stephen.darling...@gridgain.com> wrote: > > If this is an important feature for you, the obvious solution would be to use > the H2 SQL engine (which is still the default, since the Calcite engine is > still considered beta). > > As noted in the documentation, you can even keep Calcite as the default > engine in your cluster and only route these queries to H2. > https://ignite.apache.org/docs/latest/SQL/sql-calcite#query_engine-hint > >> On 30 Jun 2023, at 03:50, y <hty1994...@163.com> wrote: >> >> Hello. >> I'm sorry for it took so long time to reply to the message duing to I >> missed some messages. For example, I have multiple nodes performing the same >> computational tasks. The cache mode is partition and the data is cached by >> affinity_key. So the different nodes have different data and node only >> query/calculate data from itself. If there is no setLocal, the node will >> query data from other nodes, which is inefficient. That's why i need >> setLocal. What should I do if without setLocal? >> >> <image.png> >> >> Yours, >> Hu Tiany >> 2023/6/30 >> >> At 2023-06-05 19:21:13, "Alex Plehanov" <plehanov.a...@gmail.com> wrote: >> >Hello, >> > >> >The Calcite-based SQL engine currently doesn't analyze any properties >> >of SqlFieldsQuery except "Sql", "Schema", "Args" and >> >"QueryInitiatorId". Some of the rest properties are useless for the >> >Calcite-based engine at all (for example, "DistributedJoins", since >> >all joins in the Calcite-based engine are distributed by default if >> >needed). But, perhaps, others can be useful. If you are really sure >> >that the "Local" property is necessary for the new SQL engine, feel >> >free to create a ticket and describe the reason why we need it. >> > >> >пн, 5 июн. 2023 г. в 12:05, y <hty1994...@163.com>: >> >> >> >> Hello igniters, >> >> Just like the title, setLocal seems invalid for Calcite 2.15. When I set >> >> ‘setLocal = true’ and query data from one node, the result sets is >> >> returned from all data nodes. This problem is not present in version >> >> 2.13 ,which not use Calcite. I'd like to know is this an error? If yes it >> >> is, When will it be fixed? >> >> >> >> SqlFieldsQuery fieldsQuery = new SqlFieldsQuery(query); >> >> fieldsQuery.setLocal(true); // uneffective for this line >> >> List<List<?>> rs = >> >> ignite.cache("bfaccounttitle2020").query(fieldsQuery).getAll(); >> >> >> >> >