【详述】其他服务器10.22.82.239目录/data/srdata下文件导入starrocks报错
如何目录建立在starrocks安装节点10.22.86.119上可以成功导入，但是需要导入其他服务器的数据
【StarRocks版本】3.1.14
【集群规模】单机测试
【联系方式】pangxuebing@sunline.cn
LOAD LABEL plf_activity_people_count_20251020
(
DATA INFILE(“file:///data/srdata/dashboards/plf_activity_people_count_20251014.csv”)
INTO TABLE plf_activity_people_count
COLUMNS TERMINATED BY “|” – 明确分隔符为竖线
FORMAT AS “CSV”
(
prim_key,
act_no,
act_nm,
invi_cust,
upto_cust,
gift_get_cust,
gift_use_cust,
invi_num,
upto_num,
gift_get_num,
gift_use_num,
stop_updt_tm,
etl_date,
creat_tm
)
)
WITH BROKER hdfs_broker
(
“host” = “10.22.82.239”, – 关键：文件所在服务器的IP或主机名
“username” = “root”, – 目标服务器的登录用户名
“password” = “” – 目标服务器的登录密码
)
PROPERTIES
(
– 移除重复的format配置，与FORMAT AS "CSV"冲突
“max_filter_ratio” = “0.01”,
“timeout” = “3600”
);
- 查询报错：
type:ETL_RUN_FAIL; msg:No files were found matching the pattern(s) or path(s): ‘file:///data/srdata/dashboards/plf_activity_people_count_20251014.csv’