[Bug] 'Unsupported exec type in pipeline: ES_HTTP_SCAN_NODE' when query es catalog #21853

Search before asking

• I had searched in the issues and found no similar issues.

Version

Doris version is 2.0-beta. When I use master (2023-07-16), this bug still exists.

What's Wrong?

When I query es catalog, doris will return the following error: 'Unsupported exec type in pipeline: ES_HTTP_SCAN_NODE'.

If add ES_HTTP_SCAN_NODE in be/src/pipeline/pipeline_fragment_context.cpp:_build_pipelines, then query es catalog's test1 table, Doris will return the following error:

1. select test7 from test1; -> Expected value of type: DATETIMEV2; but found type: Number; Document slice is : 1659931810000
2. select c_keyword from test1; -> UNAVAILABLE: Network closed for unknown reason. (BE crash)

What You Expected?

return normally

How to Reproduce?

1. use doris docker command to start es: cd doris/docker/thirdparties; sh run-thirdparties-docker.sh -c es
2. CREATE CATALOG es PROPERTIES ( "type"="es", "hosts"="http://127.0.0.1:29200");
3. switch es; show tables; select test7 from test1;
4. select test8 from test1;
5. select c_keyword from test1;

Anything Else?

Other relate issue is : #21847

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct