[ 
https://issues.apache.org/jira/browse/HIVE-16234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15931576#comment-15931576
 ] 

Lefty Leverenz commented on HIVE-16234:
---------------------------------------

[~deepesh], you can wait until 2.2.0 is released but there's a good chance the 
doc will be forgotten by then, so people usually document things ahead of the 
release.

If you search for "2.2.0" in the UDF doc, you'll find four examples.

> Add support for quarter in trunc udf
> ------------------------------------
>
>                 Key: HIVE-16234
>                 URL: https://issues.apache.org/jira/browse/HIVE-16234
>             Project: Hive
>          Issue Type: Improvement
>          Components: UDF
>            Reporter: Deepesh Khandelwal
>            Assignee: Deepesh Khandelwal
>              Labels: TODOC2.2
>             Fix For: 2.2.0
>
>         Attachments: HIVE-16234.1.patch
>
>
> Hive has a Date function trunc(string date, string format) that returns date 
> truncated to the unit specified by the format. Supported formats: 
> MONTH/MON/MM, YEAR/YYYY/YY.
> Goal here is to extend support to QUARTER/Q.
> Example:
> SELECT trunc('2017-03-15', 'Q');
> '2017-01-01'
> SELECT trunc('2017-12-31', 'Q');
> '2017-10-01'



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to