[
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: [email protected]
For additional commands, e-mail: [email protected]
