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

Timestamp type values not having nano-second part breaks row

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 0.10.0
    • 0.10.0
    • None

    Description

      Timestamp values are reading additional one byte if nano-sec part is zero, breaking following columns.

      >create table timestamp_1 (t timestamp, key string, value string);
      >insert overwrite table timestamp_1 select cast('2011-01-01 01:01:01' as timestamp), key, value from src limit 5;
      
      >select t,key,value from timestamp_1;
      2011-01-01 01:01:01		238
      2011-01-01 01:01:01		86
      2011-01-01 01:01:01		311
      2011-01-01 01:01:01		27
      2011-01-01 01:01:01		165
      
      >select t,key,value from timestamp_1 distribute by t;
      2011-01-01 01:01:01		
      2011-01-01 01:01:01		
      2011-01-01 01:01:01		
      2011-01-01 01:01:01		
      2011-01-01 01:01:01		
      

      Attachments

        1. hive-3090.1.patch.txt
          5 kB
          Edward Capriolo
        2. hive-3090.1.patch.txt
          5 kB
          Edward Capriolo

        Activity

          People

            navis Navis Ryu
            navis Navis Ryu
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: