Re: [Bigdata-developers] Order by and search

[Bryan T. <br...@sy...>]

Jim,

I know that Jeremy had made a change to the order by operator a few months
ago.  Are you using the current code?

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

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...
> <javascript:;>> 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... <javascript:;>
> > 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.