search

cloudberrydb / bootcamp

Help you quickly try out CloudberryDB via one Docker-based Sandbox
https://cloudberrydb.org/
Apache License 2.0
9 stars 5 forks source link

101-cbdb-tutorials/data-loading Execution failure #5

Open chenfool opened 1 year ago

chenfool commented 1 year ago

The “\i copy_into_wac.sql” command failed to be executed

error message： psql:copy_into_wac.sql:6: ERROR: error table is not supported LINE 1: COPY faa.d_wac FROM STDIN CSV HEADER LOG ERRORS INTO faa.f... ^ HINT: Set gp_ignore_error_table to ignore the [INTO error-table] clause for backward compatibility.

liang8283 commented 1 year ago

The correct command should be following in file copy_into_wac.sql

\COPY faa.d_wac FROM 'L_WORLD_AREA_CODES.csv' CSV HEADER LOG ERRORS SEGMENT REJECT LIMIT 50 ROWS;