[jira] [Updated] (CALCITE-6274) Join Elasticsearch index return empty list

2024-02-20 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-6274:
--
Environment: 
calcite 1.35.0

elasticsearch 7.x

> Join Elasticsearch index return empty list
> --
>
> Key: CALCITE-6274
> URL: https://issues.apache.org/jira/browse/CALCITE-6274
> Project: Calcite
>  Issue Type: Bug
> Environment: calcite 1.35.0
> elasticsearch 7.x
>Reporter: zhaowang
>Priority: Major
>
> Two index of Elasticsearch join return empty result even if the data from 
> both indexes can match。
> create index test_01:
> {code:java}
> PUT /test_01/_doc/1
> {
>   "doc_id" : 1,
>   "doc_desc" : "doc01"
> } {code}
> create index test_02:
> {code:java}
> PUT /test_02/_doc/1
> {
>   "doc_id" : 1,
>   "doc_score" : 90
> } {code}
> execute sql:
> {code:java}
> select * from es.test_01 t1 join es.test_02 t2 on cast(t1._MAP['doc_id'] as 
> bigint) = cast(t2._MAP['doc_id'] as bigint) {code}
> One row of result was expected, but actually get empty. 
>  
>  
>  
>  
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-6274) Join Elasticsearch index return empty list

2024-02-20 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-6274:
--
Description: 
Two index of Elasticsearch join return empty result even if the data from both 
indexes can match。

create index test_01:
{code:java}
PUT /test_01/_doc/1
{
  "doc_id" : 1,
  "doc_desc" : "doc01"
} {code}
create index test_02:
{code:java}
PUT /test_02/_doc/1
{
  "doc_id" : 1,
  "doc_score" : 90
} {code}
execute sql:
{code:java}
select * from es.test_01 t1 join es.test_02 t2 on cast(t1._MAP['doc_id'] as 
bigint) = cast(t2._MAP['doc_id'] as bigint) {code}
One row of result was expected, but actually get empty. 
 
 
 
 

 

 

> Join Elasticsearch index return empty list
> --
>
> Key: CALCITE-6274
> URL: https://issues.apache.org/jira/browse/CALCITE-6274
> Project: Calcite
>  Issue Type: Bug
>Reporter: zhaowang
>Priority: Major
>
> Two index of Elasticsearch join return empty result even if the data from 
> both indexes can match。
> create index test_01:
> {code:java}
> PUT /test_01/_doc/1
> {
>   "doc_id" : 1,
>   "doc_desc" : "doc01"
> } {code}
> create index test_02:
> {code:java}
> PUT /test_02/_doc/1
> {
>   "doc_id" : 1,
>   "doc_score" : 90
> } {code}
> execute sql:
> {code:java}
> select * from es.test_01 t1 join es.test_02 t2 on cast(t1._MAP['doc_id'] as 
> bigint) = cast(t2._MAP['doc_id'] as bigint) {code}
> One row of result was expected, but actually get empty. 
>  
>  
>  
>  
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-6274) Join Elasticsearch index return empty list

2024-02-20 Thread zhaowang (Jira) 
zhaowang created CALCITE-6274:
-

 Summary: Join Elasticsearch index return empty list
 Key: CALCITE-6274
 URL: https://issues.apache.org/jira/browse/CALCITE-6274
 Project: Calcite
  Issue Type: Bug
Reporter: zhaowang






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-11-27 Thread zhaowang (Jira) 


[ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17790057#comment-17790057
 ] 

zhaowang commented on CALCITE-5974:
---

[~libenchao] I think Wang Zhao would be better.
 

> Elasticsearch adapter throws ClassCastException when index mapping sets 
> dynamic_templates without properties
> 
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>  Labels: pull-request-available
> Fix For: 1.36.0
>
>
> 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:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
> {{org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties}}
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-09-17 Thread zhaowang (Jira) 


[ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766110#comment-17766110
 ] 

zhaowang commented on CALCITE-5974:
---

Ok, I've already add unit test , [~julianhyde].

> Elasticsearch adapter throws ClassCastException when index mapping sets 
> dynamic_templates without properties
> 
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>  Labels: pull-request-available
>
> 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:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
> {{org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties}}
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-09-15 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang reassigned CALCITE-5974:
-

Assignee: (was: zhaowang)

> Elasticsearch adapter throws ClassCastException when index mapping sets 
> dynamic_templates without properties
> 
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>  Labels: pull-request-available
>
> 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:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
> {{org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties}}
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-09-09 Thread zhaowang (Jira) 


[ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763362#comment-17763362
 ] 

zhaowang commented on CALCITE-5974:
---

It's looks much more suitable, I will modify github issue.

> Elasticsearch adapter throws ClassCastException when index mapping sets 
> dynamic_templates without properties
> 
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Assignee: zhaowang
>Priority: Major
>
> 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:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
> {{org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties}}
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) Elasticsearch adapter fetch mapping error when index mapping set dynamic_templates without properties

2023-09-08 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Summary: Elasticsearch adapter fetch mapping error when index mapping set 
dynamic_templates without properties  (was: Elasticsearch adapter find mapping 
error when index mapping set dynamic_templates without properties)

