Re: [Bigdata-developers] Order by and search

[Jim B. <ba...@ne...>]

> On Nov 5, 2014, at 6:22 AM, Bryan Thompson <br...@sy...> wrote:
> 
> Jim,
> 
> I know that Jeremy had made a change to the order by operator a few months ago.  Are you using the current code?

I am testing with branch BIGDATA_RELEASE_1_3_0, revision 8702, which I think is the latest.

> 
> Can you online an example of the out of order results?

Here is the result of the below query: https://dl.dropboxusercontent.com/u/6704325/bigdata/2014-11-5/bigdata_order_by.csv

At the beginning you will see:
anterior humeral ridge
anteroventral process of cleithrum
columnar area
deltoid process

Then at line 286 the 'a's start again:
YSL
Zymbal's gland
abdomen
abdomen blood vessel
abdomen connective tissue
abdomen element
abdomen musculature


Thanks,
Jim




> 
> Bryan
> 
> On Tuesday, November 4, 2014, Jim Balhoff <ba...@ne...> wrote:
> Hi Bryan,
> 
> I think that the text search may have been a red herring. I tried a query without search to compare the EXPLAIN results and realized that ORDER BY is not working for a basic query of all labels. Has anyone been using it successfully? My query is this:
> 
> **************
> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
> PREFIX owl: <http://www.w3.org/2002/07/owl#>
> 
> SELECT DISTINCT ?term ?term_label
> WHERE
> {
> ?term rdf:type owl:Class .
> ?term rdfs:label ?term_label .
> }
> ORDER BY ?term_label
> **************
> 
> I also tried `ORDER BY STR(?term_label)`. The results are different but still not fully in order. The results have large blocks of correct ordering but contain misplaced blocks as well. I'm not really sure how to interpret all of the EXPLAIN output. I attached the explanation in case you have time to take a look at it. Perhaps I am missing something obvious!
> 
> Thank you,
> Jim
> 
> 
> 
> > On Nov 4, 2014, at 7:53 PM, Bryan Thompson <br...@sy...> wrote:
> >
> > Jim,
> >
> > Today, and for probably 1-2 years now, search is translated into a SERVICE call.  Triple patterns are pulled into that service call based on the shared variable bindings.  However, the recommended approach is to Actually specify the service call directly.   This will probably give you the desired control over the ordering of the results.
> >
> > I am not sure why the ordering was not obeyed.  Can you look into the EXPLAIN of the query and see if you can identify what is going on?  I may then be able to point you towards how to resolve the ticket.
> >
> > Thanks,
> > Bryan
> >
> >
> >
> > --
> > ----
> > Bryan Thompson
> > Chief Scientist & Founder
> > SYSTAP, LLC
> > 4501 Tower Road
> > Greensboro, NC 27410
> > br...@sy...
> > http://bigdata.com
> > http://mapgraph.io
> > CONFIDENTIALITY NOTICE:  This email and its contents and attachments are for the sole use of the intended recipient(s) and are confidential or proprietary to SYSTAP. Any unauthorized review, use, disclosure, dissemination or copying of this email or its contents or attachments is prohibited. If you have received this communication in error, please notify the sender by reply email and permanently delete all copies of the email and its contents and attachments.
> >
> >
> >
> 
> 
> -- 
> ----
> Bryan Thompson
> Chief Scientist & Founder
> SYSTAP, LLC
> 4501 Tower Road
> Greensboro, NC 27410
> br...@sy...
> http://bigdata.com
> http://mapgraph.io
> CONFIDENTIALITY NOTICE:  This email and its contents and attachments are for the sole use of the intended recipient(s) and are confidential or proprietary to SYSTAP. Any unauthorized review, use, disclosure, dissemination or copying of this email or its contents or attachments is prohibited. If you have received this communication in error, please notify the sender by reply email and permanently delete all copies of the email and its contents and attachments.
> 
> 
>