Load catalog 'bi_31' but give me catalog 'hive'

### Question

I use the following code to load the catalog 'bi_31', but it always ends up loading the 'hive' catalog. Does it only support loading the default catalog?

````
catalog_config = {
"type":"hive",
'uri': "thrift://10.108.*.*:32087",
'warehouse': "s3a://*/*-*-c046a938/bi_31",
's3.endpoint': "https://ecs01.*.com:9021",
's3.access-key-id': "AKIA7EB2AEE90E****",
's3.secret-access-key': "yde7zJK84b4nQEU/95epyi7l****",
}
catalog = load_catalog(name="bi_31", **catalog_config)
````

Environment Details：
PyIceberg Version: 0.10.0
PyArrow Version: 21.0.0
Boto3 Version: 1.34.54
Python Version: 3.10.1

Any answers or help would be greatly appreciated.

Begin with the load_catalog entry point and trace how the supplied name and type are handled; the issue names no repository file or test. Reproduce the example with the provided catalog_config and verify which catalog is selected. Done means the requested bi_31 catalog is loaded unambiguously, or the behavior is clearly documented.

Written by the indexing model from the issue text.