[METRON-394] Create Stellar Date Functions to Use with Profile 'Group By'

• Type: Improvement
• Status: Done
• Priority: Major
• Resolution: Done
• Fix Version/s: 0.2.1BETA
• Assignee: Nick Allen
• Reporter: Nick Allen
• Created: 25/Aug/16 13:42
• Updated: 27/Sep/16 15:01
• Resolved: 13/Sep/16 18:08

Description

METRON-392 Allows a user to optionally define a custom set of 'groupBy' expressions that controls how Profile data is persisted. This is intended to allow for contiguous scans when training on subsets of the data.

A common use case would be grouping the data by some calendar period, like day of week. This would allow a contiguous scan to access all profile data, for example, on Mondays only. The Stellar expression DAY_OF_WEEK(start) would achieve this.

The following functions would be useful to have for this purpose.

• WEEK_OF_MONTH
• WEEK_OF_YEAR
• DAY_OF_WEEK
• DAY_OF_MONTH
• DAY_OF_YEAR
• MONTH
• YEAR

Issue Links

• links to: GitHub Pull Request #231