Jianfeng Jia created ASTERIXDB-1418:
---------------------------------------
Summary: Doesn't support some a Nested Aggregation Query
Key: ASTERIXDB-1418
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1418
Project: Apache AsterixDB
Issue Type: Bug
Reporter: Jianfeng Jia
When I ran the following query
{code}
use dataverse twitter
for $t in dataset ds_tweet_trump
group by
$county := $t.geo_tag.countyID,
$timebin := interval-bin($t.create_at, date("2012-01-01"),
day-time-duration("P1D")) with $t
return {
"county": $county,
"time": $timebin,
"count": count($t),
"users": count( for $tt in $t distinct by $tt.user.id return $tt.user.id)
}
{code}
One exception appears:
{code}
Attempting to construct a nested plan with 3 operator descriptors. Currently,
nested plans can only consist in linear pipelines of Asterix micro operators.
[AlgebricksException]
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
