Re: [SparkDataFrame] Query Optimization. Prototype

2018-01-23 Thread Serge Puchnin
yes, the Cust function is supporting both Ignite and H2. I've updated the documentation for next system functions: CASEWHEN Function, CAST, CONVERT, TABLE https://apacheignite-sql.readme.io/docs/system-functions And for my mind, next functions aren't applicable for Ignite: ARRAY_GET, ARRAY_LENGT

Re: Ignite not friendly for Monitoring

2018-01-16 Thread Serge Puchnin
It might be an issue: https://issues.apache.org/jira/browse/IGNITE-3690 I'm going to update it when the domain list will be agreed upon by the community. -- Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/

Re: Ignite not friendly for Monitoring

2018-01-15 Thread Serge Puchnin
Igniters, It's a right idea! Let's try to revitalize it and make a move on. As a first step, I would like to propose a list of a top-level domain. -- the phase 1 1. UnExpected, UnKnown 2. Cluster and Topology Discovery Segmentation Node Startup Commun

Re: sql documentation

2017-09-14 Thread Serge Puchnin
hich > is crystal clear: > https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/ > > Not 100% sure about “Java Developer Guides” section. Let me contemplate a > bit and propose other solutions. > > — > Denis > > On Sep 13, 2017, at 3:41 AM, Serge Puchnin >

Re: sql documentation

2017-09-13 Thread Serge Puchnin
d like to fix some > phrasing on the page. > > On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin > wrote: > > > I've added a page for SQL language, create index statement and Upper > > function as an example for the new format: > > > > https:/

Re: sql documentation

2017-09-12 Thread Serge Puchnin
ion > domain > >>>> for all our SQL capabilities: > >>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql. > >>>> readme.io/docs> > >>>> > >>>> Once I get an open source license for it we can start moving t

Re: sql documentation

2017-08-30 Thread Serge Puchnin n
r other storage. > > — > Denis > >> On Aug 29, 2017, at 2:38 AM, Serge Puchnin wrote: >> >> Hi ! >> >> As I can see, there is some room for documentation improvement. >> As a sample of documentation, I've prepared a description of "CREATE INDEX&quo

sql documentation

2017-08-29 Thread Serge Puchnin
Hi ! As I can see, there is some room for documentation improvement. As a sample of documentation, I've prepared a description of "CREATE INDEX" statement. What’s your opinion? What can be improved? What should be added? Thanks a lot! --- Serge

Re: Multi-Version Concurrency Control

2017-08-21 Thread Serge Puchnin
There are some updates and clarifications for the approach. About Multi/Single Node Operations To improve performance for single-partition operations it's possible to separate single-partitions and multi-partitions transactions. A single-partition operation sends a put/get directly to the required

Re: Multi-Version Concurrency Control

2017-08-16 Thread Serge Puchnin
ot; - may be we should give another name to not > intersect with JVM GC? > > Thanks! > > On Tue, Aug 15, 2017 at 8:11 PM, Serge Puchnin n > wrote: > >> Hello Ignite Developers, >> >> I’d like to start a discussion about the design of MVCC implementation >

Re: Default page size must be changed to 4k. Should it be backwards compatible?

2017-08-15 Thread Serge Puchnin
#1 option looks more predictable. But it's possible to add a message "for better IO performance please migrate to 4K-pages". BR, Serge On Wed, 16 Aug 2017 at 03:46, Dmitriy Setrakyan wrote: > I like #1 if possible. Of course, if the LFS is empty, then the new default > should be 4k. > > On Tue