[Feature]: Provide ability to impersonate to the owner of each table when optimizing

[byungnam]

Description

Currently, Amoro uses the specified UGI - typically, superuser for the optimization tasks. This results in the output files of the optimization task being owned by the superuser instead of the actual owner of the table.

Use case/motivation

No response

Describe the solution

Make an option on catalog which enables impersonation to the owner of each table. If this option is enabled, optimize task will be run with impersonation to the owner of each table.

Subtasks

No response

Related issues

No response

Are you willing to submit a PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

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

[majin1102]

The feature seems reasonable.

I wonder whether properties on catalog could solve this situation. Could each table be owned by different owner?

[byungnam]

I wonder whether properties on catalog could solve this situation. Could each table be owned by different owner?

It should be a boolean parameter whether you want to create files with the owner of each table or not. It should not specify any user in catalog property.

[github-actions[bot]]

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[bot]]

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