You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Xikui Wang (JIRA)" <ji...@apache.org> on 2019/05/28 00:08:00 UTC

[jira] [Created] (ASTERIXDB-2578) GROUP AS creates illegal state

Xikui Wang created ASTERIXDB-2578:
-------------------------------------

             Summary: GROUP AS creates illegal state
                 Key: ASTERIXDB-2578
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2578
             Project: Apache AsterixDB
          Issue Type: Bug
            Reporter: Xikui Wang
         Attachments: init_dataverse.txt

{code}
USE HW8;
SELECT u.id, avg(obs.rate) as avg_rate, InterestGroups
FROM Observations obs, Users u, Observers obr, Interests i
WHERE obs.kind = 'heart_rate' AND obr.ownedBy = u.id AND obs.observerId = obr.id AND i.name in u.memberOf AND i.topic = "diabetes"
GROUP BY u.id
GROUP AS InterestGroups(i as ig);
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)