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
