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)

Reply via email to