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] [Updated] (ASTERIXDB-2578) GROUP AS creates illegal state

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xikui Wang updated ASTERIXDB-2578:
----------------------------------
    Attachment: init_dataverse.txt

> 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
>            Priority: Major
>         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)