[KYLIN-5278] Support Pivot feature of SQL

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: yoonsung.lee
• Created: 19/Oct/22 05:01
• Updated: 22/Oct/22 10:31

Description

HI. I'm using Kylin 3.1.3 for OLAP.

It seems that there is no feature of Pivot. (e.g. https://docs.data.world/documentation/sql/concepts/advanced/PIVOT.html ,
https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/SqlPivot.html
)

I also tried to find source code related to Pivot, but there isn't.

Is there no feature for Pivot in Kylin(3 or 4)?
If not, is there a plan?
If not, is there a way to write a query like Pivot?

Best regards