[ 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)