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

2021-03-06 Thread ASF GitHub Bot (Jira) 


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

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

2021-03-03 Thread Nikhil Gupta (Jira) 


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

Nikhil Gupta updated HIVE-24529:

Issue Type: Improvement  (was: Bug)

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

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

2020-12-13 Thread Nikhil Gupta (Jira) 


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

Nikhil Gupta updated HIVE-24529:

Priority: Major  (was: Minor)

> 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
>Priority: Major
>
> 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)