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 <[email protected]> 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
