[jira] [Commented] (HIVE-16234) Add support for quarter in trunc udf

2017-03-18 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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//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)

[jira] [Commented] (HIVE-16234) Add support for quarter in trunc udf

2017-03-17 Thread Deepesh Khandelwal (JIRA) 

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

Deepesh Khandelwal commented on HIVE-16234:
---

Thanks [~ashutoshc] for the review and commit!
[~leftylev] for the doc part, is that something I need to do once 2.2.0 is 
released?

> 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//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)

[jira] [Commented] (HIVE-16234) Add support for quarter in trunc udf

2017-03-17 Thread Lefty Leverenz (JIRA) 

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

Lefty Leverenz commented on HIVE-16234:
---

Doc note:  The description of trunc() in the UDF doc needs to be updated, with 
version information.

* [Hive Operators and UDFs -- Date Functions | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions]

Added a TODOC2.2 label.

> 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//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)

[jira] [Commented] (HIVE-16234) Add support for quarter in trunc udf

2017-03-17 Thread Ashutosh Chauhan (JIRA) 

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

Ashutosh Chauhan commented on HIVE-16234:
-

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/4196/testReport/
No relevant failure.

> 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
> 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//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)

[jira] [Commented] (HIVE-16234) Add support for quarter in trunc udf

2017-03-16 Thread Ashutosh Chauhan (JIRA) 

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

Ashutosh Chauhan commented on HIVE-16234:
-

+1

> 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
> 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//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)