Hi Erich, The query runs for me against local v7 open source build, but then I don't have your data in my installation:
SQL> SPARQL prefix sno: <http://www.ebremer.com/sno/> with <http://www.maxmind.com> delete {?range sno:hasStartip4Address ?ip} insert {?range sno:hasStartip4AddressDotted ?ip} where {?range sno:hasStartip4Address ?ip filter(!isnumeric(?ip))}; Done. -- 1 msec. SQL> In Virtuoso 7 there is a MaxVectorSize param in the virtuoso.ini file which defaults to 1000000, you can try setting it to something higher than 2000000 , restart Virtuoso and see if it resolves the problem ... 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 25 Sep 2013, at 16:46, Erich Bremer <er...@ebremer.com> wrote: > Using Virtuoso 7.0.0, I tried to do a with-delete-insert query and the > following error was generated: > > Virtuoso 42000 Error FRVEC: array in for vectored over max vector length > 2000000 > 1000000 > > SPARQL query: > define sql:big-data-const 0 > #output-format:text/html > define sql:signal-void-variables 1 prefix sno: <http://www.ebremer.com/sno/> > with <http://www.maxmind.com> > delete {?range sno:hasStartip4Address ?ip} > insert {?range sno:hasStartip4AddressDotted ?ip} > where {?range sno:hasStartip4Address ?ip filter(!isnumeric(?ip))} > > - Erich > > Erich Bremer > http://www.ebremer.com > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
