[ 
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 <voze...@gridgain.com>
Date:   2016-08-26T12:22:15Z

    IGNITE-3776: Removed code duplication in GridNearAtomicAbstractUpdateFuture.

commit 92f18bf353cc8c3821c6500ce9f1cd397a7cf17c
Author: Andrey V. Mashenkov <andrey.mashen...@gmail.com>
Date:   2016-08-26T12:31:30Z

    IGNITE-3745: ODBC: Implemented date/time/timestamp escape sequence parsing. 
This closes #991.

commit b5757642e135908d9baa027a605035dd0d4acfc9
Author: tledkov-gridgain <tled...@gridgain.com>
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 <isap...@gridgain.com>
Date:   2016-08-29T12:00:08Z

    IGNITE-3773: ODBC: Added tests for UUID data type. This closes #993.

commit 0465874d9dddcf962a82a2ef38589121201f0b75
Author: agura <ag...@gridgain.com>
Date:   2016-08-24T18:13:29Z

    ignite-2968 Deadlock detection for optimistic tx and near caches

commit fea3eeaac839381ec3662275a82f4d12af6f12dd
Author: agura <ag...@gridgain.com>
Date:   2016-08-29T15:38:35Z

    Merged ignite-1.6.7 to ignite-1.7.2

commit 407071e466d1a4fcec86571d4791ace8bb206f53
Author: Eduard Shangareev <eshangar...@gridgain.com>
Date:   2016-08-30T00:32:31Z

    IGNITE-2546 - Transformers for SCAN queries. Fixes #949.

commit f9ff97c91374dcd9cd8ad08d46d1d2de44193060
Author: Andrey V. Mashenkov <andrey.mashen...@gmail.com>
Date:   2016-08-30T06:31:20Z

    ignite-2560 Support resource injection for entry processor, optimizations 
for resource injection.

commit 3244a5c9dabf6d4fcaa32a661cc0adc6f8ea30de
Author: Andrey V. Mashenkov <andrey.mashen...@gmail.com>
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 <andrey.mashen...@gmail.com>
Date:   2016-08-30T10:22:29Z

    IGNITE-3798: ODBC: Added literals support. This closes #1005.

commit 1ef150eba52eb63c2bfc3fafa0d036cf26be1c5b
Author: Alexey Kuznetsov <akuznet...@apache.org>
Date:   2016-08-30T11:18:20Z

    Revert wrong merge.

commit 4a259da296946740e180d25559e5cacba60a97ad
Author: EdShangGG <eshangar...@gridgain.com>
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 <isap...@gridgain.com>
Date:   2016-08-30T14:28:34Z

    Fix for C++ tests.

commit dabd86c62e39eb983ef3d198c8b8ee96d2623c84
Author: Andrey Novikov <anovi...@apache.org>
Date:   2016-08-31T09:00:19Z

    IGNITE-3811 Fixed query for merge with complex key on SQL Server.

commit 70e69cb7aa08c268b07920838add4a40e28fe25d
Author: isapego <isap...@gridgain.com>
Date:   2016-08-31T13:47:11Z

    IGNITE-3390: Added DSN configuration window.

commit bdbc5a37c1924ba4427221ee6cdf506c7f3ba248
Author: isapego <isap...@gridgain.com>
Date:   2016-08-31T14:13:34Z

    Merge branch 'ignite-1.6.7' into ignite-1.7.2

commit 12f532986677c30a716f73aeaa7d3587dd701f55
Author: sboikov <sboi...@gridgain.com>
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 <dkarachent...@gridgain.com>
Date:   2016-09-02T15:01:12Z

    IGNITE-2208 - Queries with object arguments doesn't work wth 
BinaryMarshaller.

commit 7a84ab6a9163ca31fbcfcc6d7ff27e06bf9babef
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-09-02T15:05:16Z

    IGNITE-3827: Removed double marshalling of keys in 
DataStreamerImpl.addData(Map) method.

commit 7bb961fd0a2e78334d33b6bc279c4edc323c246a
Author: vozerov-gridgain <voze...@gridgain.com>
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 <voze...@gridgain.com>
Date:   2016-09-02T15:23:09Z

    IGNITE-3829: Optimized affinity key field name handling.

commit e9c797fd964727882ad6f40f2a452b17ae7c857e
Author: isapego <isap...@gridgain.com>
Date:   2016-09-04T13:47:40Z

    IGNITE-2946: CPP: Optimized GetNext() method for cursors. This closes #992.

commit c992213274ec5872ef7ce359efa51e26003424ad
Author: isapego <isap...@gridgain.com>
Date:   2016-09-04T13:49:42Z

    IGNITE-3760: ODBC: Added tests for supported SQL92 string functions. This 
closes #1006.

commit d06eaa2344a753e08d1e3cb00e6b4ab83c6a9a01
Author: isapego <isap...@gridgain.com>
Date:   2016-09-04T13:52:04Z

    IGNITE-3801: ODBC: Added tests for OUTER JOIN. This closes #1027.

commit f8ae67456703e63e3afc9bb5c21d81d576d59448
Author: tledkov-gridgain <tled...@gridgain.com>
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 <tled...@gridgain.com>
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 <voze...@gridgain.com>
Date:   2016-09-05T07:19:48Z

    IGNITE-3829: Additional fix.

commit a760918757bee71ab28495496f94e9067ef17888
Author: Igor Sapego <isap...@gridgain.com>
Date:   2016-09-05T07:36:38Z

    IGNITE-3750: ODBC: Added tests for date/time types. This closes #1002.

commit afac3fab5f22250b830383a9f10336d396c83ad9
Author: Saikat Maitra <saikat.mai...@gmail.com>
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 <andrey.mashen...@gmail.com>
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)

Reply via email to