ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitriy Setrakyan <dsetrak...@apache.org>
Subject Re: Performance of join SQL queries
Date Fri, 14 Aug 2015 16:28:22 GMT
On Fri, Aug 14, 2015 at 9:17 AM, Sergi Vladykin <sergi.vladykin@gmail.com>
wrote:

> Dmitriy,
>
> The code is located in some separate *GridGain* git repository
> https://github.com/gridgain/gridgain-advanced-examples.
> I don't think I have any commit rights on it.
>

You should have commit rights to it (I just checked).



> BTW, I don't understand why we have Ignite examples in this strange
> separate repository, I can guarantee that this way they will become
> outdated quite shortly.
>

Good point. We should at some point look through these examples and merge
them with our examples in master branch.


>
>
> Sergi
>
>
> 2015-08-14 17:33 GMT+03:00 Dmitriy Setrakyan <dsetrakyan@apache.org>:
>
>>
>>
>> On Fri, Aug 14, 2015 at 3:54 AM, Sergi Vladykin <sergi.vladykin@gmail.com
>> > wrote:
>>
>>> 1) Ok, sorry for that, will be fixed soon.
>>> https://issues.apache.org/jira/browse/IGNITE-1249
>>>
>>
>> Sergi, is this just an annotation fix in an example? In that case, it
>> seems like a very quick fix. Do you mind fixing it and closing the ticket?
>>
>>
>>>
>>>
>>> 2) No problem, will do.
>>>
>>> 3) You can start with -100500 and finish with Integer.MAX_VALUE as well,
>>> these numbers only needed for fields sorting inside of a group, they don't
>>> have any other meaning.
>>>
>>> 4)  It must be this way @QuerySqlField(index=true, orderedGroups =
>>> {@QuerySqlField.Group(name = "grp1", order =
>>> 1), @QuerySqlField.Group(name = "grp2", order = 2)})
>>>
>>> I think you are using Java 8, currently Ignite is targeted to Java 7
>>> where it is impossible to use the same annotation twice for the same field.
>>>
>>> Sergi
>>>
>>>
>>> 2015-08-14 11:26 GMT+03:00 alex.glau <alex.glau@gmail.com>:
>>>
>>>> Hi Sergi,
>>>>
>>>> 1) Group index example is in:
>>>>
>>>> https://github.com/gridgain/gridgain-advanced-examples/blob/master/src/main/java/org/gridgain/examples/datagrid/query/GroupIndexExample.java
>>>>
>>>> 2) Can you add the syntax of group index to documentation?
>>>>
>>>> 3) Is ordering of group index started from 0 or from 1?
>>>>
>>>> 4) If some field has individual index and in addition is participated in
>>>> several group indexes, the set of annotations should look like:
>>>>
>>>> @QuerySqlField(index=true)
>>>> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "grp1",
>>>> order =
>>>> 1)})
>>>> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "grp2",
>>>> order =
>>>> 2)})
>>>>
>>>> or
>>>>
>>>> @QuerySqlField(index=true)
>>>> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "grp1",
>>>> order =
>>>> 1), @QuerySqlField.Group(name = "grp2", order = 2)})
>>>>
>>>> which variant is right?
>>>>
>>>> Thanks,
>>>> Alex.
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>> http://apache-ignite-users.70518.x6.nabble.com/Performance-of-join-SQL-queries-tp845p977.html
>>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>>>
>>>
>>>
>>
>

Mime
View raw message