hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carter Shanklin (JIRA)" <>
Subject [jira] [Commented] (HIVE-15982) Support the width_bucket function
Date Mon, 17 Apr 2017 21:46:41 GMT


Carter Shanklin commented on HIVE-15982:


Sorry for the delayed response, I checked the SQL spec, for SQL conformance only numeric value
expressions are needed. I can see some value in supporting dates or timestamps, e.g. for creating
a histogram of sign-up dates, first purchase dates and so on, but it doesn't seem mandatory.

Supporting intervals -- maybe a histogram account inactivity time. Again, nice to have.

> Support the width_bucket function
> ---------------------------------
>                 Key: HIVE-15982
>                 URL:
>             Project: Hive
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Carter Shanklin
>            Assignee: Sahil Takiar
> Support the width_bucket(wbo, wbb1, wbb2, wbc) which returns an integer between 0 and
wbc+1 by mapping wbo into the ith equally sized bucket made by dividing wbb1 and wbb2 into
equally sized regions. If wbo < wbb1, return 1, if wbo > wbb2 return wbc+1. Reference:
SQL standard section 4.4.

This message was sent by Atlassian JIRA

View raw message