Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

JFS SPARQL Query -- Problem with SELECT having COUNT

Hi,
I have attempted to write a SPARQL query that uses the aggregate function COUNT .. GROUP BY. The query is very simple, like


SELECT ?o COUNT(?s)
WHERE {
?s ?p ?o.
} group BY ?o


However, the JFS SPARQL service failed to execute the query.

It seems that the service does not support this aggregate function.

Please let me know if there is a way to get this work or there are any packages or newer versions that support SPARQL extensions or ARQ queries.

Thanks,
Vu

0 votes



3 answers

Permanent link
As you note, these are vendor extensions to SPARQL and not specified by the core language standard. We currently support only the standard language, not any of the extensions provided by Jena (ARQ) or Virtuoso for example.

Hi,
I have attempted to write a SPARQL query that uses the aggregate function COUNT .. GROUP BY. The query is very simple, like


SELECT ?o COUNT(?s)
WHERE {
?s ?p ?o.
} group BY ?o


However, the JFS SPARQL service failed to execute the query.

It seems that the service does not support this aggregate function.

Please let me know if there is a way to get this work or there are any packages or newer versions that support SPARQL extensions or ARQ queries.

Thanks,
Vu

0 votes


Permanent link
Please let me know how to calculate the timespent on the tasks executed in an iteration. I would like to view the count of the timespent for each type of the task and the total count of them.

Thanks
Savitha

0 votes


Permanent link
We are planning to support aggregation if enabling the ARQ language extension via an extra query argument: "&syntax=ARQ". This should be made available as part of 3.0M5 (in progress).

Also read https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=102647

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jun 09 '09, 6:31 p.m.

Question was seen: 10,051 times

Last updated: Jun 09 '09, 6:31 p.m.

Confirmation Cancel Confirm