Re: [Virtuoso-users] Group by in ASK queries error

[Rumi]

Hi Dimitris,

On 03-Jan-14 1:49 PM, Dimitris Kontokostas wrote:

Hi Rumi,

I know about the inner select but by checking the sparql grammar [1] and validator [2] my query looks valid

Yes.
The query syntax is correct.
A report is sent to development to fix.
Will let you know when it is available ...

Best Regards,
Rumi Kocis

Best,
Dimitris

[1] http://www.w3.org/TR/sparql11-query/

|SelectQuery| ::= |SelectClause <http://www.w3.org/TR/sparql11-query/#rSelectClause> DatasetClause <http://www.w3.org/TR/sparql11-query/#rDatasetClause>* WhereClause <http://www.w3.org/TR/sparql11-query/#rWhereClause> SolutionModifier <http://www.w3.org/TR/sparql11-query/#rSolutionModifier>|

|AskQuery| ::= |'ASK' DatasetClause <http://www.w3.org/TR/sparql11-query/#rDatasetClause>* WhereClause <http://www.w3.org/TR/sparql11-query/#rWhereClause> SolutionModifier <http://www.w3.org/TR/sparql11-query/#rSolutionModifier>|

[2] http://www.sparql.org/query-validator.html

On Fri, Jan 3, 2014 at 1:32 PM, Rumi <rtsek...@openlinksw.com <mailto:rtsek...@openlinksw.com>> wrote:

    Hi Dimitris,


    On 03-Jan-14 11:06 AM, Dimitris Kontokostas wrote:

    Hi & happy new year to all!

    I noticed that virtuoso doesn't support group by / having in ask
    queries
    Is this a bug or not supported yet?

    e.g.

    ASK
    WHERE
      { ?resource <prop> ?c }
    GROUP BY ?resource
    HAVING ( count(?c) > 1 )

    Happy New Year to you too!

    IMO you need to use inner SELECT statement i.e.:

    ASK WHERE
    {
    SELECT ?resource  COUNT ( ?c ) AS ?total WHERE

      {
        ?resource <prop> ?c
      }
     GROUP BY ?resource
     HAVING COUNT ( ?c) > 1
    }

    example of live results (true): -- http://bit.ly/1lEr1Rw
    example of SPARQL query:   -- http://bit.ly/1g5mqqm


    Best Regards,
    Rumi Kocis

    Best,
    Dimitris




    
------------------------------------------------------------------------------
    Rapidly troubleshoot problems before they affect your business. Most IT
    organizations don't have a clear picture of how application performance
    affects their revenue. With AppDynamics, you get 100% visibility into your
    Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics 
Pro!
    http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk


    _______________________________________________
    Virtuoso-users mailing list
    Virtuoso-users@lists.sourceforge.net  
<mailto:Virtuoso-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/virtuoso-users

-- Kontokostas Dimitris

--
Kontokostas Dimitris

smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users