[SUPPORT] How to set timezone for "_hoodie_commit_time" column?

[esaeki]

I use Glue and Hudi to replicate databases in AWS environment.
Regarding "_hoodie_commit_time" column of Hudi table, I would like to set timezone to UTC+9:00. (e.g. 202112170222425 →　20211217112425)

How can I set the timezone for this column? I already set "hoodie.deltastreamer.keygen.timebased.timezone" to UTC+9:00 and GMT+9:00, but there was no change.

[nsivabalan]

commit time is what hudi generates internally. don't think its customizable.

[nsivabalan]

May I know whats the use-case.

[esaeki]

Thank you for your response.
I develop datalake for Japanese client, and Japan's standard time zone is UTC +9 hours. That's why, it's better to adjust the timezone for proper data management.
I would appreciate if you tell me an alternative for this.

[leesf]

Thank you for your response. I develop datalake for Japanese client, and Japan's standard time zone is UTC +9 hours. That's why, it's better to adjust the timezone for proper data management. I would appreciate if you tell me an alternative for this.

@esaeki Can this PR(#4306) solve the issue?

[esaeki]

Thank you for writing in. I will check it out.

[nsivabalan]

glad to know we have a PR on this. thanks for the update.
Will close the github issue as we have a PR out.

[leesf]

Thank you for writing in. I will check it out.

@esaeki hi, can the PR #4306 solve your problem?

[esaeki]

Yeah. Customizing "_hoodie_commit_time" column is the best solution, but it's ok.