--通过show load查看到报错ErrorMsg如下:
type:LOAD_RUN_FAIL; msg:errCode = 2, detailMessage = (..84.153)[INTERNAL_ERROR]cur path: s3://lakehouse/hive-ha/ads.db/ads_xinghe_library_acc/part-00283-e54fcb1b-6732-48bf-b4fd-c03e747cf2a8-c000.snappy.parquet. failed to read: curlCode: 6, Couldn't resolve host name code=-1 type=99, request_id=
状态是CANCELLED被取消掉了
--load 语句如下:
LOAD LABEL test.ads_xinghe_library_acc_test_label_20250721_03
(
DATA INFILE("s3://lakehouse/hive-ha/ads.db/ads_xinghe_library_acc/")
INTO TABLE ads_xinghe_library_acc_test
FORMAT AS "parquet"
)
WITH S3 -- 使用S3协议直连
(
"provider" = "S3",
"AWS_ENDPOINT" = "http://d-ceph-ssd-inside.pjlab.org.cn",
"AWS_ACCESS_KEY" = "",
"AWS_SECRET_KEY" = "****",
"AWS_REGION" = "local",
"use_path_style" = "true",
"use_http" = "true",
"compress_type" = "SNAPPY"
)
PROPERTIES
(
"timeout" = "7200",
"max_filter_ratio" = "0.1",
"exec_mem_limit" = "17179869184",
"load_parallelism" = "21",
"strict_mode" = "false"
);
在Doris集群节点 ping了下d-ceph-ssd-inside.pjlab.org.cn也是通的,只不过每次ping出来的ip不一样,是动态的,
另外还有代理:也设置这个跳过了
export no_proxy="$no_proxy,d-ceph-ssd-inside.pjlab.org.cn"
还是不行,现在不知道问题出现在哪里?另外S3是本地模式的,没有region这项,随便填了个local