> Elasticsearch adapter fetch mapping error when index mapping set 
> dynamic_templates without properties
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Assignee: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) Elasticsearch adapter find mapping error when index mapping set dynamic_templates without properties causing bug

2023-09-08 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Summary: Elasticsearch adapter find mapping error when index mapping set 
dynamic_templates without properties causing bug  (was: Es index mapping set 
dynamic_templates without properties causing bug)

> Elasticsearch adapter find mapping error when index mapping set 
> dynamic_templates without properties causing bug
> 
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Assignee: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) Elasticsearch adapter find mapping error when index mapping set dynamic_templates without properties

2023-09-08 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Summary: Elasticsearch adapter find mapping error when index mapping set 
dynamic_templates without properties  (was: Elasticsearch adapter find mapping 
error when index mapping set dynamic_templates without properties causing bug)

> Elasticsearch adapter find mapping error when index mapping set 
> dynamic_templates without properties
> 
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Assignee: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Assigned] (CALCITE-5974) Es index mapping set dynamic_templates without properties causing bug

2023-09-04 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang reassigned CALCITE-5974:
-

Assignee: zhaowang

> Es index mapping set dynamic_templates without properties causing bug
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Assignee: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Commented] (CALCITE-5974) Es index mapping set dynamic_templates without properties causing bug

2023-09-03 Thread zhaowang (Jira) 


[ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761673#comment-17761673
 ] 

zhaowang commented on CALCITE-5974:
---

[~jhyde]  Thanks! I have improved description. 

> Es index mapping set dynamic_templates without properties causing bug
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) Es index mapping set dynamic_templates without properties causing bug

2023-09-03 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Description: 
When use es-adapter, we config a es cluster, it will fetchMapping during 
initialization.

If a index set dynamic_templates bug no mappings like this:

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

 

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

 
{code:java}
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)
  {code}
So ElasticsearchTransport initialize failed, all index of this es cluster 
access failed.

 

  was:
When use es-adapter, we config a es cluster, it will fetchMapping during 
initialization.

If a index set dynamic_templates bug no mappings like this:

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

 

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

 
{code:java}
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)
  {code}
So ElasticsearchTransport initialize failed, all index of this es cluster 
access failed.

 


> Es index mapping set dynamic_templates without properties causing bug
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) Es index mapping set dynamic_templates without properties causing bug

2023-09-03 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Description: 
When use es-adapter, we config a es cluster, it will fetchMapping during 
initialization.

If a index set dynamic_templates bug no mappings like this:

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

 

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

 
{code:java}
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)
  {code}
So ElasticsearchTransport initialize failed, all index of this es cluster 
access failed.

 

  was:
when use es-adapter, A index set dynamic_templates bug no mappings causing 
exceptions:

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)

 


> Es index mapping set dynamic_templates without properties causing bug
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>
> When use es-adapter, we config a es cluster, it will fetchMapping during 
> initialization.
> If a index set dynamic_templates bug no mappings like this:
>  
> {code:java}
> {
>   "test_index" : {
>     "mappings" : {
>       "dynamic_templates" : [
>         {
>           "integers" : {
>             "match_mapping_type" : "long",
>             "mapping" : {
>               "type" : "integer"
>             }
>           }
>         }
>       ]
>     }
>   }
> } {code}
>  
>  
> org.apache.calcite.adapter.elasticsearch.ElasticsearchJson#visitMappingProperties
>  throw exception:
>  
> {code:java}
> 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)
>   {code}
> So ElasticsearchTransport initialize failed, all index of this es cluster 
> access failed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) Es index mapping set dynamic_templates without properties causing bug

2023-09-03 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Summary: Es index mapping set dynamic_templates without properties causing 
bug  (was: es index mapping set dynamic_templates without properties causing 
bug)

> Es index mapping set dynamic_templates without properties causing bug
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>
> when use es-adapter, A index set dynamic_templates bug no mappings causing 
> exceptions:
> 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)
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (CALCITE-5974) es index mapping set dynamic_templates without properties causing bug

2023-09-03 Thread zhaowang (Jira) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

zhaowang updated CALCITE-5974:
--
Summary: es index mapping set dynamic_templates without properties causing 
bug  (was: fix bug when es index mapping set dynamic_templates without 
properties)

> es index mapping set dynamic_templates without properties causing bug
> -
>
> Key: CALCITE-5974
> URL: https://issues.apache.org/jira/browse/CALCITE-5974
> Project: Calcite
>  Issue Type: Bug
>Affects Versions: 1.35.0
>Reporter: zhaowang
>Priority: Major
>
> when use es-adapter, A index set dynamic_templates bug no mappings causing 
> exceptions:
> 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)
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-5974) fix bug when es index mapping set dynamic_templates without properties

2023-09-03 Thread zhaowang (Jira) 
zhaowang created CALCITE-5974:
-

 Summary: fix bug when es index mapping set dynamic_templates 
without properties
 Key: CALCITE-5974
 URL: https://issues.apache.org/jira/browse/CALCITE-5974
 Project: Calcite
  Issue Type: Bug
Affects Versions: 1.35.0
Reporter: zhaowang


when use es-adapter, A index set dynamic_templates bug no mappings causing 
exceptions:

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)

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)