[ https://issues.apache.org/jira/browse/FLINK-23179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17371219#comment-17371219 ]
Aitozi commented on FLINK-23179: -------------------------------- Big+1 [~lzljs3620320] Is there any plan for the support of pivot syntax? I'm interested in this, i think the ability to turn rows to columns will be useful in some scenes. > Support PIVOT and UNPIVOT > -------------------------- > > Key: FLINK-23179 > URL: https://issues.apache.org/jira/browse/FLINK-23179 > Project: Flink > Issue Type: New Feature > Components: Table SQL / Runtime > Reporter: Jingsong Lee > Priority: Major > > See PIVOT in SqlServer: > [https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15] > Not only in batch, Streaming also has this requirement. > See PIVOT in others system: > [https://docs.oracle.com/cd/E11882_01/server.112/e25554/analysis.htm#DWHSG8732] > [http://modern-sql.com/use-case/pivot] > [https://docs.microsoft.com/zh-cn/previous-versions/sql/sql-server-2008-r2/ms177410(v=sql.105)?redirectedfrom=MSDN] > [https://www.postgresql.org/docs/9.5/tablefunc.html] > [https://docs.oracle.com/cd/B28359_01/server.111/b28313/sqlmodel.htm#g1042989] > [https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#SQLRF01702] > [https://www.oracle.com/cn/database/articles/technology/pivot-and-unpivot.html] > [https://databricks.com/blog/2016/02/09/reshaping-data-with-pivot-in-apache-spark.html] > [http://sqlhints.com/2014/03/10/pivot-and-unpivot-in-sql-server/] > https://issues.apache.org/jira/browse/SPARK-8992 > [https://spark.apache.org/docs/1.6.3/api/scala/index.html#org.apache.spark.sql.GroupedData] > [https://www.slideshare.net/SparkSummit/pivoting-data-with-sparksql-by-andrew-ray] > -- This message was sent by Atlassian Jira (v8.3.4#803005)