You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Aihua Xu (JIRA)" <ji...@apache.org> on 2015/04/03 22:00:53 UTC

[jira] [Updated] (HIVE-10212) Timestamp conversion to int doesn't work.

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

Aihua Xu updated HIVE-10212:
----------------------------
    Description: 
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.


  was:
select cast(ts as bigint) from tbl1; where ts is a timstamp will always return 0. 

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.



> Timestamp conversion to int doesn't work. 
> ------------------------------------------
>
>                 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)