合适的格式以供YUGABYTEDB YSQL中的交易大小复制

Question

[用户在

问题尺寸？我正在尝试加载1,200万行并收到此错误：

yugabyte=# copy parking_violations from '/home/yugabyte/load_violations.csv' with (FORMAT delimiter ',', csv, header, ROWS_PER_TRANSACTION 10000);
ERROR: syntax error at or near "','"
LINE 1: ...byte/load_violations.csv' with (FORMAT delimiter ',', csv, ...

Answer 1

正确的格式是：

COPY parking_violations from '/home/yugabyte/load_violations.csv' with (FORMAT csv,  DELIMITER ',',  HEADER, ROWS_PER_TRANSACTION 10000);

请参见更多信息：https://docs.yugabyte.com/preview/api/ysql/the-sql-language/statements/cmd_copy/#import-a-large-table-using-较小的交易