You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexander Paschenko (JIRA)" <ji...@apache.org> on 2016/11/30 09:24:58 UTC
[jira] [Commented] (IGNITE-4334) DML: INSERT INTO SELECT FROM
statement fails if copy from partitioned to replicated cache
[ https://issues.apache.org/jira/browse/IGNITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15708038#comment-15708038 ]
Alexander Paschenko commented on IGNITE-4334:
---------------------------------------------
Problem is cross cache subquery. Won't fix as we don't support such SELECTs either - please try this and see for yourself that it fails:
{code:java}
ig.cache("tx-repl-full-sync").query(new SqlFieldsQuery("select _key, _val from \"tx-part-full-sync\".AllTypes")).getAll();
{code}
> DML: INSERT INTO SELECT FROM statement fails if copy from partitioned to replicated cache
> -----------------------------------------------------------------------------------------
>
> Key: IGNITE-4334
> URL: https://issues.apache.org/jira/browse/IGNITE-4334
> Project: Ignite
> Issue Type: Bug
> Components: general
> Affects Versions: 1.8
> Reporter: Sergey Kozlov
> Assignee: Alexander Paschenko
> Fix For: 1.8
>
>
> INSERT INTO SELECT FROM statement fails if executed on a replicated cache and used partitioned cache as data source:
> {code:title=test.java|borderStyle=solid}
> public static void main(String[] args) throws Exception {
> Ignition.setClientMode(true);
> final Long PRELOAD_NUM = 1_000L;
> List<String> cacheNames = Arrays.asList(
> "tx-part-full-sync",
> "tx-repl-full-sync",
> );
> String srcCache = null;
> try (Ignite ig = Ignition.start("examples/config/ext-sql.xml")) {
> for (String cacheName : cacheNames) {
> //ig.cache(cacheName).query(new SqlFieldsQuery("delete from AllTypes"));
> if (srcCache == null) {
> // data preloading here
> // .........
> srcCache = cacheName;
> }
> else {
> ig.cache(cacheName).query(new SqlFieldsQuery("insert into AllTypes (_key, _val) select _key, _val from \"" + srcCache + "\".AllTypes"));
> }
> System.out.println("The cache size " + cacheName + ": " + ig.cache(cacheName).sizeLong());
> }
> }
> {code}
> {noformat}
> Exception in thread "main" javax.cache.CacheException: Queries running on replicated cache should not contain JOINs with partitioned tables [rCache=tx-repl-full-sync, pCache=tx-part-full-sync]
> at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.stableDataNodes(GridReduceQueryExecutor.java:432)
> at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:529)
> at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1119)
> at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:98)
> at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doInsert(DmlStatementsProcessor.java:700)
> at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:282)
> at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:155)
> at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsTwoStep(DmlStatementsProcessor.java:185)
> at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1266)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:812)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:810)
> at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1777)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:810)
> at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:749)
> at org.apache.ignite.examples.datagrid.ExtSqlExample.main(ExtSqlExample.java:221)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)