【详述】查询opensearch外部表报错[42000][1064] Failed to connect to ES server, errmsg is: The requested URL returned error: 400
【背景】按官方elasticsearch外部表文档操作
【业务影响】
【StarRocks版本】2.5.9
【集群规模】docker部署的1FE 1BE
【机器信息】4C 16G云主机
建表语句
CREATE EXTERNAL TABLE ES_Fortigate
(
user.name STRING,
event.action STRING,
@timestamp STRING
)
ENGINE=ELASTICSEARCH
PROPERTIES
(
“hosts” = “http://172.23.158.70:9200”,
“user” = “”,
“password” = “”,
“index” = “fortigate”,
“type” = “_doc”
);