[
https://issues.apache.org/jira/browse/CALCITE-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated CALCITE-6274:
-----------------------------------------
Summary: Join between Elasticsearch indexes returns empty result (was: Two
Elasticsearch index join return empty result)
> Join between Elasticsearch indexes returns empty result
> -------------------------------------------------------
>
> 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
> Fix For: 1.39.0
>
>
> 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)
