[
https://issues.apache.org/jira/browse/CALCITE-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-6274:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
>
> 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)
