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

Attachment: 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

Reply via email to