[MADLIB-1004] Pivoting - Phase 2 (advanced pivot)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.9.1
• Component/s: Module: Utilities
• Assignee: Orhan Kislal
• Reporter: Frank McQuillan
• Created: 03/Jun/16 18:32
• Updated: 29/Aug/16 21:03
• Resolved: 26/Aug/16 20:51

Description

Story

As a data scientist, I want to perform advanced pivot operation on my data, so that I can prepare it for input to predictive analytics algorithms.

Details

• Advanced pivot for this story means the features defined as MVP in the requirements attached.

In general, we are following Pandas ideas.

References

[1] Pivot table general information, like what is pivoting?
https://en.wikipedia.org/wiki/Pivot_table

[2] Pandas pivot tables and cross-tabulations
http://pandas.pydata.org/pandas-docs/stable/reshaping.html#pivot-tables-and-cross-tabulations
http://pandas.pydata.org/pandas-docs/stable/cookbook.html#cookbook-pivot
http://pbpython.com/pandas-pivot-table-explained.html

[3] GPDB pivot_sum function
http://gpdb.docs.pivotal.io/4320/admin_guide/query.html#topic30

[4] PostgreSQL tablefunc
http://www.postgresql.org/docs/9.4/static/tablefunc.html

[5] PDL tools pivoting routines
http://pdl-tools.pa.pivotal.io/group__grp__pivot.html
http://pdl-tools.pa.pivotal.io/group__grp__pivot01.html

[6] Aster Pivot and Unpivot functions
User Guide
http://www.info.teradata.com/eDownload.cfm?itemid=122580002

[7] PostgreSQL aggregates
http://www.postgresql.org/docs/8.2/static/functions-aggregate.html

[8] PostgreSQL basic statements/assignment operator, http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html

Issue Links

• links to: GitHub Pull Request #54