[IMPALA-1766] Misc. statistical functions

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.1.1
• Fix Version/s: Impala 4.3.0
• Component/s: Backend
• Labels: 2023Q1 built-in-function ramp-up
• Target Version: Product Backlog
• Assignee: Pranav Yogi Lodha
• Reporter: Henry Robinson
• Created: 13/Feb/15 23:31
• Updated: 01/Dec/23 17:42
• Resolved: 15/Sep/23 18:03

Description

Some useful statistical functions for BI integration:

• median() part of IMPALA-4025
• corr()
• covar_pop()
• regr_intercept()
• regr_slope()
• regr_r2() (see http://psoug.org/definition/REGR_R2.htm)

Issue Links

• is related to: IMPALA-12361 Implementation of regr_count(), regr_avgx() and regr_avgy()
• is related to: IMPALA-4025 add functions PERCENTILE_DISC(), PERCENTILE_CONT(), and MEDIAN()
• is related to: IMPALA-3602 Implement percentile and percentile_approx statistical functions

Sub-Tasks

• Implement Statistical functions : CORR(), COVAR_SAMP() and COVAR_POP(): Resolved
• Implement Regression functions : regr_slope(), regr_intercept() and regr_r2(): Resolved