Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-24529

Metastore truncates milliseconds while storing timestamp column stats

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: In Progress
    • Major
    • Resolution: Unresolved
    • 4.0.0
    • None
    • None

    Description

      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;

      +-----------------------------+
      |          tnikhil.t          |
      +-----------------------------+
      | 2019-01-01 23:12:45.123456  |
      +-----------------------------+

      desc formatted tnikhil t; 

      +------------------------+----------------------------------------------------+
      |        col_name        |                     data_type                      |
      +------------------------+----------------------------------------------------+
      | col_name               | t                                                  |
      | data_type              | timestamp                                          |
      | min                    | 1546384365                                         |
      | max                    | 1546384365                                         |
      +------------------------+----------------------------------------------------+
      

       

      Attachments

        Issue Links

          Activity

            People

              ashish-kumar-sharma Ashish Sharma
              gupta.nikhil0007 Nikhil Gupta
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h