[jira] [Updated] (IMPALA-4848) add WIDTH_BUCKET() function

["Quanlong Huang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Quanlong Huang updated IMPALA-4848:
-----------------------------------
    Fix Version/s: Impala 2.13.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 2.13.0, 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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org