Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

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

Open
chenfool opened this issue Aug 9, 2023 · 1 comment
Open

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

chenfool opened this issue Aug 9, 2023 · 1 comment

Comments

@chenfool
Copy link

chenfool commented Aug 9, 2023

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
Copy link
Contributor

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;

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants