[ https://issues.apache.org/jira/browse/HIVE-24529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated HIVE-24529: ---------------------------------- Labels: pull-request-available (was: ) > Metastore truncates milliseconds while storing timestamp column stats > --------------------------------------------------------------------- > > Key: HIVE-24529 > URL: https://issues.apache.org/jira/browse/HIVE-24529 > Project: Hive > Issue Type: Improvement > Affects Versions: 4.0.0 > Reporter: Nikhil Gupta > Assignee: Nikhil Gupta > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > 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)