[PIG-4906] Add Bigdecimal functions in Over function

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.15.0
• Fix Version/s: 0.17.0
• Component/s: piggybank

Environment

Hortonworks 2.4.2

• Patch Info: Patch Available
• Hadoop Flags: Reviewed

Release Note

-4 new functions: SUM, AVG, MAX and MIN for BigDecimal and 4 test for each function.
-An another outputschema. This output takes the inner alias and type of inputschema and returns the same alias with "_over" and the type. This is because in a foreach like the next:

x = FOREACH SUM {
ini = FOREACH test GENERATE id, id_2;
GENERATE FLATTEN(MYSTITCH(ini, MYOVER(test.impt_prima, 'sum(bigdecimal)'), MYOVER(test.impt_1, 'sum(bigdecimal)'),
MYOVER(test.impt_2, 'sum(bigdecimal)')));

with the normal OVER function the foreach fails because all MYOVERS return the same alias.

• Flags: Patch
• Assignee: Cristian Galán
• Reporter: Cristian Galán
• Created: 23/May/16 12:03
• Updated: 21/Jun/17 09:15
• Resolved: 23/Jun/16 18:18

Description

In the piggybank, the Over function class don't include the bigdecimals methods for sum, max, min and avg.

I attach Over.class with this changes. I attach the patch with this changes and I add a new output schema also. If anybody can do the PR, I appreciate it