[CALCITE-6274] Join Elasticsearch index return empty list

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available

Environment

calcite 1.35.0

elasticsearch 7.x

• Assignee: Unassigned
• Reporter: zhaowang
• Created: 20/Feb/24 12:48
• Updated: 28/Feb/24 06:03

Description

Two index of Elasticsearch join return empty result even if the data from both indexes can match。

create index test_01:

PUT /test_01/_doc/1
{
  "doc_id" : 1,
  "doc_desc" : "doc01"
} 

create index test_02:

PUT /test_02/_doc/1
{
  "doc_id" : 1,
  "doc_score" : 90
} 

execute sql:

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) 

One row of result was expected, but actually get empty. 
 
 
 
 

 

 

Issue Links

• links to: GitHub Pull Request #3696