ddsr-ops edited a comment on issue #5389:
URL:
https://github.com/apache/incubator-doris/issues/5389#issuecomment-966064368
@wuyunfeng Hi, I faced the same question, doris vesion 0.14. Table DDL：
```sql
CREATE EXTERNAL TABLE `gch_test_es` (
`k1` bigint(20) COMMENT "",
`k2` datetime COMMENT "",
`k3` varchar(20) COMMENT "",
`k4` varchar(100) COMMENT "",
`k5` float COMMENT ""
) ENGINE=ELASTICSEARCH
PROPERTIES (
"hosts" =
"http://10.50.253.1:9200,http://10.50.253.2:9200,http://10.50.253.3:9200,http://10.50.253.4:9200,http://10.50.253.5:9200,http://10.50.253.6:9200,http://10.50.253.7:9200";,
"index" = "test1",
"type" = "_doc",
"user" = "",
"password" = ""
);
```
Some error messages appear in the be.log:
```text
I1111 15:20:46.328352 132220 plan_fragment_executor.cpp:76] Prepare():
query_id=ab790c9841ec490b-8d831caf4787fd33
fragment_instance_id=ab790c9841ec490b-8d831caf4787fd34 backend_num=0
I1111 15:20:46.328650 132220 plan_fragment_executor.cpp:138] Using query
memory limit: 2.00 GB
I1111 15:20:46.329373 131971 plan_fragment_executor.cpp:237] Open():
fragment_instance_id=ab790c9841ec490b-8d831caf4787fd34
I1111 15:20:46.329859 250195 es_scroll_query.cpp:135] Generated ES queryDSL
[
{"query":{"match_all":{}},"stored_fields":"_none_","docvalue_fields":["k1","k2","k3.keyword","k4.keyword","k5"],"sort":["_doc"],"size":1024}
]
I1111 15:20:46.330041 250195 es_scan_reader.cpp:102] First scroll request
URL:
datanode1/10.50.253.1:9200/test1/_doc/_search?scroll=5m&preference=_shards:0&filter_path=_scroll_id,hits.total,hits.hits._score,hits.hits.fields&terminate_after=1024
W1111 15:20:46.330574 250195 http_client.cpp:165] fail to execute HTTP
client, errmsg=Failed to connect to datanode1 port 80: Connection refused
W1111 15:20:46.330875 250195 es_scan_reader.cpp:111] Failed to connect to ES
server, errmsg is: Failed to connect to datanode1 port 80: Connection refused
W1111 15:20:46.331095 250195 es_http_scan_node.cpp:445] Scanner[0] process
failed. status=Failed to connect to ES server, errmsg is: Failed to connect to
datanode1 port 80: Connection refused
W1111 15:20:46.333380 131971 fragment_mgr.cpp:220] Got error while opening
fragment ab790c9841ec490b-8d831caf4787fd34: Internal error: Failed to connect
to ES server, errmsg is: Failed to connect to datanode1 port 80: Connection
refused
I1111 15:20:46.333977 131971 plan_fragment_executor.cpp:581] Fragment
ab790c9841ec490b-8d831caf4787fd34:(Active: 1.505ms, non-child: 0.00%)
- AverageThreadTokens: 0.00
- FragmentCpuTime: 134.435us
- MemoryLimit: 2.00 GB
- PeakMemoryUsage: 8.00 KB
- PeakReservation: 0
- PeakUsedReservation: 0
```
Why es request url looks like this, so confused.
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
