[CALCITE-5974] Elasticsearch adapter throws ClassCastException when index mapping sets dynamic_templates without properties

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: zhaowang
• Due: 03/Sep/23
• Created: 03/Sep/23 10:12
• Updated: 28/Nov/23 02:49
• Resolved: 21/Sep/23 09:02

Description

When we use the elasticsearch-adapter, as we config an elasticsearch cluster, it will fetchMapping during initialization.

If a index set dynamic_templates bug no mappings like this:
 

{
  "test_index" : {
    "mappings" : {
      "dynamic_templates" : [
        {
          "integers" : {
            "match_mapping_type" : "long",
            "mapping" : {
              "type" : "integer"
            }
          }
        }
      ]
    }
  }
} 

org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties throw exception:

 

java.lang.ClassCastException: 
com.fasterxml.jackson.databind.node.ArrayNode cannot be cast to com.fasterxml.jackson.databind.node.ObjectNode
at
 org.apache.calcite.adapter.elasticsearch.ElasticsearchJson.visitMappingProperties(ElasticsearchJson.java:133)
  

So ElasticsearchTransport initialize failed, all index of this es cluster access failed.

Issue Links

• links to: GitHub Pull Request #3406