hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13779) Fraction of second is lost when you change column from timestamp to string
Date Tue, 24 May 2016 15:50:13 GMT

     [ https://issues.apache.org/jira/browse/HIVE-13779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jesus Camacho Rodriguez updated HIVE-13779:
-------------------------------------------
    Target Version/s:   (was: 1.2.1, 2.1.0)

> Fraction of second is lost when you change column from timestamp to string
> --------------------------------------------------------------------------
>
>                 Key: HIVE-13779
>                 URL: https://issues.apache.org/jira/browse/HIVE-13779
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.2.1, 2.1.0
>            Reporter: Takahiko Saito
>
> I have this table:
> {noformat}
> 0: jdbc:hive2://os-r6-0517-hiveserver2-1-1.op> select s, ts from schemaevo limit 10;
> +-------------------+------------------------+--+
> |         s         |           ts           |
> +-------------------+------------------------+--+
> | david falkner     | 2076-08-03 22:22:45.0  |
> | oscar miller      | 2027-05-23 18:51:23.0  |
> | david xylophone   | 2031-02-07 13:02:38.0  |
> | katie allen       | 2035-04-22 08:02:07.0  |
> | zach johnson      | 2074-02-21 18:25:58.0  |
> | mike brown        | 2029-05-23 04:09:04.0  |
> | luke garcia       | 2059-03-14 12:37:41.0  |
> | xavier garcia     | 2025-04-22 11:23:44.0  |
> | holly laertes     | 2037-01-20 08:02:40.0  |
> | xavier underhill  | 2072-08-16 07:41:05.0  |
> +-------------------+------------------------+--+
> {noformat}
> Then run the followings:
> {noformat}
> set hive.metastore.disallow.incompatible.col.type.changes = false;
> drop table if exists shcemaevo_vectorization_true_fileformat_orc_timestamp_string;
> create table shcemaevo_vectorization_true_fileformat_orc_timestamp_string stored as orc
as select s, ts from schemaevo;
> alter table shcemaevo_vectorization_true_fileformat_orc_timestamp_string change column
ts ts string;
> {noformat}
> The below shows that the changed column lose fraction of second:
> {noformat}
> 0: jdbc:hive2://os-r6-0517-hiveserver2-1-1.op> select * from shcemaevo_vectorization_true_fileformat_orc_timestamp_string
limit 10;
> +-----------------------------------------------------------------+------------------------------------------------------------------+--+
> | shcemaevo_vectorization_true_fileformat_orc_timestamp_string.s  | shcemaevo_vectorization_true_fileformat_orc_timestamp_string.ts
 |
> +-----------------------------------------------------------------+------------------------------------------------------------------+--+
> | david falkner                                                   | 2076-08-03 22:22:45
                                             |
> | oscar miller                                                    | 2027-05-23 18:51:23
                                             |
> | david xylophone                                                 | 2031-02-07 13:02:38
                                             |
> | katie allen                                                     | 2035-04-22 08:02:07
                                             |
> | zach johnson                                                    | 2074-02-21 18:25:58
                                             |
> | mike brown                                                      | 2029-05-23 04:09:04
                                             |
> | luke garcia                                                     | 2059-03-14 12:37:41
                                             |
> | xavier garcia                                                   | 2025-04-22 11:23:44
                                             |
> | holly laertes                                                   | 2037-01-20 08:02:40
                                             |
> | xavier underhill                                                | 2072-08-16 07:41:05
                                             |
> +-----------------------------------------------------------------+------------------------------------------------------------------+--+
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message