【 使用环境 】测试环境
【 OB 】
【 使用版本 】
【问题描述】按文档操作,但LOAD DATA还是报错File not exist(我参考的文档是https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000639657)
$ whoami
admin
$
$ cat /home/admin/dbgen_version_1_10.dat
3.2.0|2025-12-23|17:44:28|-SCALE 100 -PARALLEL 10 -CHILD 1 -TERMINATE N -DIR /home/test/tpcds/bin/tpcds-data
$
$
$ obclient -S /home/OceanBase/oceanbase/run/sql.sock -u****** -p****** -P4881
obclient(root@cluster1)[(none)]> SHOW VARIABLES LIKE ‘secure_file_priv’;
±-----------------±------------+
| Variable_name | Value |
±-----------------±------------+
| secure_file_priv | /home/admin |
±-----------------±------------+
1 row in set (0.002 sec)
obclient(root@cluster1)[(none)]> LOAD DATA /*+ direct(true,1024) parallel(16) */ infile ‘/home/admin/dbgen_version_1_10.dat’ into table dbgen_version fields terminated by ‘|’;
ERROR 1017 (HY000): File not exist


