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