Skip to content

[Doris On ES][Bug] Doris On Es Boolean Field Push Down error #4989

@stalary

Description

@stalary

Describe the bug
When I create an ES external and use a Boolean field, where if this field is used, the query for ES will report an error.

[42000][1064] errCode = 2, detailMessage = Failed to connect to ES server, errmsg is: The requested URL returned error: 400 Bad Request

To Reproduce

  1. CREATE
    EXTERNAL TABLE es_dwd_student_stat (
    userId varchar(255) NULL COMMENT "用户id",
    courseId bigint(20) NULL COMMENT "课程id",
    groupId bigint(20) NULL COMMENT "组id",
    syncedAt datetime NULL COMMENT "同步时间",
    deleted boolean NULL COMMENT "是否删除"
    ) ENGINE=ELASTICSEARCH

  2. select * from es_dwd_student_stat where deleted=true;

Expected behavior
deleted push down should be true

Version

  • Version 0.13.11

Metadata

Metadata

Assignees

Labels

area/doris-on-esIssues or PRs related to Doris on ElasticSearchkind/fixCategorizes issue or PR as related to a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions