You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Anuj Phadke (JIRA)" <ji...@apache.org> on 2018/07/27 20:55:00 UTC
[jira] [Resolved] (IMPALA-4848) add WIDTH_BUCKET() function
[ https://issues.apache.org/jira/browse/IMPALA-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuj Phadke resolved IMPALA-4848.
---------------------------------
Resolution: Fixed
Fix Version/s: Impala 3.1.0
> add WIDTH_BUCKET() function
> ---------------------------
>
> Key: IMPALA-4848
> URL: https://issues.apache.org/jira/browse/IMPALA-4848
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend, Frontend
> Affects Versions: Product Backlog
> Reporter: Greg Rahn
> Assignee: Anuj Phadke
> Priority: Major
> Labels: ansi-sql, built-in-function, ramp-up, sql-language
> Fix For: Impala 3.1.0
>
>
> 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|https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Mathematical/WIDTH_BUCKET.htm]
> * [Oracle|http://docs.oracle.com/database/121/SQLRF/functions250.htm#SQLRF06163]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)