[
https://issues.apache.org/jira/browse/HUDI-8677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Y Ethan Guo updated HUDI-8677:
------------------------------
Parent: HUDI-8724
Issue Type: Sub-task (was: Bug)
> Hive is not displaying the timestamp value in micro seconds
> -----------------------------------------------------------
>
> Key: HUDI-8677
> URL: https://issues.apache.org/jira/browse/HUDI-8677
> Project: Apache Hudi
> Issue Type: Sub-task
> Components: hive
> Reporter: Ranga Reddy
> Priority: Critical
> Labels: hive, sql
> Fix For: 1.0.1
>
>
> When we query the hudi table using Hive engine, in hive micro seconds value
> are truncated.
> Steps to reproduce the issue:
> {code:java}
> create table test_timestamp(id int, time timestamp) using hudi;
> insert into test_timestamp values(1,timestamp('2024-11-28 12:00:00.123456'));
> select time from test_timestamp;
> {code}
>
> *Result from spark:*
> {code:java}
> 2024-11-28 12:00:00.123456{code}
> *Result from hive:*
> {code:java}
> 2024-11-28 12:00:00.123{code}
> More details - https://github.com/apache/hudi/issues/12370
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
