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
