Menu
▾
▴
Re: [Bigdata-developers] Order by and search
|
From: Bryan T. <br...@sy...> - 2014-11-05 15:21:03
|
Is there a public endpoint and query that I can use to test this? If this is local data, is there a small data set that we can use to replicate the problem? In general, the ORDER BY operator should execute once ALL solutions have been materialized within that operator. It then applies the sort and the solutions are reported. My questions would be: - What is the EXPLAIN of the query? - Does a simple unit test of the MemorySortOp show the same problem? That is, is this related to the MemorySortOp implementation or the query engine / query plan generator? - Are there any odd things going on with the unicode setup? Are the characters "a" and "a" really the same characters. 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. On Wed, Nov 5, 2014 at 10:15 AM, Jim Balhoff <ba...@ne...> wrote: > > 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. > > > > > > > |
