> Just interesting, will be some sort of SQL supported to create indexes for > example from Visor-console in interactive mode? >
If visor console starts node and provides whole cache API then yes, otherwise we have to add special command. Anyways I think we should do it in a separate step. Sergi > On Mon, Jun 1, 2015 at 9:41 PM, Sergi Vladykin <sergi.vlady...@gmail.com> > wrote: > > > Yo guys! > > > > I think it is time to start implementing this feature since it became > > really relevant lately. > > > > Currently we have static indexing configuration via either > > CacheConfiguration.setIndexedTypes or CacheConfiguration.setTypeMetadata. > > Now we want to have IgniteCache API methods like createIndex/dropIndex > > which will allow to modify index layout at runtime without cluster > restart. > > > > I think on the public API side we have to create index description > classes > > like SQLSortedIndex, FulltextIndex, SQLGeospatialIndex. I personally > don't > > like approach with weirdly structured maps which we have in > > CacheTypeMetadata, but there it was done for simpler Spring XML support. > > > > From the implementation standpoint I think we have to utilize replicated > > transactional sys cache with continous queries to listen updates from it. > > Put index description objects there and handle these updates on all the > > interested nodes. > > > > On start each cache has to attempt load its initial index configuration > > transactionally or if it already exists, then utilize runtime > configuration > > from cluster. > > > > At Indexing level we have to just find needed GridH2Table, take write > lock > > on it, add index, fill it with data from primary index and release the > > write lock. Non-blocking approach we can implement further. > > > > Index drop is basically the same. > > > > Lets discuss API and implementation here and then I'll create jira issue > > with final description. > > > > By the way I am a bit busy to implement this stuff myself, so anyone > > interested please go ahead! > > > > Sergi > > > > > > -- > Alexey Kuznetsov > GridGain Systems > www.gridgain.com >
