Hi Sergio,

I would expect "DISTINCT" to work as I used it quite often in SPARQL queries against Virtuoso.

Can you provide a test case for us to see this problem first hand, either a server instance we can access online or a dataset we can load locally to recreate.

The Virtuoso explain function [1] can be used to obtain the query execution plan for the query and can be run from isql or the conductor isql interface as follows:

explain('SPARQL SELECT DISTINCT(?name) ?person ?mail WHERE { ?person rdf:type foaf:Person . ?person foaf:name ?name . ?person foaf:mbox_sha1sum ?mail}')

If you can provide this output it would be useful for analysis if we cannot access the server ourselves.

What is the version of the Virtuoso Server you are using ?

[1] http://docs.openlinksw.com/virtuoso/fn_explain.html#(NULL)

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support



On 21 Oct 2008, at 08:20, Sergio Fernández wrote:


Hi,

in a experiment I've a dataset with many people (some of then
duplicated). I want just to list it, I'm doing something like:

SELECT DISTINCT(?name) ?person ?mail
WHERE {
  ?person rdf:type foaf:Person .
  ?person foaf:name ?name .
  ?person foaf:mbox_sha1sum ?mail
}

But DISTINCT doesn't work as I expected: if there are duplicated names,
it returns all. I know that DISTINCT() is not an standard syntax
according to [1]; I've read some example that use it over Virtuoso, but
I'm not sure about its behaviour.

Thank you in advance.

[1] http://www.w3.org/TR/rdf-sparql-query/#modDistinct

--
Sergio Fernández - sergio.fernan...@fundacionctic.org
R&D Deparment
CTIC Foundation - www.fundacionctic.org
Phone: +34 984 29 12 12
Fax:  +34 984 39 06 12
Edificio Centros Tecnológicos
Parque Científico Tecnológico
33203 Cabueñes - Gijón - Asturias - Spain


---------------------------------------------------------------------- --- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to