Re: ignite .net index group definition

2018-10-01 Thread Pavel Tupitsyn
You should not have to revert to Spring XML. Just use QueryIndex class in C# and pass field names there in desired order to create a group index. new CacheConfiguration(...) { Indexes = new[] {

Re: ignite .net index group definition

2018-10-01 Thread Ilya Kasnacheev
Hello! You can also use CREATE TABLE/INDEX and then any API that you like to query data (i.e. SQL, Cache API, REST). How the cache was created doesn't affect its usage much. Regards, -- Ilya Kasnacheev пн, 1 окт. 2018 г. в 11:07, wt : > So are you saying that i have to revert to the spring

Re: ignite .net index group definition

2018-10-01 Thread wt
So are you saying that i have to revert to the spring xml to get this done? I am using query entities when trying to do this but the order field doesn't seem to apply in the .net API. foreach (var field in item.Columns) { properties.Add(new Property()

Re: ignite .net index group definition

2018-09-27 Thread Pavel Tupitsyn
Hi, Yes, attribute-based configuration is limited in this regard. But, as Ilya said, `CacheConfiguration.QueryEntities` gives you full control to achieve the same. Thanks, Pavel On Thu, Sep 27, 2018 at 6:46 PM ilya.kasnacheev wrote: > Hello! > > Unfortunately this looks like a genuine

Re: ignite .net index group definition

2018-09-27 Thread ilya.kasnacheev
Hello! Unfortunately this looks like a genuine limitation of .Net's QuerySqlField. You can try specifying those indexes with QueryEntities or CREATE INDEX instead to have more control. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite .net index group definition

2018-09-26 Thread wt
anyone? i have tried applying it like this but it just creates 2 indexes [QuerySqlField(IsIndexed = true, IndexGroups = new[] { "name=aa,order=1" })] My understanding is under the hood it is essentially btree index and these index structures require an ordinal column configuration to build

ignite .net index group definition

2018-09-26 Thread wt
Hi In java a the index groups are defined in a way that makes sense e.g. @QuerySqlField(orderedGroups={@QuerySqlField.Group( name = "age_salary_idx", order = 0, descending = true)}) in .net however it looks like this [QuerySqlField(IsIndexed =true, IndexGroups = new[] {"someIndexGroup"})]