Nikhil Gupta created HIVE-24529: ----------------------------------- Summary: Metastore truncates milliseconds while storing timestamp column stats Key: HIVE-24529 URL: https://issues.apache.org/jira/browse/HIVE-24529 Project: Hive Issue Type: Bug Affects Versions: 4.0.0 Reporter: Nikhil Gupta Assignee: Nikhil Gupta
Steps to reproduce the issue: create table tnikhil (t timestamp); insert into tnikhil values ('2019-01-01 23:12:45.123456'); analyze table tnikhil compute statistics for columns; select * from tnikhil; {noformat} +-----------------------------+ | tnikhil.t | +-----------------------------+ | 2019-01-01 23:12:45.123456 | +-----------------------------+{noformat} desc formatted tnikhil t; {noformat} +------------------------+----------------------------------------------------+ | col_name | data_type | +------------------------+----------------------------------------------------+ | col_name | t | | data_type | timestamp | | min | 1546384365 | | max | 1546384365 | +------------------------+----------------------------------------------------+ {noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)