[
https://issues.apache.org/jira/browse/CALCITE-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17929763#comment-17929763
]
Yu Xu edited comment on CALCITE-6274 at 2/24/25 1:33 PM:
---------------------------------------------------------
Hi [~julianhyde] [~mbudiu] ，I also test and found the problem，join in
elasticsearch would return a empty result due to the way of getting filed name
is not right currently，but the related pr is stale for one more year，can I
continue for the issue with submit a new pr？
was (Author: JIRAUSER307770):
Hi [~julianhyde]，I also test and found the problem，join in elasticsearch would
return a empty result due to the way of getting filed name is not right
currently，but the related pr is stale for one more year，can I continue for the
issue with submit a new pr？
> 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)
