[Feature] SparkGenericCatalog can only use the hive warehouse dir, and cannot use the paimon warehouse dir to isolate it from the hive warehouse dir

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.

### Motivation

When creating Hive Catalog in Paimon, Flink can specify the Paimon-specific Warehouse Dir, but the Hive Catalog created by SparkCatalog in SparkGenericCatalog cannot specify the Paimon-specific Warehourse Dir. The functions of the two should be consistent to provide better user experience.

### Solution

Add the spark.sql.paimon.warehourse.dir configuration option to support SparkGenericCatalog configuration Paimon Warehouese Dir

### Anything else?

_No response_

### Are you willing to submit a PR?

- [X] I'm willing to submit a PR!

Start at SparkGenericCatalog and trace how its Hive Catalog warehouse directory is configured. Check the existing Flink-specific warehouse behavior and identify where the spark.sql.paimon.warehourse.dir option should be read. Done means SparkGenericCatalog can use a Paimon-specific warehouse directory independently of the Hive warehouse directory.

Written by the indexing model from the issue text.