hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3844) Unix timestamps don't seem to be read correctly from HDFS as Timestamp column
Date Thu, 14 Nov 2013 01:51:21 GMT

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

Thejas M Nair commented on HIVE-3844:
-------------------------------------

Venki,
Thanks for working on this!
I have added a comment to reviewboard. Catching an exception and converting it will be extremely
slow.
It would be better to check the format and do the conversion appropriately. Also, BigDecimal
is something that is considered to be slow. 

cc'ing [~jdere] who is a data type expert!


> Unix timestamps don't seem to be read correctly from HDFS as Timestamp column
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-3844
>                 URL: https://issues.apache.org/jira/browse/HIVE-3844
>             Project: Hive
>          Issue Type: Bug
>          Components: Serializers/Deserializers
>    Affects Versions: 0.8.0
>            Reporter: Mark Grover
>            Assignee: Venki Korukanti
>         Attachments: HIVE-3844.1.patch.txt
>
>
> Serega Shepak pointed out that something like
> {code}
> select cast(date_occurrence as timestamp) from xvlr_data limit 10
> {code}
> where  date_occurrence has BIGINT type (timestamp in milliseconds) works. But it doesn't
work if the declared type is TIMESTAMP on column. The data in the date_occurence column in
unix timestamp in millis.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message