Re: [Virtuoso-users] large load failed

2013-05-14 Thread Mark Thompson
Hi all, I want to confirm the issue raised by Roland Cornelissen yesterday. In my case, all is fine with gzipped .nt files up to 80MB (15M triples), but trying to load a 250MB .nt file using ld_dir() in VOS version: "Version 07.00.3202-pthreads for Darwin as of Apr 7 2013" (see attached config

Re: [Virtuoso-users] Sparql using delete insert problem

2013-05-14 Thread Ivan Mikhailov
Hello Vishesh, The query says: For every triple nao:lastModified ?mod found in database (if any), prepare future removal of nao:lastModified ?mod and prepare insertion of nao:lastModified "2012-01-29T16:29:11Z"^^xsd:dateTime . When all (if any) operations are prepared, perform the actual edi

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Jerven Bolleman
Ivan, On 14/05/13 16:23, Ivan Mikhailov wrote: > Jerven, > > Indeed it's a departure from the standard. We've described our SPARQL-BI > implementation to the WG, we've warned them that SPARQL 1.1 path > expressions will be implemented as syntax sugar over SQL transitive > subqueries, that's all. If

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Ivan Mikhailov
Jerven, Indeed it's a departure from the standard. We've described our SPARQL-BI implementation to the WG, we've warned them that SPARQL 1.1 path expressions will be implemented as syntax sugar over SQL transitive subqueries, that's all. If we invent a scalable way of handling transitive paths wit

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Jerven Bolleman
Hi Ivan, I understand you reasoning. But it is a departure from the standard. Which seems silly to me because this works. PREFIX rdfs: CONSTRUCT { ?sub rdfs:subClassOf ?super .} FROM WHERE { ?sub rdfs:subClassOf [] .

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Ivan Mikhailov
Hello Jerven, In Virtuoso, transitive queries should have some equality at one end of chain (or at both ends). It may be relaxed in the future, but now it may requires some additional refinement on one of variables. It's not bad idea anyway; in most cases you don't want to get a result set with al

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Jerven Bolleman
Hi Hugh, That is not a SPARQL 1.1 requirement. Are the developers aiming to remove this constraint? Anyway, I then hit the next roadblock. Exception:virtuoso.jdbc3.VirtuosoException: TN...: Exceeded 10 bytes in transitive temp memory. use t_distinct, t_max or more T_MAX_memory optio

Re: [Virtuoso-users] Path query with * not supported yet?

2013-05-14 Thread Hugh Williams
Hi Jerven, Either ?sub or ?super (or both) should appear in some non-transitive triple pattern to specify at least one of transitive ends. See the following property path examples: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksSPARQL11PropertyPaths Best R

[Virtuoso-users] Sparql using delete insert problem

2013-05-14 Thread Vishesh Handa
Hey guys I've been trying to update some statements in a graph, and I have been using the following query - WITH DELETE { nao:lastModified ?mod . } INSERT { nao:lastModified "2012-01-29T16:29:11Z"^^xsd:dateTime . } WHERE { nao:lastModified ?mod . } This works fine in the case when the nao:l

Re: [Virtuoso-users] Path query with * not supported yet?

2013-05-14 Thread Jerven Bolleman
Hi All, My fallback query, which uses rdfs:subClassOf/ to a depth of 25 and unions them, does not seem to produce results but does use near 100% single thread CPU. The graph this runs on has about 55548 triples in it. status('rhck') gives Running Statements: Time (msec) Text 1028035 s

[Virtuoso-users] Path query with * not supported yet?

2013-05-14 Thread Jerven Bolleman
Hi All, When executing PREFIX rdfs: CONSTRUCT { ?sub rdfs:subClassOf ?super .} FROM WHERE { ?sub (rdfs:subClassOf)* ?super } I get the following exception. Query evaluation failed:PREFIX rdfs: