Hi Ted, Thanks for you question. Array type aggregator is not planned along with this project. But probably after this is done we can look into it.
Thanks, Sorabh Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________ From: Ted Dunning <ted.dunn...@gmail.com> Sent: Sunday, January 28, 2018 10:30:30 PM To: dev@drill.apache.org Cc: Chunhui Shi; Parth Chandra; Aman Sinha; Sorabh Hamirwasia Subject: Re: LATERAL and UNNEST support for Drill 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<mailto: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<https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_DRILL-2D5999&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=iKu0hCGDHFbZsyzbsmTFjCYxYuLB4FUf26dimMQ8ErE&s=s-Ja1U7TeOgi96_QzCmtlKlV9S8uvtBgjfywbJKp-Tw&e=>> Design Document <https://docs.google.com/document/d/1-RCIJ0F7VwAqOxkVB305zADwtX-OS43Qj2kUmIILUaQ/edit?usp=sharing<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.google.com_document_d_1-2DRCIJ0F7VwAqOxkVB305zADwtX-2DOS43Qj2kUmIILUaQ_edit-3Fusp-3Dsharing&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=iKu0hCGDHFbZsyzbsmTFjCYxYuLB4FUf26dimMQ8ErE&s=keKwGEfpcC8MLXAV4QFiAXASguRR9R1dsGMZdyUmd2E&e=>> Thanks, Sorabh
