You can always develop a User Defined Aggregate Function: http://drill.apache.org/docs/develop-custom-functions/
Thanks On Wed, Mar 9, 2016 at 12:29 AM, Bosung Seo <[email protected]> wrote: > Hello, > > I found that Drill doesn't support string_agg function yet. > Is there another way to query as the string_agg function? > > If I have a table, > user | id > user1 | 1 > user1 | 2 > user1 | 3 > user2 | 1 > > I want to make like this. > user | ids > user1 | 1,2,3 > user2 | 1 > > Any help would be appreciated. > > Thanks, > Bo > -- Abdelhakim Deneche Software Engineer <http://www.mapr.com/> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
