[HIVE-10212] When timestamp is converted to bigint, it's always interpreted as seconds while bigint to timestamp is in milliseconds.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Labels: timestamp
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 03/Apr/15 19:01
• Updated: 04/Apr/15 13:42
• Resolved: 04/Apr/15 13:42

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.

Issue Links

• depends upon: HIVE-9917 After HIVE-3454 is done, make int to timestamp conversion configurable