doris on es create table 成功，select failed to connect es server port 80 refuesd

[lvweiwei007]

CREATE EXTERNAL TABLE test_es1 (

gctp2 varchar(500),

gctp3 varchar(500),

lhy_zt varchar(30),

gctp1 varchar(500),

hpzl varchar(10),

lhy_clpp2 varchar(20),

lhy_clpp1 varchar(20),

bmmc varchar(50),

sbmc varchar(50),

sjly bigint,

gcbh varchar(20),

hpys varchar(10),

scsj datetime,

lhy_syxz varchar(20) ,

cllx varchar(10),

id varchar(50),

csys varchar(10),

cdh smallint,

sj_lhy varchar(20),

jrsj datetime,

wfdm varchar(10),

dlmc varchar(200),

rkhs bigint,

dwbh varchar(50),

ffsj datetime,

hjhs bigint,

hphm varchar(10),

dldm varchar(10),

glbm varchar(20),

dwmc varchar(500),

lhy_qzbfqz varchar(20),

sbxh varchar(20),

sd float,

clsd float,

lhy_cllx varchar(20),

xsz int,

sbbh varchar(20),

cwkc float,

jrhs bigint,

ffhs bigint,

jgsj datetime,

lhy_syr varchar(20),

rksj datetime,

lhy_csys varchar(20),

hjsj datetime,

fxlx varchar(10),

lhy_sjhm varchar(50),

lhy_xzqh varchar(20),

lhy_clxh varchar(50),

lhy_state_lhy varchar(20),

csb int,

lhy_sfzmhm varchar(20),

lhy_yxqz varchar(20),

state_lhy varchar(50)

) ENGINE=ELASTICSEARCH

PROPERTIES (

"hosts" = "http://es1.zyjj:9200",

"index" = "veh_pass202110",

"type" = "doc",

"user" = "elastic",

"password" = "ela123456"

);