[ 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) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org