HI Lorena, What is the version of Virtuoso in use (run virtuoso-t -?) ?
The error indicates the SUM(?ov) is larger than the size of a numeric type, thus you could try casting it to an "xsd:double" which allows a larger size, as follows: SELECT ?time ?sex ?geo (sum(xsd:double(?ov)) as ?sum_ov) FROM <http://eurostat.org/migr_asyappctzm> WHERE { ?o qb:dataSet dt:migr_asyappctzm . ?o sdmx-dimension:timePeriod ?time . ?o property:sex ?sex . ?o property:geo ?geo . ?o sdmx-measure:obsValue ?ov . } GROUP BY ?time ?sex ?geo 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 Feb 2013, at 12:54, lorena <[email protected]> wrote: > Hi: > > when running this query on a graph with 49.263.252 triples I receive > an "Virtuoso 22018 Error SR126: Can't convert <temporary space column> > to numeric" error message. > > SELECT ?time ?sex ?geo (sum(?ov) as ?sum_ov) > FROM <http://eurostat.org/migr_asyappctzm> > WHERE { > ?o qb:dataSet dt:migr_asyappctzm . > ?o sdmx-dimension:timePeriod ?time . > ?o property:sex ?sex . > ?o property:geo ?geo . > ?o sdmx-measure:obsValue ?ov . > } > GROUP BY ?time ?sex ?geo > > If I remove SUM(?ov) from the SELECT clause, or even If I replace it > with a COUNT(?ov) the query ends successfully and returns values, so I > think that these "temporary space column" has something to do with the > computation of SUM function. > > Any ideas? > > thanks in advance > Lorena > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_feb > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
