Re: SQL performance issues.

2016-10-11 Thread Sergi Vladykin
select avg(d), min(d), max(d) from (select datediff('s', ts1, ts2) d from t) will work for you. Sergi 2016-10-11 12:13 GMT+03:00 Andrey Mashenkov : > H2 documentation says: "Deterministic functions must always return the same > value for the same parameters." > > In sql query example below, hea

SQL performance issues.

2016-10-11 Thread Andrey Mashenkov
H2 documentation says: "Deterministic functions must always return the same value for the same parameters." In sql query example below, heavy "datediff" deterministic function will be called 4 times per row. Example: Select avg(datediff('s',ts1,ts2)) as avg_diff, min(datediff('s',ts1,ts2)) a

Re: Ignite service for redhat/centos

2016-10-11 Thread Denis Magda
Absolutely, This might be helpful to those who use or going to use Ignite in production under a significant load. Would you create a JIRA ticket proposing the content for the guide? — Denis > On Oct 10, 2016, at 9:04 AM, Yakov Zhdanov wrote: > > Hello Igniters! > > As far as I know many of

[jira] [Created] (IGNITE-4054) Add debug to trace HadoopMapReducePlanner results.

2016-10-11 Thread Vladimir Ozerov (JIRA)
Vladimir Ozerov created IGNITE-4054: --- Summary: Add debug to trace HadoopMapReducePlanner results. Key: IGNITE-4054 URL: https://issues.apache.org/jira/browse/IGNITE-4054 Project: Ignite Iss

[jira] [Created] (IGNITE-4053) Task error is always printed to the console.

2016-10-11 Thread Vladimir Ozerov (JIRA)
Vladimir Ozerov created IGNITE-4053: --- Summary: Task error is always printed to the console. Key: IGNITE-4053 URL: https://issues.apache.org/jira/browse/IGNITE-4053 Project: Ignite Issue Typ

[jira] [Created] (IGNITE-4052) Add ability to set up users for MESOS

2016-10-11 Thread Nikolay Tikhonov (JIRA)
Nikolay Tikhonov created IGNITE-4052: Summary: Add ability to set up users for MESOS Key: IGNITE-4052 URL: https://issues.apache.org/jira/browse/IGNITE-4052 Project: Ignite Issue Type: Im

[GitHub] ignite pull request #1156: Ignite 3862

2016-10-11 Thread dkarachentsev
GitHub user dkarachentsev opened a pull request: https://github.com/apache/ignite/pull/1156 Ignite 3862 You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/apache-ignite ignite-3862 Alternatively you can review and apply th

[GitHub] ignite pull request #1148: Ignite 4014

2016-10-11 Thread ntikhonov
Github user ntikhonov closed the pull request at: https://github.com/apache/ignite/pull/1148 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is

[jira] [Created] (IGNITE-4051) Web console: Dropdown menu is closed on move to tooltip with long variant value.

2016-10-11 Thread Vasiliy Sisko (JIRA)
Vasiliy Sisko created IGNITE-4051: - Summary: Web console: Dropdown menu is closed on move to tooltip with long variant value. Key: IGNITE-4051 URL: https://issues.apache.org/jira/browse/IGNITE-4051 Pr

[GitHub] ignite pull request #1155: IGNITE-2356 IGFS client should be able to failove...

2016-10-11 Thread tledkov-gridgain
GitHub user tledkov-gridgain opened a pull request: https://github.com/apache/ignite/pull/1155 IGNITE-2356 IGFS client should be able to failover in case of server crash You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/a

[GitHub] ignite pull request #1150: Ignite 4041

2016-10-11 Thread devozerov
Github user devozerov closed the pull request at: https://github.com/apache/ignite/pull/1150 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is