【详述】hdfs文件导入starrocks报错
【业务影响】尝试一周失败
【StarRocks版本】3.1.14
【集群规模】1个节点 非集群
【联系方式】pangxuebing@sunline.cn
端口8020已开通 plf_activity_people_count 是在hive上建立的外表 在hdfs目录/user/srdata/srdata_ex/plf_activity_people_count可以查询到数据
执行以下语句报错
LOAD LABEL plf_activity_people_count_1
(
DATA INFILE(“hdfs://10.22.82.239:8020/user/srdata/srdata_ex/plf_activity_people_count/*”)
INTO TABLE plf_activity_people_count
columns terminated by “,”
)
WITH BROKER hdfs_broker
(
“hadoop.security.authentication” = “kerberos”,
“kerberos_principal” = “srdata/node01@SUNLINE.CN”,
“kerberos_keytab” = “/home/starrocks/srdata.keytab”
)
- 查询报错：
type:ETL_RUN_FAIL; msg:Broker list path failed. path=hdfs://10.22.82.239:8020/user/srdata/srdata_ex/plf_activity_people_count/*,broker=TNetworkAddress(hostname:10.22.82.119, port:8000),msg=org.apache.hadoop.security.KerberosAuthException: failure to login: for principal: srdata/node01@SUNLINE.CN from keytab /home/starrocks/srdata.keytab javax.security.auth.login.LoginException: Unable to obtain password from user
, cause by: failure to login: for principal: srdata/node01@SUNLINE.CN from keytab /home/starrocks/srdata.keytab javax.security.auth.login.LoginException: Unable to obtain password from user