[
https://issues.apache.org/jira/browse/FLINK-23179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jingsong Lee updated FLINK-23179:
---------------------------------
Description:
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]
was:
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.
> 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)
