Add cache for field data types.

Yury-Fridlyand · Yury-Fridlyand · commit d47c624dccd8 · 2023-02-08T20:18:52.000-08:00
Signed-off-by: Yury-Fridlyand &lt;yury.fridlyand@improving.com&gt;
diff --git a/opensearch/src/main/java/org/opensearch/sql/opensearch/storage/OpenSearchIndex.java b/opensearch/src/main/java/org/opensearch/sql/opensearch/storage/OpenSearchIndex.java
@@ -47,7 +47,12 @@ public class OpenSearchIndex implements Table {
   /**
    * The cached mapping of field and type in index.
    */
-  private Map<String, OpenSearchDataType> cachedFieldTypes = null;
+  private Map<String, OpenSearchDataType> cachedFieldOpenSearchTypes = null;
+
+  /**
+   * The cached ExprType of fields.
+   */
+  private Map<String, ExprType> cachedFieldTypes = null;
 
   /**
    * The cached max result window setting of index.
@@ -75,7 +80,6 @@ public void create(Map<String, ExprType> schema) {
     mappings.put("properties", properties);
 
     for (Map.Entry<String, ExprType> colType : schema.entrySet()) {
-      //properties.put(colType.getKey(), OpenSearchDataType.getOpenSearchType(colType.getValue()));
       properties.put(colType.getKey(), colType.getValue().legacyTypeName().toLowerCase());
     }
     client.createIndex(indexName.toString(), mappings);
@@ -93,25 +97,30 @@ public void create(Map<String, ExprType> schema) {
    */
   @Override
   public Map<String, ExprType> getFieldTypes() {
+    if (cachedFieldOpenSearchTypes == null) {
+      cachedFieldOpenSearchTypes = new OpenSearchDescribeIndexRequest(client, indexName)
+          .getFieldTypes();
+    }
     if (cachedFieldTypes == null) {
-      cachedFieldTypes = new OpenSearchDescribeIndexRequest(client, indexName).getFieldTypes();
+      cachedFieldTypes = OpenSearchDataType.traverseAndFlatten(cachedFieldOpenSearchTypes)
+          .entrySet().stream().collect(
+              LinkedHashMap::new,
+              (map, item) -> map.put(item.getKey(), item.getValue().getExprType()),
+              Map::putAll);
     }
-    return OpenSearchDataType.traverseAndFlatten(cachedFieldTypes).entrySet().stream()
-        .collect(
-            LinkedHashMap::new,
-            (map, item) -> map.put(item.getKey(), item.getValue().getExprType()),
-            Map::putAll);
+    return cachedFieldTypes;
   }
 
   /**
    * Get parsed mapping info.
    * @return A complete map between field names and their types.
    */
   public Map<String, OpenSearchDataType> getFieldOpenSearchTypes() {
-    if (cachedFieldTypes == null) {
-      cachedFieldTypes = new OpenSearchDescribeIndexRequest(client, indexName).getFieldTypes();
+    if (cachedFieldOpenSearchTypes == null) {
+      cachedFieldOpenSearchTypes = new OpenSearchDescribeIndexRequest(client, indexName)
+          .getFieldTypes();
     }
-    return cachedFieldTypes;
+    return cachedFieldOpenSearchTypes;
   }
 
   /**
