You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ashish Sharma (Jira)" <ji...@apache.org> on 2021/03/07 11:38:00 UTC

[jira] [Work started] (HIVE-24529) Metastore truncates milliseconds while storing timestamp column stats

     [ https://issues.apache.org/jira/browse/HIVE-24529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on HIVE-24529 started by Ashish Sharma.
--------------------------------------------
> 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: Ashish Sharma
>            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)