[
https://issues.apache.org/jira/browse/IGNITE-1232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15175361#comment-15175361
]
Semen Boikov commented on IGNITE-1232:
--------------------------------------
Looked at failures, there are following issues:
- when run query on replicated cache from server node then query is always
executed locally (see IgniteCacheProxy.query). Tried to do a simple fix to do
not use local execution if distributed join flag is set, but got assert in
GridReduceQueryExecutor, need more knowledge about query execution to properly
fix it.
- when join replicated and partitioned caches from client node get this error
'Queries running on replicated cache should not contain JOINs with partitioned
tables'
{noformat}
javax.cache.CacheException: Queries running on replicated cache should not
contain JOINs with partitioned tables [rCache=REPLICATED_1,
pCache=PARTITIONED_b0_1]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.stableDataNodes(GridReduceQueryExecutor.java:428)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:548)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$3.iterator(IgniteH2Indexing.java:996)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:61)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:73)
at
org.apache.ignite.internal.processors.cache.IgniteCrossCachesDistributedJoinQueryTest.checkOrganizationPersonsJoin(IgniteCrossCachesDistributedJoinQueryTest.java:417)
{noformat}
Do we really should prohibit such queries with distributed join?
- can get wrong result when run query using IgntieCache which does not
participate in query (e.g. join person and accounts caches, but use
organization cache to run query). Should we fix it or prohibit such queries?
> Support distributed SQL JOIN
> -----------------------------
>
> Key: IGNITE-1232
> URL: https://issues.apache.org/jira/browse/IGNITE-1232
> Project: Ignite
> Issue Type: Improvement
> Reporter: Sergi Vladykin
> Assignee: Sergi Vladykin
> Fix For: 1.6
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
