load data infile 的时候报 location leader not exist

培训中心 实战分享
#1

部署环境 obproxy+3zone

TPC-H 在zone1 加载数据的时候报错location leader not exist

cmd_str=""" obclient -h%s -P%s -u%s@%s -c -D%s -e “load data /*+ parallel(80) */ infile ‘%s/orders.tbl’ into table orders fields terminated by ‘|’;” “”" %(hostname,port,user,tenant,db_name,data_path) result = commands.getstatusoutput(cmd_str) print result

#2


参考文档https://open.oceanbase.com/docs/community/oceanbase-database/V3.1.1/load-data

注意2点:

  1. 数据需要放到observer的机器上
SET GLOBAL secure_file_priv = ""