[
https://issues.apache.org/jira/browse/IGNITE-18119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641033#comment-17641033
]
lichad edited comment on IGNITE-18119 at 11/30/22 2:04 AM:
-----------------------------------------------------------
I wrote a query code in the server computing task, The cache corresponding to
the FIGLACCDOCENTRY2020D table is partitioned (affinitykey is ACCTITLECODE). I
set the query to be executed locally, but the query result of each node is full
data:
IgniteCache cache =
ignite.getOrCreateCache("FIQUERYSUBLEDGER_TEMP").withKeepBinary();
SqlFieldsQuery query = new SqlFieldsQuery("SELECT ID,ABSTRACT,ACCTITLECODE as
ACCDOCCODE,BIZDATE as ACCDOCDATE,ACCORGID,PERIODCODE as
ACCPERIODCODE,ACCTITLECODE,'1' as FLAG FROM FIGLCHEMA.FIGLACCDOCENTRY2020D
WHERE PERIODCODE>='02' AND LEDGER IN
('4A1708200A1445279994BEF0CFF8E44E','58ACE67D63D243B79604049416CF7BA1') order
by ACCTITLECODE,PERIODCODE,BIZDATE");
query.setDistributedJoins(false);
query.setLocal(true);
List<List<?>> list = cache.query(query).getAll();
Please help me to see what is wrong, thank you very much!
was (Author: JIRAUSER298348):
I wrote a query code in the server computing task, including FIGLCHEMA The
cache corresponding to the FIGLACCDOCENTRY2020D table is partitioned
(affinitykey is ACCTITLECODE). I set the query to be executed locally, but the
query result of each node is full data:
IgniteCache cache =
ignite.getOrCreateCache("FIQUERYSUBLEDGER_TEMP").withKeepBinary();
SqlFieldsQuery query = new SqlFieldsQuery("SELECT ID,ABSTRACT,ACCTITLECODE as
ACCDOCCODE,BIZDATE as ACCDOCDATE,ACCORGID,PERIODCODE as
ACCPERIODCODE,ACCTITLECODE,'1' as FLAG FROM FIGLCHEMA.FIGLACCDOCENTRY2020D
WHERE PERIODCODE>='02' AND LEDGER IN
('4A1708200A1445279994BEF0CFF8E44E','58ACE67D63D243B79604049416CF7BA1') order
by ACCTITLECODE,PERIODCODE,BIZDATE");
query.setDistributedJoins(false);
query.setLocal(true);
List<List<?>> list = cache.query(query).getAll();
Please help me to see what is wrong, thank you very much!
> SqlFieldsQuery,setLocal does not work
> -------------------------------------
>
> Key: IGNITE-18119
> URL: https://issues.apache.org/jira/browse/IGNITE-18119
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.14
> Reporter: lichad
> Priority: Major
>
> In version 2.13, it still works normally. In version 2.14, "setlocal (true)"
> does not work regardless of the cacite or h2 engine.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
