[ 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)