stalary opened a new issue #4989:
URL: https://github.com/apache/incubator-doris/issues/4989
**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.
I1129 15:22:51.790351 90353 es_scroll_query.cpp:137] Generated ES queryDSL [
{"query":{"bool":{"filter":[{"bool":{"should":[{"term":{"deleted":"1"}}]}}]}},"stored_fields":"_none_","docvalue_fields":["userId","courseId","groupId","syncedAt","deleted"],"sort":["_doc"],"size":10}
]
**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
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
