Re: [Virtuoso-users] strange error when bulk-loading Turtle files

Changing ttlpv.sql to use insert soft (and also making sure to use the stored id) appears to fix the problem I am encountering. I prepared a modified ttlpv.sql (attached) and reinstalled Virtuoso as follows: cd /home/virtuoso/test killall virtuoso-t rm -rf vos cp ttlpv.sql

Re: [Virtuoso-users] strange error when bulk-loading Turtle files

/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 > > > >

Re: [Virtuoso-users] strange error when bulk-loading Turtle files

That's not my experience on several machines. I've experienced this bug on two servers, one running CentOS release 6.9 (Final) and one running Ubuntu 16.04.5 LTS. The bug depends at least on loading in parallel *and* encountering new language tags. Loading the files a second time will almost

Re: [Virtuoso-users] strange error when bulk-loading Turtle files

I created some synthetic data that tickles the bug reliably on my machine with a standard virtuoso.ini (just adding the directory for the files to the allowed list). I'm attaching the generator program for the files and a loading script. peter On 12/18/18 9:46 AM, Peter F. Patel-Schneider

Re: [Virtuoso-users] strange error when bulk-loading Turtle files

um.com/virtuoso-blog >> Data Access Drivers >> Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers >> LinkedIn -- http://www.linkedin.com/company/openlink-software/ >> Twitter  -- http://twitter.com/OpenLink >> Google+  -- http://plus.google

Re: [Virtuoso-users] strange error when bulk-loading Turtle files

penLink > Google+  -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > > > >> On 11 Dec 2018, at 17:45, Peter F. Patel-Schneider > <mailto:

[Virtuoso-users] strange error when bulk-loading Turtle files

I'm loading a bunch of Turtle files and I'm getting the error 2300 TURTLE RDF loader, line 1012: SR197: Non unique primary key on DB.DBA.RDF_LANGUAGE The line in question looks fine: "Wikimedia template"@ki, The line before it may indicate the issue "Wikimedia template"@kg,

[Virtuoso-users] context-sensitive syntax for transitive paths in Virtuoso open source

I'm getting a strange syntax error from Virtuoso Open Source related to transitive paths. Connected to OpenLink Virtuoso Driver: 07.20.3230 OpenLink Virtuoso ODBC Driver SQL> SPARQL PREFIX wdt: SELECT ( COUNT (DISTINCT ?s) AS ?subclasses ) WHERE { GRAPH

[Virtuoso-users] memory consumption when loading large triple files

I'm loading a large Turtle file with almost 7 billion triples in it. As the file is loaded virtuoso takes up more and more memory, much more than it should. I had set it for 24GB of memory available on a machine with 32GB of memory but eventually it took up all the available virtual memory and

Re: [Virtuoso-users] Error SR078: The result set is too long, must limit result for at most 2097151 rows

acebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > > >> On 6 Sep 2018, at 09:30, Peter F. Patel-Schneider >> wrote: >> >> I had already bumped into the limit that you found.

Re: [Virtuoso-users] Error SR078: The result set is too long, must limit result for at most 2097151 rows

m. It can be partially solved by modifying > the code of Virtuoso to remove the hardcoded limit. It implies recompiling > Virtuoso. This issue is commented here: > > https://github.com/openlink/virtuoso-opensource/issues/700 > > Daniel > > > On Wed, 05 Sep 2018 21:

[Virtuoso-users] Error SR078: The result set is too long, must limit result for at most 2097151 rows

I'm trying to extract information from a large triple store and I'm running into Error SR078, which appears to be a hard limit on the number of rows in a result to 2^21 (for a 64 bit machine). I'm using the http interface and I've already increased the maximum number of http results to well more

Re: [Virtuoso-users] Virtuoso SPARQL tab separated results with language tags and dataypes

Yes, that has the language tag side. There is also the datatype side that would be shown with Work/runtime. peter On 08/22/2018 10:08 AM, Kingsley Idehen wrote: > On 8/22/18 12:01 PM, Peter F. Patel-Schneider wrote: >> More or less, except that CSV output doesn't include lang

Re: [Virtuoso-users] Virtuoso SPARQL tab separated results with language tags and dataypes

09519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > > >> On 22 Aug 2018, at 16:43, Peter F. Patel-Schneider >> wrote: >> >> Try >> >> curl http://dbped

Re: [Virtuoso-users] Virtuoso SPARQL tab separated results with language tags and dataypes

f CSV that included language tags and datatypes, but conforming to the requirements of TSV output would be better.) peter On 08/22/2018 08:51 AM, Kingsley Idehen wrote: > On 8/22/18 11:43 AM, Peter F. Patel-Schneider wrote: >> Try >> >> curl http://dbpedia.org/sparql --get

Re: [Virtuoso-users] geometry data type in virtuoso

Hi: Has there been any progress on handling non-earth coordinates in Virtuoso (either open source or otherwise)? peter On 11/11/2016 10:01 AM, Kingsley Idehen wrote: > On 11/11/16 12:04 PM, Peter F. Patel-Schneider wrote: >> My experience is different. I refreshed virtuoso o

Re: [Virtuoso-users] geometry data type in virtuoso

his time ;) > > So it is just a feature not yet implemented... > > Regards, > Jerven > > On 2016-11-10 14:06, Kingsley Idehen wrote: >> On 11/9/16 10:25 PM, Peter F. Patel-Schneider wrote: >>> Through a process of bisection I found the datum that is not handled >

Re: [Virtuoso-users] geometry data type in virtuoso

So when you implied that wd:Q24227 a wikibase:Item ; wdt:P625 "<http://www.wikidata.org/entity/Q111> Point(351.83 -14.47)"^^geo:wktLiteral . had an invalid triple you didn't really mean that. peter On 11/10/2016 10:24 AM, Kingsley Idehen wrote: > On 11/10/16 12:13 PM, Peter

Re: [Virtuoso-users] geometry data type in virtuoso

metric value, the examples in the spec enclose the URIs in <>. I would expect that implementations of geo:wktLiteral would thus allow enclosing <>. Peter F. Patel-Schneider Nuance Communications On 11/10/2016 05:06 AM, Kingsley Idehen wrote: > On 11/9/16 10:25 PM, Peter F. Patel-

Re: [Virtuoso-users] geometry data type in virtuoso

- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > >> On 9 Nov 2016, at 02:34, Peter F. Patel-Schneider <pfpschnei...@gmail.com >> <mailto:pfpschnei.

[Virtuoso-users] geometry error when loading Wikidata dump

ogle.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > >> On 9 Nov 2016, at 02:34, Peter F. Patel-Schneider <pfpschnei...@gmail.com >> <mailto:pfpschnei...@gmail.com>

Re: [Virtuoso-users] geometry data type in virtuoso

.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/OpenLinkSoftwar

[Virtuoso-users] geometry data type in virtuoso

Hi: I'm trying to get virtuoso to work with geometry data types. I noticed that the version of virtuoso that I am using requires that the data type names be in ALL CAPS (e.g., POINT). Has this been fixed in the current version of virtuoso? peter