[ 
https://issues.apache.org/jira/browse/HIVE-10212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aihua Xu updated HIVE-10212:
----------------------------
    Summary: When timestamp is converted to bigint, it's always interpreted as 
seconds while bigint to timestamp is in milliseconds.  (was: Timestamp 
conversion to int doesn't work. )

> When timestamp is converted to bigint, it's always interpreted as seconds 
> while bigint to timestamp is in milliseconds.
> -----------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-10212
>                 URL: https://issues.apache.org/jira/browse/HIVE-10212
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>              Labels: timestamp
>
> select cast(ts as bigint) from tbl1. We are treating ts always in seconds. 
> After HIVE-9917 is done, we should also convert based on the config 
> hive.int.timestamp.conversion.in.seconds is true or false to convert to time 
> in seconds or milliseconds.



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

Reply via email to