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

Reply via email to