hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3090) Timestamp type values not having nano-second part breaks row
Date Wed, 13 Jun 2012 05:54:43 GMT

     [ 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

        

Mime
View raw message