[HUDI-2057] CTAS Generate An External Table When Create Managed Table

[dongkelun]

trafficstars

This problem has been fixed in this PR before：https://github.com/apache/hudi/pull/3146

Later, the problem was discovered again，But it was fixed by this pr: https://github.com/apache/hudi/pull/3998

The last time this problem reappeared was due to this pr: https://github.com/apache/hudi/pull/5178,The reason is that extraoptions is not transferred to spark conf

Change Logs

Describe context and summary for this change. Highlight if any code was copied.

Impact

Describe any public API or user-facing feature change or any performance impact.

Risk level: none | low | medium | high

Choose one. If medium or high, explain what verification was done to mitigate the risks.

Contributor's checklist

• [ ] Read through contributor's guide
• [ ] Change Logs and Impact were stated clearly
• [ ] Adequate tests were added if applicable
• [ ] CI passed

[dongkelun]

@hudi-bot run azure

[nsivabalan]

@xushiyan : can you assist the author and help take this home.

[hudi-bot]

CI report:

• 5c1cb2151993df9a20cf4f98d56178cf5825b00c Azure: FAILURE

Bot commands

@hudi-bot supports the following commands:

• @hudi-bot run azure re-run the last Azure build

[hudi-bot]

CI report:

• cfd205621d6e0b2e400367a8c44081a9d8780e07 Azure: SUCCESS

Bot commands

@hudi-bot supports the following commands:

• @hudi-bot run azure re-run the last Azure build

[dongkelun]

@yihua @xushiyan Hello, I have added the validation to test the CTAS table type