[IMPALA-12941] Implement the prettyprint_duration Built-in Function

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: be
• Labels: workload-management
• Epic Color: ghx-label-3
• Assignee: Jason Fehr
• Reporter: Jason Fehr
• Created: 26/Mar/24 15:41
• Updated: 26/Mar/24 20:40

Description

Implement a new Impala built-in function named prettyprint_duration. This function will take in two inputs – a duration (all integer/floating point/decimal types) and a unit (nanoseconds, microseconds, milliseconds, and seconds) and output a prettyprinted, human readable string.

For example:

select prettyprint_duration(2147483647, 'nanoseconds,);

output: 2s147ms