[
https://issues.apache.org/jira/browse/HIVE-3090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Capriolo updated HIVE-3090:
----------------------------------
Status: Open (was: Patch Available)
Are you sure you have the most recent patch? I am not seeing the expected
results. Please upload the patch to Jira.
[edward@tablitha trunk]$ diff -y
/home/edward/hive/trunk/build/ql/test/logs/clientpositive/timestamp_lazy.q.out
/home/edward/hive/trunk/ql/src/test/results/clientpositive/timestamp_lazy.q.out
POSTHOOK: Lineage: timestamp_lazy.value SIMPLE [(src)src.Fiel POSTHOOK:
Lineage: timestamp_lazy.value SIMPLE [(src)src.Fiel
2011-01-01 01:01:01 | 2011-01-01
01:01:01 238 val_238
2011-01-01 01:01:01 | 2011-01-01
01:01:01 86 val_86
2011-01-01 01:01:01 | 2011-01-01
01:01:01 311 val_311
2011-01-01 01:01:01 | 2011-01-01
01:01:01 27 val_27
2011-01-01 01:01:01 | 2011-01-01
01:01:01 165 val_165
> 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
