[BUG] es catalog Unknown table 'default_db.test_indexx1'.

[Jin-H]

Steps to reproduce the behavior (Required)

1. create es catalog

CREATE EXTERNAL CATALOG es7
COMMENT 'es7'
PROPERTIES
(
    "type" = "es",
    "hosts" = "http://ip:9200",
    "es.type" = "_doc"
);

2. show tables

show tables from es7.default_db;

3. query table

select * from es7.default_db.test_indexx1

4. error log

2024-08-10 15:45:57.815+08:00 INFO (starrocks-mysql-nio-pool-2|150) [MetadataMgr$QueryMetadatas.getConnectorMetadata():107] Succeed to register query level connector metadata [catalog:es7, queryId: 94a9051d-56ec-11ef-87c5-8e7f870c087f]
2024-08-10 15:45:57.826+08:00 ERROR (starrocks-mysql-nio-pool-2|150) [ElasticsearchMetadata.toEsTable():94] transform to EsTable Error
java.lang.ClassCastException: class org.json.JSONArray cannot be cast to class org.json.JSONObject (org.json.JSONArray and org.json.JSONObject are in unnamed module of loader 'app')
        at com.starrocks.connector.elasticsearch.EsUtil.parsePropertiesRoot(EsUtil.java:238) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.elasticsearch.EsUtil.parseProperties(EsUtil.java:203) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.elasticsearch.EsUtil.convertColumnSchema(EsUtil.java:122) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.elasticsearch.ElasticsearchMetadata.toEsTable(ElasticsearchMetadata.java:83) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.elasticsearch.ElasticsearchMetadata.getTable(ElasticsearchMetadata.java:76) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.CatalogConnectorMetadata.getTable(CatalogConnectorMetadata.java:134) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.lambda$getTable$5(MetadataMgr.java:485) ~[starrocks-fe.jar:?]
        at java.util.Optional.map(Optional.java:265) ~[?:?]

Expected behavior (Required)

query can be executed.

Real behavior (Required)

StarRocks version (Required)

• 3.3.0-19a3f66