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
