drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: How to get multiple row value as a single column
Date Wed, 04 Jan 2017 11:44:52 GMT
i think you are looking for

https://issues.apache.org/jira/browse/DRILL-1330

On Jan 4, 2017 4:45 PM, "Sanjiv Kumar" <ktrsanjiv@gmail.com> wrote:

> Hello
>         I need help.Suppose I have one table having categoryName,
> categoryID, customerName.
> EXAMPLE:-
> categoryName categoryID customerName
>   C1 10 Cust1
>   C1 10 Cust3
>   C1 10 Cust4
>   C2 11 Cust2
>
> In above table Multiple Customers having same Category Name.
>
> How to get customer name which have same category name in a single row
> using drill query ?
>  Like:-
>
> categoryName customerName
>  C1 Cust1,Cust3,Cust4
>  C2 Cust2
>
>
>
>
>
>
>
>
>
>  -------------------------
> Thanks & Regards
>    Sanjiv Kumar
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message