The Ultimate Guide to High Availability with MariaDB

Comments - Does MariaDb ColumnStore supports PIVOT

 
1 year, 6 months ago Ian Gilfillan
Re: Does MariaDb ColumnStore supports PIVOT

It's probably not helpful for your specific question, but the CONNECT storage engine does support PIVOT.

If adding the feature to the main server interests you, please vote/comment on MDEV-10144.

 
1 year, 6 months ago Roman Nozdrin
Re: Does MariaDb ColumnStore supports PIVOT [Answer]

Hi,

Both MariaDB and MCS don't support PIVOT clause as it is in SQL Server. However you can pivot the data using CASE as it is described by Markus Winand here [1].

Regards, Roman

1. https://modern-sql.com/use-case/pivot

 
1 year, 6 months ago Antonis Panagi
Re: Does MariaDb ColumnStore supports PIVOT

Every analytics engine uses PIVOT. Such a shame that such an important feature does not exist as built-in the CS engine

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.