Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EE69317E26 for ; Tue, 10 Mar 2015 08:59:50 +0000 (UTC) Received: (qmail 54822 invoked by uid 500); 10 Mar 2015 08:59:38 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 54802 invoked by uid 500); 10 Mar 2015 08:59:38 -0000 Mailing-List: contact issues-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 issues@hive.apache.org Received: (qmail 54791 invoked by uid 99); 10 Mar 2015 08:59:38 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Mar 2015 08:59:38 +0000 Date: Tue, 10 Mar 2015 08:59:38 +0000 (UTC) From: "Raunak Jhawar (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-9678) create timediff UDF 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-9678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14354573#comment-14354573 ] Raunak Jhawar commented on HIVE-9678: ------------------------------------- Workaround: Convert all date time objects to unix timestamp values. Now convert the difference of two unix time stamp into standard date time object and extract the time part from the object > create timediff UDF > ------------------- > > Key: HIVE-9678 > URL: https://issues.apache.org/jira/browse/HIVE-9678 > Project: Hive > Issue Type: Improvement > Components: UDF > Reporter: Alexander Pivovarov > Assignee: Alexander Pivovarov > Attachments: HIVE-9678.1.patch, HIVE-9678.2.patch, HIVE-9678.3.patch, HIVE-9678.4.patch, HIVE-9678.4.patch > > > MySQL has very useful function timediff. We should have it in Hive > {code} > select timediff('2015-02-12 05:09:07.140', '2015-02-12 01:18:20'); > OK > 03:50:47.140 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)