I haven't looked at the design doc, but this is a great thing to have. Would you be building something to do the inverse as well?
Something like an aggregator such as array_collect, perhaps? On Thu, Jan 25, 2018 at 2:56 PM, Sorabh Hamirwasia <sohami.apa...@gmail.com> wrote: > Hi All, > > We (people in cc list) have been looking into design for support of LATERAL > and UNNEST within Drill. With upgrade of Calcite to 1.15, these keywords > are supported in Calcite too. As a first cut we have created a design > document which proposes the changes and limitation's for this project. > There are still few items which are in progress. I am sharing the JIRA > details along with link to design document below. Please feel free to take > a look and provide any feedback. > > > DRILL-5999 <https://issues.apache.org/jira/browse/DRILL-5999> > > Design Document > <https://docs.google.com/document/d/1-RCIJ0F7VwAqOxkVB305zAD > wtX-OS43Qj2kUmIILUaQ/edit?usp=sharing> > > > Thanks, > Sorabh >