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

Timestamp format different in HiveCLI and Beeline

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Beeline, CLI
    • None

    Description

      The issue can be reproduced with the following commands:

      create table timestamp_test(t timestamp);
      insert into table timestamp_test values('2000-01-01 01:00:00');
      select * from timestamp_test;
      

      The timestamp is displayed without nanoseconds in HiveCLI:

      2000-01-01 01:00:00
      

      When the exact same timestamp is displayed in BeeLine it displays:

      2000-01-01 01:00:00.0
      

      Attachments

        1. HIVE-17230.3.patch
          899 kB
          Marta Kuczora
        2. HIVE-17230.2.patch
          850 kB
          Marta Kuczora
        3. HIVE-17230.1.patch
          94 kB
          Marta Kuczora

        Activity

          People

            kuczoram Marta Kuczora
            pvary Peter Vary
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: