When node gets select, it should create inmemory db and create there tables needed for executing that query. It require issue #43 so it must be done first. Next node should get needed tables from all nodes that have this data (get infro where data is from master - issue #45) - here a method in node must be implemented to execute that selec * from
selects.
(*) this is the point of this issue (2 and 3)
Select process will look like that:
Get create table statements from master for needed tables
Create them in in memory database (*)
Execute selects (select * from table) in all nodes pointed by master (these which contain that data) for all needed tables (*)
Serialize somehow ResultSets and send it to coordinating node
Coordinating node inserts (unserialized data) to created tables in in memory db performing distinct on our internal id
Perform sql query (our SELECT from client) on in memory db, then return result
When node gets select, it should create inmemory db and create there tables needed for executing that query. It require issue #43 so it must be done first. Next node should get needed tables from all nodes that have this data (get infro where data is from master - issue #45) - here a method in node must be implemented to execute that selec * from
(*) this is the point of this issue (2 and 3)
Select process will look like that: