更新时间:2023-11-02 12:48:10
如果不使用LOCAL
修饰符,它将访问服务器上的文件.将查询更改为:
If you don't use the LOCAL
modifier, it accesses the file on the server. Change your query to:
LOAD DATA LOCAL INFILE '/workspace/SQL_Test/src/values.csv'
INTO TABLE queryid_vs_column
COLUMNS TERMINATED BY ','