Comet writer to respect `object_store_settings` sent from Scala

[comphead]

What is the problem the feature request solves?

Comet writer gets created with default hadoop settings which works for test home distributed clusters, however it should also respect hadoop settings configured by user, the same way it is done for native scans

Describe the potential solution

No response

Additional context

No response