[
https://issues.apache.org/jira/browse/IGNITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Kozlov updated IGNITE-4334:
----------------------------------
Description:
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}
was:
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;
final Long RANGE_NUM = 2*PRELOAD_NUM;
final int OPERATION_LIMIT = 500;
ArrayList<String> fields = new ArrayList<>(
Arrays.asList("intCol", "longCol", "shortCol", "stringCol",
"doubleCol", "bigDecimalCol", "booleanCol", "mapCol")
);
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}
> 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
> 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)
