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
|