[
https://issues.apache.org/jira/browse/IGNITE-4106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15622307#comment-15622307
]
ASF GitHub Bot commented on IGNITE-4106:
----------------------------------------
GitHub user AMashenkov opened a pull request:
https://github.com/apache/ignite/pull/1198
IGNITE-4106: SQL: parallelize sql queries over cache local partitions
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-4106
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/1198.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1198
----
commit 87a1928a4f90b4f8a221041cfff9d22e3dd801cc
Author: vozerov-gridgain <[email protected]>
Date: 2016-08-26T12:22:15Z
IGNITE-3776: Removed code duplication in GridNearAtomicAbstractUpdateFuture.
commit 92f18bf353cc8c3821c6500ce9f1cd397a7cf17c
Author: Andrey V. Mashenkov <[email protected]>
Date: 2016-08-26T12:31:30Z
IGNITE-3745: ODBC: Implemented date/time/timestamp escape sequence parsing.
This closes #991.
commit b5757642e135908d9baa027a605035dd0d4acfc9
Author: tledkov-gridgain <[email protected]>
Date: 2016-08-26T12:47:02Z
IGNITE-3670 IGFS: Improved symlink handling for delete operation and added
more tests. This closes #975.
commit 289170346e40a89243b80d3743c1b66543a117ef
Author: Igor Sapego <[email protected]>
Date: 2016-08-29T12:00:08Z
IGNITE-3773: ODBC: Added tests for UUID data type. This closes #993.
commit 0465874d9dddcf962a82a2ef38589121201f0b75
Author: agura <[email protected]>
Date: 2016-08-24T18:13:29Z
ignite-2968 Deadlock detection for optimistic tx and near caches
commit fea3eeaac839381ec3662275a82f4d12af6f12dd
Author: agura <[email protected]>
Date: 2016-08-29T15:38:35Z
Merged ignite-1.6.7 to ignite-1.7.2
commit 407071e466d1a4fcec86571d4791ace8bb206f53
Author: Eduard Shangareev <[email protected]>
Date: 2016-08-30T00:32:31Z
IGNITE-2546 - Transformers for SCAN queries. Fixes #949.
commit f9ff97c91374dcd9cd8ad08d46d1d2de44193060
Author: Andrey V. Mashenkov <[email protected]>
Date: 2016-08-30T06:31:20Z
ignite-2560 Support resource injection for entry processor, optimizations
for resource injection.
commit 3244a5c9dabf6d4fcaa32a661cc0adc6f8ea30de
Author: Andrey V. Mashenkov <[email protected]>
Date: 2016-08-30T08:49:11Z
IGNITE-3742: ODBC: Added support for OUTER JOIN escape sequence. This
closes #1000.
commit fbbcaf4322548f61d2f63bf5d4e8f6d5284e73d3
Author: Andrey V. Mashenkov <[email protected]>
Date: 2016-08-30T10:22:29Z
IGNITE-3798: ODBC: Added literals support. This closes #1005.
commit 1ef150eba52eb63c2bfc3fafa0d036cf26be1c5b
Author: Alexey Kuznetsov <[email protected]>
Date: 2016-08-30T11:18:20Z
Revert wrong merge.
commit 4a259da296946740e180d25559e5cacba60a97ad
Author: EdShangGG <[email protected]>
Date: 2016-08-30T11:39:13Z
Merge remote-tracking branch 'ignite-gg/ignite-1.6.7' into ignite-1.7.2
# Conflicts:
#
modules/core/src/main/java/org/apache/ignite/internal/processors/cache/query/GridCacheQueryManager.java
#
modules/indexing/src/test/java/org/apache/ignite/testsuites/IgniteCacheQuerySelfTestSuite.java
#
modules/spring/src/test/java/org/apache/ignite/testsuites/IgniteSpringTestSuite.java
commit 31dbc5d65f8ea51010d2129e7c6e9a27acbf8528
Author: isapego <[email protected]>
Date: 2016-08-30T14:28:34Z
Fix for C++ tests.
commit dabd86c62e39eb983ef3d198c8b8ee96d2623c84
Author: Andrey Novikov <[email protected]>
Date: 2016-08-31T09:00:19Z
IGNITE-3811 Fixed query for merge with complex key on SQL Server.
commit 70e69cb7aa08c268b07920838add4a40e28fe25d
Author: isapego <[email protected]>
Date: 2016-08-31T13:47:11Z
IGNITE-3390: Added DSN configuration window.
commit bdbc5a37c1924ba4427221ee6cdf506c7f3ba248
Author: isapego <[email protected]>
Date: 2016-08-31T14:13:34Z
Merge branch 'ignite-1.6.7' into ignite-1.7.2
commit 12f532986677c30a716f73aeaa7d3587dd701f55
Author: sboikov <[email protected]>
Date: 2016-09-01T14:05:15Z
Merge remote-tracking branch 'remotes/community/ignite-1.6.6' into
ignite-1.6.7
commit ae7765329fd6f7d50d13183d13626f39c5682334
Author: dkarachentsev <[email protected]>
Date: 2016-09-02T15:01:12Z
IGNITE-2208 - Queries with object arguments doesn't work wth
BinaryMarshaller.
commit 7a84ab6a9163ca31fbcfcc6d7ff27e06bf9babef
Author: vozerov-gridgain <[email protected]>
Date: 2016-09-02T15:05:16Z
IGNITE-3827: Removed double marshalling of keys in
DataStreamerImpl.addData(Map) method.
commit 7bb961fd0a2e78334d33b6bc279c4edc323c246a
Author: vozerov-gridgain <[email protected]>
Date: 2016-09-02T15:05:54Z
Merge remote-tracking branch 'upstream/ignite-1.6.7' into ignite-1.6.7
commit e3c4868d6737e5a0f0b90f99666242865add750c
Author: vozerov-gridgain <[email protected]>
Date: 2016-09-02T15:23:09Z
IGNITE-3829: Optimized affinity key field name handling.
commit e9c797fd964727882ad6f40f2a452b17ae7c857e
Author: isapego <[email protected]>
Date: 2016-09-04T13:47:40Z
IGNITE-2946: CPP: Optimized GetNext() method for cursors. This closes #992.
commit c992213274ec5872ef7ce359efa51e26003424ad
Author: isapego <[email protected]>
Date: 2016-09-04T13:49:42Z
IGNITE-3760: ODBC: Added tests for supported SQL92 string functions. This
closes #1006.
commit d06eaa2344a753e08d1e3cb00e6b4ab83c6a9a01
Author: isapego <[email protected]>
Date: 2016-09-04T13:52:04Z
IGNITE-3801: ODBC: Added tests for OUTER JOIN. This closes #1027.
commit f8ae67456703e63e3afc9bb5c21d81d576d59448
Author: tledkov-gridgain <[email protected]>
Date: 2016-09-04T14:09:08Z
IGNITE-3651 IGFS: Implemented "usedSpaceSize()" operation for local
secondary file system. This closes #1009.
commit fc2fe7bf1905675258d40932a4ff649156c17488
Author: tledkov-gridgain <[email protected]>
Date: 2016-09-04T14:12:35Z
IGNITE-3646: IGFS: Added test for symlinked mkdirs on local secondary file
system. This closes #1013.
commit 3aa13f716934a6ccfe49f8bf99ec3b654e263900
Author: vozerov-gridgain <[email protected]>
Date: 2016-09-05T07:19:48Z
IGNITE-3829: Additional fix.
commit a760918757bee71ab28495496f94e9067ef17888
Author: Igor Sapego <[email protected]>
Date: 2016-09-05T07:36:38Z
IGNITE-3750: ODBC: Added tests for date/time types. This closes #1002.
commit afac3fab5f22250b830383a9f10336d396c83ad9
Author: Saikat Maitra <[email protected]>
Date: 2016-09-05T08:06:39Z
IGNITE-1952 Visorcmd: add a command for reset (clear) of metrics. Fixes
#1029.
commit d65228e42ec9c84182b8c9c9c8d06a0056d5eed2
Author: Andrey V. Mashenkov <[email protected]>
Date: 2016-09-05T08:20:26Z
IGNITE-2974: ODBC: Added "socketSendBufferSize" and
"socketReceiveBufferSize" configuration parameters. This closes #994.
----
> SQL: parallelize sql queries over cache local partitions
> --------------------------------------------------------
>
> Key: IGNITE-4106
> URL: https://issues.apache.org/jira/browse/IGNITE-4106
> Project: Ignite
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 1.6, 1.7
> Reporter: Andrew Mashenkov
> Assignee: Andrew Mashenkov
> Labels: performance
>
> If we run SQL query on cache partitioned over several cluster nodes, it will
> be split into several queries running in parallel. But really we will have
> one thread per query on each node.
> So, for now, to improve SQL query performance we need to run more Ignite
> instances or split caches manually.
> It seems to be better to split local SQL queries over cache partitions, so we
> would be able to parallelize SQL query on every single node and utilize CPU
> more efficiently.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
