Re: SQL query and Indexes architecture

2018-09-20 Thread Павлухин Иван
Hi Eugene, In community wiki there are several "under the hood" documents like [1]. Unfortunately there is no document about SQL. It seems that such document would be useful for you and many others. Perhaps, if you have habit to document your findings (in blogs or somewhere else) it could become v

Re: SQL query and Indexes architecture

2018-09-17 Thread Ilya Kasnacheev
Hello! I recommend starting with H2TreeIndex class. Maybe dropping mails on developer list with precise questions. Regards, -- Ilya Kasnacheev пн, 17 сент. 2018 г. в 16:25, eugene miretsky : > Thanks! > > I am curious about the process of loading data from Ignite to H2 on the > fly, as H2 cre

Re: SQL query and Indexes architecture

2018-09-17 Thread eugene miretsky
Thanks! I am curious about the process of loading data from Ignite to H2 on the fly, as H2 creating indexes but storing them in Ignite. Can you point me to some JIRAs that discuss it, or which part of the code is responsible for that? On Mon, Sep 17, 2018 at 9:18 AM Ilya Kasnacheev wrote: > Hel

Re: SQL query and Indexes architecture

2018-09-17 Thread Ilya Kasnacheev
Hello! 1. 1. H2 executes the query, during which it has to load rows from tables, and Ignite does the row loading part. Then Ignite will collect query results on all nodes and aggregate them on a single node. 1. 2. Index is created by H2, but it is stored in Ignite pages (?). 2. Maybe you're right

Re: SQL query and Indexes architecture

2018-09-17 Thread eugene miretsky
Thanks! 1. 1. "Ignite feeds H2 rows that it asks for, and H2 creates indexes on them and executes queries on them." - what exactly do you mean by that? Do you mean that all parts of a query that use indexes are executed by H2, then the actual data is retrieved from Ignite

Re: SQL query and Indexes architecture

2018-09-17 Thread Ilya Kasnacheev
Hello! 1. H2 does not store data but, as far as my understanding goes, it created SQL indexes from data. Ignite feeds H2 rows that it asks for, and H2 creates indexes on them and executes queries on them. 2. Ignite always has special index on your key (since it's a key-value storage it can always

Re: SQL query and Indexes architecture

2018-09-15 Thread Gaurav Bajaj
Hello, Please find below link to SQL documentation : https://apacheignite-sql.readme.io/docs/overview You will find answers to most of your queries here. 1. H2 is only used as SQL query parsing engine and for generating execution plans. Data was/is always stored in Caches. 3. All kind of quer

SQL query and Indexes architecture

2018-09-14 Thread eugene miretsky
Hello, Trying to understand how exactly SQL queries are executed in Ignite. A few questions 1. To what extent is H2 used? Does it store the data? Does it create the indexes? Is it used only for generating execution plans? I believe that all the data used to be stored in H2, but with the