Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B84BC10B5D for ; Sun, 7 Jul 2013 15:59:52 +0000 (UTC) Received: (qmail 75176 invoked by uid 500); 7 Jul 2013 15:59:50 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 75083 invoked by uid 500); 7 Jul 2013 15:59:49 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 75035 invoked by uid 500); 7 Jul 2013 15:59:48 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 75027 invoked by uid 99); 7 Jul 2013 15:59:48 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Jul 2013 15:59:48 +0000 Date: Sun, 7 Jul 2013 15:59:48 +0000 (UTC) From: "Edward Capriolo (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-3378) UDF to obtain the numeric day of an year from date or timestamp in HIVE. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701597#comment-13701597 ] Edward Capriolo commented on HIVE-3378: --------------------------------------- Looks good. You need to use the hive style conventions however. Your using tabs (should be 2 spaces) and your alignment is not correct. The hive wiki should have info on how to setup eclipse . Otherwise +1 > UDF to obtain the numeric day of an year from date or timestamp in HIVE. > ---------------------------------------------------------------------------- > > Key: HIVE-3378 > URL: https://issues.apache.org/jira/browse/HIVE-3378 > Project: Hive > Issue Type: New Feature > Components: UDF > Affects Versions: 0.8.1, 0.9.0 > Reporter: Deepti Antony > Attachments: HIVE-3378.1.patch.txt > > > Hive current releases lacks a function which returns the numeric day of an year if a date or timestamp is given .The function DAYOFYEAR(date) would return the numeric day from a date / timestamp or which would be useful while using HiveQL.DAYOFYEAR can be used to compare data with respect to number of days till the given date.It can be used in different domains. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira