drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jinfeng Ni <jinfengn...@gmail.com>
Subject Re: Pivot in Apache Drill
Date Mon, 13 Jun 2016 22:38:54 GMT
Drill currently does not support Sql Pivot. Seems this is not a
functionality defined in SQL standard ISO/SEC9075-2. The SQL planner
that Drill uses, Apache Calcite, also does not have support of this
syntax.

If this is a very commonly used functionality, we may consider adding
support in future.





On Mon, Jun 13, 2016 at 4:36 AM, Sanjiv Kumar <ktrsanjiv@gmail.com> wrote:
> Does Apache Drill Supports Sql Pivot.
>
> I have this:-
> SQL QUERY for Creating TABLE is:-
>
> `create table Attribute (ID int ,Name varchar(250))`.
>
> INSERT QUERY is:-
>
> `insert into Attribute values(1, 'Description'),
>                                       (2, 'StockNumber'),
>                                       (3, 'Price'),
>                                       (4, 'Logo'),
>                                       (5, 'Diagram');`
>
> I want show row data (i.e:- Description, StockNumber, Price, Logo, Diagram)
> as column.
>
> I have this sql pivot query:-
>
> `select *
> from
> (
>   select id,name
>   from Attribute
> ) d
> pivot
> (
> max(id)
>   for name in ([Description],[StockNumber],[Price],[Logo],[Diagram]
> ) piv;`
>
>
> How to convert this sql query in apache drill.?
>
> OR Is There any other solution for that.?
>
>
>  ......................
>   Thanks & Regards

Mime
View raw message