[IMPALA-4848] add WIDTH_BUCKET() function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Product Backlog
• Fix Version/s: Impala 2.13.0, Impala 3.1.0
• Component/s: Backend, Frontend
• Labels: ansi-sql built-in-function ramp-up sql-language
• Assignee: Anuj Phadke
• Reporter: Greg Rahn
• Created: 31/Jan/17 19:11
• Updated: 25/Feb/19 07:57
• Resolved: 27/Jul/18 20:54

Description

Add the built-in function
WIDTH_BUCKET (expr, min_value, max_value, num_buckets)

<width bucket function> is a function of four arguments, returning an integer between 0 (zero) and the value of the final argument plus 1 (one), by assigning the first argument to an equi-width partitioning of the range of numbers between the second and third arguments. Values outside the range between the second and third arguments are assigned to either 0 (zero) or the value of the final argument plus 1 (one).

References:

• Vertica
• Oracle

Issue Links

• relates to: IMPALA-2033 Netezza compatibility functions: misc.

Sub-Tasks

• Impala Doc: WIDTH_BUCKET function: Closed