Hive is not displaying the timestamp value in micro seconds

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

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-8677
- Type: Sub-task
- Parent: https://issues.apache.org/jira/browse/HUDI-9113
- Fix version(s):
- 1.1.0