Damien,
for the intra-document operations, it would be useful to add support for
LATERAL joins (SQL standard), which in conjunction with UNNEST (or FLATTEN)
should address the use case you have. I have filed a JIRA for this:
https://issues.apache.org/jira/browse/DRILL-5999.
-Aman
On Tue, Sep
Hello Aman,
AsterixDb seems to follow the standard SQL with a few minor
modifications and add functions to ease aggregations (array_count,
array_avg…)
That would tend to confirm at least that the support of unnest is a good
idea to improve Drill.
Best regards
Damien
**
On 09/25/2017