Navis created HIVE-3090: --------------------------- Summary: Timestamp type values not having nano-second part breaks row Key: HIVE-3090 URL: https://issues.apache.org/jira/browse/HIVE-3090 Project: Hive Issue Type: Bug Components: Serializers/Deserializers Affects Versions: 0.10.0 Reporter: Navis Assignee: Navis Priority: Critical
Timestamp values are reading additional one byte if nano-sec part is zero, breaking following columns. {noformat} >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 {noformat} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira