Interesting, I get that too this morning but last night the server hung for
a while and then reported that it was unavailable. Perhaps it was a
coincidence.
Thank you for the documentation link.
On 3 December 2013 21:40, Hugh Williams <hwilli...@openlinksw.com> wrote:
> Hi Quentin,
>
> Your (crash) query gives the following error against my local instance
> (with the data loaded) and even against DBpedia:
>
> Virtuoso 37000 Error TR...: T_STEP argument refers to an index 2 of a column
> s that is not in T_IN list (T_DIRECTION is set to 1)
>
> SPARQL query:
> define sql:big-data-const 0
> #output-format:text/html
> define sql:signal-void-variables 1 define input:default-graph-uri
> <http://dbpedia.org> prefix : <http://example.org/ontology/test/>
> with <http://example.org/dataset/test/>
> SELECT
> *
> WHERE
> {
> {
> SELECT ?anchor ?s ?p ?o
> WHERE
> {
> ?anchor ?pred ?s .
> ?s ?p ?o .
> }
> }
> OPTION ( TRANSITIVE,
> t_distinct,
> t_in(?anchor),
> t_out(?s),
> t_min (0),
> t_max (3) ,
> t_no_cycles,
> t_step (?s) as ?link, t_step ('path_id') as ?path,
> t_step ('step_no') as ?dist ) .
> FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
> }
> ORDER BY ?dist
>
>
> Additional information on transitivity and the t_direction param can be
> found in the Virtuoso SQL documentation, which SPARQL makes use of, at:
>
>
> http://docs.openlinksw.com/virtuoso/transitivityinsQL.html#transitivityinsQL
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 3 Dec 2013, at 07:48, Quentin <quent...@clearbluewater.com.au> wrote:
>
> Prematurely sent.
>
> The query that gets me 'almost' there is:
> =========================
> prefix : <http://example.org/ontology/test/>
> with <http://example.org/dataset/test/>
> SELECT
> *
> WHERE
> {
> {
> SELECT ?anchor ?s ?p ?o
> WHERE
> {
> ?anchor ?anchorPred ?s .
> ?s ?p ?o .
> }
> }
> OPTION ( TRANSITIVE,
> t_distinct,
> t_in(?anchor),
> t_out(?s),
> t_min (0),
> t_max (3) ,
> t_no_cycles,
> t_step (?anchor) as ?link, t_step ('path_id') as ?path,
> t_step ('step_no') as ?dist ) .
> FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
> }
> ORDER BY ?dist
> =========================
>
>
> On 3 December 2013 18:47, Quentin <quent...@clearbluewater.com.au> wrote:
>
>>
>> Assuming some data as below:
>> ========================================
>> prefix : <http://example.org/ontology/test/>
>> with <http://example.org/dataset/test/>
>> insert
>> {
>> <http://example.org/data/test/DummyClass_1> a :DummyClass .
>> <http://example.org/data/test/DummyClass_1> :predA "Entity 1" .
>> <http://example.org/data/test/DummyClass_1> :objPred <
>> http://example.org/data/test/DummyClass_2> .
>> <http://example.org/data/test/DummyClass_2> a :DummyClass .
>> <http://example.org/data/test/DummyClass_2> :predA "Entity 2" .
>> <http://example.org/data/test/DummyClass_2> :objPred <
>> http://example.org/data/test/DummyClass_3> .
>> <http://example.org/data/test/DummyClass_3> a :DummyClass .
>> <http://example.org/data/test/DummyClass_3> :predA "Entity 3" .
>> <http://example.org/data/test/DummyClass_3> :objPred <
>> http://example.org/data/test/DummyClass_4> .
>> <http://example.org/data/test/DummyClass_4> a :DummyClass .
>> <http://example.org/data/test/DummyClass_4> :predA "Entity 4" .
>> <http://example.org/data/test/DummyClass_4> :objPred <
>> http://example.org/data/test/DummyClass_1> .
>> }
>> ========================================
>> I want to get some results back that include every triple from some
>> anchor point to a given depth. So, say I start with <
>> http://example.org/data/test/DummyClass_1> and use depth 2, I'd like to
>> get everything for DummyClass_1/DummyClass_2/DummyClass_3 but not
>> DummyClass_4.
>>
>> I figure this might be possible with transitivity and the OPTION clause
>> but I can't seem to get more than about 90% to what I need.
>>
>>
>>
>>
>>
>>
>> Secondly, I got a DB crash doing this query with the below data:
>> ===================================================
>> prefix : <http://example.org/ontology/test/>
>> with <http://example.org/dataset/test/>
>> SELECT
>> *
>> WHERE
>> {
>> {
>> SELECT ?anchor ?s ?p ?o
>> WHERE
>> {
>> ?anchor ?pred ?s .
>> ?s ?p ?o .
>> }
>> }
>> OPTION ( TRANSITIVE,
>> t_distinct,
>> t_in(?anchor),
>> t_out(?s),
>> t_min (0),
>> t_max (3) ,
>> t_no_cycles,
>> t_step (?s) as ?link, t_step ('path_id') as ?path,
>> t_step ('step_no') as ?dist ) .
>> FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
>> }
>> ORDER BY ?dist
>> ===================================================
>> I'm pretty sure this is because I used ?s in the t_step parameter
>> instead of ?anchor but I'm not quite sure why this caused a crash.
>> This seems to occur on DBPedia also (sorry).
>>
>> --
>> Quentin | Clear Blue Water Pty Ltd
>> quent...@clearbluewater.com.au
>>
>
>
>
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
