Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 20 Feb 2015 14:58:12 +0000 (UTC)
From: "Aihua Xu (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12607355.1347489605000.95193.1424444292314@Atlassian.JIRA>
In-Reply-To: <JIRA.12607355.1347489605000@Atlassian.JIRA>
References: <JIRA.12607355.1347489605000@Atlassian.JIRA>
 <JIRA.12607355.1347489605891@arcas>
Subject: [jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as
 TIMESTAMP)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Aihua Xu commented on HIVE-3454:
--------------------------------

Yeah. Thanks for pointing that out. I also notice that problem. We won't be able to override during the session with that approach and also we could have problem if we run in the real cluster as Brock pointed out. I'm trying a different approach. 

> Problem with CAST(BIGINT as TIMESTAMP)
> --------------------------------------
>
>                 Key: HIVE-3454
>                 URL: https://issues.apache.org/jira/browse/HIVE-3454
>             Project: Hive
>          Issue Type: Bug
>          Components: Types, UDF
>    Affects Versions: 0.8.0, 0.8.1, 0.9.0, 0.10.0, 0.11.0, 0.12.0, 0.13.0, 0.13.1
>            Reporter: Ryan Harris
>            Assignee: Aihua Xu
>              Labels: newbie, newdev, patch
>         Attachments: HIVE-3454.1.patch.txt, HIVE-3454.2.patch, HIVE-3454.3.patch, HIVE-3454.patch
>
>
> Ran into an issue while working with timestamp conversion.
> CAST(unix_timestamp() as TIMESTAMP) should create a timestamp for the current time from the BIGINT returned by unix_timestamp()
> Instead, however, a 1970-01-16 timestamp is returned.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)