[Bug]: data-expire obtained upperbound time is 8 hours later than the data time.

[Aireed]

What happened?

id	name	ts	dt
3	name-3	2023-12-22 14:30:45	2023-12-22
4	name-4	2023-12-22 14:30:45	2023-12-22
5	name-5	2023-12-22 14:30:45	2023-12-22
2	name-1	2023-12-22 14:30:45	2023-12-22
6	name-6	2023-12-22 14:30:45	2023-12-22
Time taken: 0.474 seconds, Fetched 5 row(s)

upperbounds of file: 2023-12-22T22:30:45+08:00, real timestamp is 2023-12-22 14:30:45

Affects Versions

master

What table formats are you seeing the problem on?

Mixed-Hive

What engines are you seeing the problem on?

AMS

How to reproduce

1、create a mixed_hive table with data-expire properties like below

2、use spark engine to insert into records with ts which less than 1 minute from the current time
3、restart ams , and check the data whether is expire

Relevant log output

Anything else

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'