Vladimir, Thanks for looking into this. The workaround blows out my mind :) Anyway, would you mind documenting? You’ll be able to explain it better than me.
— Denis > On Sep 14, 2017, at 1:05 AM, Vladimir Ozerov <voze...@gridgain.com> wrote: > > Denis, > > As far as DML, I debugged the problem. Currently we wrap key fields in a > wrapper type. This is done for two reasons: > 1) This is absolutely must for composite primary keys > 2) To avoid clashes with other tables, should we decide to support CREATE > TABLE on existing caches. E.g., without it if you create two tables with > the same "LONG" PK in the same cache, they will overlap each other. > > On the other hand this decision leads to two types of problems: > 1) We loose space on primitive keys - 24 bytes overhead for binary object > infrastructure > 2) We have difficulties with collocation - this is what you spotted. > > Your problem can be resolved as follows: > CREATE TABLE `country` ... WITH "template=partitioned, backups=1, > *affinityKey=code*" > > As we have a workaround, I would propose to update docs for now, and treat > it as usability issue. We will fix it as a part of 2.3. > > Thoughts? > > > On Thu, Sep 14, 2017 at 1:25 AM, Denis Magda <dma...@apache.org> wrote: > >> Unfortunately, in addition to the minor concern below I’ve stumbled on >> showstoppers. >> >> 1) SQL doesn’t work in Web Console: https://issues.apache.org/ >> jira/browse/IGNITE-6374 <https://issues.apache.org/jira/browse/IGNITE-6374 >>> >> 2) Some issue with CREATE TABLE’s affinityKey command or DML being use: >> https://issues.apache.org/jira/browse/IGNITE-6375 < >> https://issues.apache.org/jira/browse/IGNITE-6375> >> >> Let’s not release one emergency release after another making sure that the >> quality of this is satisfactory. >> >> — >> Denis >> >>> On Sep 13, 2017, at 2:30 PM, Denis Magda <dma...@apache.org> wrote: >>> >>> Guys, >>> >>> Another point of concern. After building the binaries from sources and >> starting a node from a terminal >>> >>> ./ignite.sh ../examples/config/example-ignite.xml >>> >>> the node automatically turns off the QUIET mode and the terminal window >> is swamped by all the sort of noisy INFO logs. >>> >>> The same is not reproduced with 2.2.0-rc1 binary bundles. >>> >>> What’s the reason of that? I strictly followed the DEVNOTES. >>> >>> It’s not a showstopper anyway but has to be fixed the next release then. >>> >>> — >>> Denis >>> >>>> On Sep 13, 2017, at 1:44 AM, Anton Vinogradov <a...@apache.org> wrote: >>>> >>>> Officially cancelling the vote according to found issues. >>>> >>>> On Wed, Sep 13, 2017 at 8:19 AM, Denis Magda <dma...@gridgain.com >> <mailto:dma...@gridgain.com>> wrote: >>>> >>>>> How could we miss these binaries? Isn't the release procedure automated >>>>> ODBC installers creation? I thought a smoke-testing is done for a final >>>>> release deliverable. >>>>> >>>>> Restarting the vote I guess? >>>>> >>>>> -- >>>>> Denis >>>>> >>>>> On Tuesday, September 12, 2017, Igor Sapego <isap...@apache.org> >> wrote: >>>>> >>>>>> Wait, there is no platforms\cpp\bin directory with odbc >>>>>> installers in binary release. Can someone double-check? >>>>>> >>>>>> >>>>>> Best Regards, >>>>>> Igor >>>>>> >>>>>> On Tue, Sep 12, 2017 at 7:44 PM, Igor Sapego <isap...@apache.org >>>>>> <javascript:;>> wrote: >>>>>> >>>>>>> +1 >>>>>>> >>>>>>> Checked: >>>>>>> - Building of x86 and amd64 versions of C++ binaries. >>>>>>> - Building of x86 and amd64 versions of ODBC. >>>>>>> - C++ examples. >>>>>>> >>>>>>> Best Regards, >>>>>>> Igor >>>>>>> >>>>>>> On Tue, Sep 12, 2017 at 6:16 PM, Andrey Gura <ag...@apache.org >> <mailto:ag...@apache.org> >>>>>> <javascript:;>> wrote: >>>>>>> >>>>>>>> +1 >>>>>>>> >>>>>>>> On Tue, Sep 12, 2017 at 6:09 PM, Kozlov Maxim <dreamx....@gmail.com >> <mailto:dreamx....@gmail.com> >>>>>> <javascript:;>> >>>>>>>> wrote: >>>>>>>>> +1 >>>>>>>>> >>>>>>>>>> 12 сент. 2017 г., в 17:36, Sergey Kozlov <skoz...@gridgain.com >> <mailto:skoz...@gridgain.com> >>>>>> <javascript:;>> >>>>>>>> написал(а): >>>>>>>>>> >>>>>>>>>> +1 >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Tue, Sep 12, 2017 at 5:21 PM, Vladimir Ozerov < >>>>>> voze...@gridgain.com <mailto:voze...@gridgain.com> <javascript:;> >>>>>>>>> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> +1 (binding) >>>>>>>>>>> >>>>>>>>>>> On Tue, Sep 12, 2017 at 4:24 PM, Pavel Tupitsyn < >>>>>> ptupit...@apache.org <mailto:ptupit...@apache.org> <javascript:;> >>>>>>>>> >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> +1 (binding) >>>>>>>>>>>> >>>>>>>>>>>> Checked: >>>>>>>>>>>> - Build from sources (Java, .NET) >>>>>>>>>>>> - Examples (.NET) >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Sep 12, 2017 at 11:40 AM, Ilya Suntsov < >>>>>>>> isunt...@gridgain.com <mailto:isunt...@gridgain.com> >> <javascript:;>> >>>>>>>>>>>> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> +1 >>>>>>>>>>>>> >>>>>>>>>>>>> Checked: >>>>>>>>>>>>> >>>>>>>>>>>>> - Build from sources >>>>>>>>>>>>> - Build examples (ML profile enabled) >>>>>>>>>>>>> - Checked md5, sha512 and signs >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> 2017-09-12 4:11 GMT+03:00 Denis Magda <dma...@apache.org >> <mailto:dma...@apache.org> >>>>>> <javascript:;>>: >>>>>>>>>>>>> >>>>>>>>>>>>>> +1 (binding) >>>>>>>>>>>>>> >>>>>>>>>>>>>> Built from sources and confirmed that ML profile is recovered >>>>> and >>>>>>>> its >>>>>>>>>>>>>> examples are running. >>>>>>>>>>>>>> >>>>>>>>>>>>>> — >>>>>>>>>>>>>> Denis >>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Sep 11, 2017, at 6:31 AM, Anton Vinogradov <a...@apache.org >> <mailto:a...@apache.org> >>>>>> <javascript:;>> >>>>>>>>>>> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Igniters, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> We have uploaded a 2.2.0 release candidate to >>>>>>>>>>>>>>> https://dist.apache.org/repos/dist/dev/ignite/2.2.0-rc1/ < >> https://dist.apache.org/repos/dist/dev/ignite/2.2.0-rc1/> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Git tag name is >>>>>>>>>>>>>>> 2.2.0-rc1 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> This release includes the following changes: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Ignite: >>>>>>>>>>>>>>> * Checkpointing algorithm optimized >>>>>>>>>>>>>>> * Default max memory size changed from 80% to 20% >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Ignite CPP: >>>>>>>>>>>>>>> * Now possible to start node with persistent store >>>>>>>>>>>>>>> * Ignite.setActive method added to C++ API >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Complete list of closed issues: >>>>>>>>>>>>>>> https://issues.apache.org/jira/issues/?jql=project%20% < >> https://issues.apache.org/jira/issues/?jql=project%20%> >>>>>>>>>>>>> 3D%20IGNITE%20AND% >>>>>>>>>>>>>> 20fixVersion%20%3D%202.2%20AND%20(status%20%3D% >>>>>>>>>>>>>> 20closed%20or%20status%20%3D%20resolved) >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> DEVNOTES >>>>>>>>>>>>>>> https://git-wip-us.apache.org/repos/asf?p=ignite.git;a=blob_ >> <https://git-wip-us.apache.org/repos/asf?p=ignite.git;a=blob_> >>>>>>>>>>>>>> plain;f=DEVNOTES.txt;hb=refs/tags/2.2.0-rc1 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> RELEASE NOTES >>>>>>>>>>>>>>> https://git-wip-us.apache.org/repos/asf?p=ignite.git;a=blob_ >> <https://git-wip-us.apache.org/repos/asf?p=ignite.git;a=blob_> >>>>>>>>>>>>>> plain;f=RELEASE_NOTES.txt;hb=refs/tags/2.2.0-rc1 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Please start voting. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> +1 - to accept Apache Ignite 2.2.0-RC1 >>>>>>>>>>>>>>> 0 - don't care either way >>>>>>>>>>>>>>> -1 - DO NOT accept Apache Ignite 2.2.0-RC1 (explain why) >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> This vote will go for 72 hours. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> Ilya Suntsov >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Sergey Kozlov >>>>>>>>>> GridGain Systems >>>>>>>>>> www.gridgain.com <http://www.gridgain.com/> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Best Regards, >>>>>>>>> Max K. >>> >> >>