[
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)
