[jira] [Commented] (SPARK-8992) Add Pivot functionality to Spark SQL

["Reynold Xin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-8992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14632993#comment-14632993 ] 

Reynold Xin commented on SPARK-8992:
------------------------------------

This would be cool to have, but probably going to be challenging to design the API.

[~superhadooper] would you be interested in coming up with some design sketch?


> Add Pivot functionality to Spark SQL
> ------------------------------------
>
>                 Key: SPARK-8992
>                 URL: https://issues.apache.org/jira/browse/SPARK-8992
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 1.4.0
>            Reporter: Richard Williamson
>
> SQLServer and other databases provide capabilities to transpose data from columns to rows and rows to columns, the later is very useful for analytic use cases like turning rows into feature columns for an MLlib model. Here is a reference for the SQLServer implementation: http://sqlhints.com/2014/03/10/pivot-and-unpivot-in-sql-server/
> Additional Referenced Request:
> http://stackoverflow.com/questions/30244910/pivot-spark-dataframe



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org