Hi Dan, Ok, what is the actual maximum vector size error you are getting and what is the size of the result set you are typically seeking to save to a file, as generally if the result set is large processing it in chunks would be required.
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 22 Nov 2015, at 14:29, Davis, Daniel (NIH/NLM) [C] <daniel.da...@nih.gov> > wrote: > > Thanks Hugh, > > Changing that just got me to a maximum size vector error. Turns out there > are many takes on saving this to files using http_nt_triple(), > string_output(), string_to_file() through stored procedures, and that got me > through. > > The release of my URI preserving algorithm is Dec. 3rd, and after that I'll > lurk until NLM makes a decision on whether to change this to production, and > maybe add additional ontologies. > > I wanted to take the opportunity to thank you for your patient support as I > learned Virtuoso more deeply. Its been a project; you've helped. > > -Dan > ________________________________________ > From: Hugh Williams [hwilli...@openlinksw.com] > Sent: Saturday, November 21, 2015 8:37 PM > To: Davis, Daniel (NIH/NLM) [C] > Cc: virtuoso-users@lists.sourceforge.net > Subject: Re: [Virtuoso-users] output:format "NT" question > > Hi Daniel, > > A default virtuoso.ini file has a "ResultSetMaxRows = 10000” in the > "[SPARQL]" section which I imagine when using your initial script it was > hitting this restriction on max size of a SPARQL result set ... > > 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 16 Nov 2015, at 19:11, Davis, Daniel (NIH/NLM) [C] <daniel.da...@nih.gov> >> wrote: >> >> Guys, >> >> I still don’t know why it doesn’t work, but I’ve adapted >> https://www.mail-archive.com/virtuoso-users@lists.sourceforge.net/msg03950.html >> >> andhttp://joaorosilva.no-ip.org/wiki/doku.php/mainblog:dump_and_load_graphs_in_virtuoso >> to my own purposes and they seem to work well. >> >> From: Davis, Daniel (NIH/NLM) [C] >> Sent: Monday, November 16, 2015 1:09 PM >> To: virtuoso-users@lists.sourceforge.net >> Subject: output:format "NT" question >> >> I have a simple script to export triples, but it seems not to get all >> triples, but only about 10,000. I cannot guess what may be the problem. >> Any advice is appreciated. >> >> isql 1111 dba “$PASSWORD” BANNER=OFF BLOBS=ON VERBOSE=OFF ECHO=OFF >> PROMPT=OFF TIMEOUT=0 >fullmesh.nt <<EOF >> SPARQL >> define output:format "NT" >> PREFIX meshv: <http://id.nlm.nih.gov/mesh/vocab#> >> CONSTRUCT { ?s ?p ?o } >> WHERE { >> GRAPH <http://id.nlm.nih.gov/mesh> { >> ?s ?p ?o >> } >> }; >> EOF >> >> >> Dan Davis, Systems/Applications Architect (Contractor), >> Office of Computer and Communications Systems, >> National Library of Medicine, NIH >> >> ------------------------------------------------------------------------------ >> Presto, an open source distributed SQL query engine for big data, initially >> developed by Facebook, enables you to easily query your data on Hadoop in a >> more interactive manner. Teradata is also now providing full enterprise >> support for Presto. Download a free open source copy now. >> http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
