Skip to content
New issue

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

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

Already on GitHub? Sign in 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;

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

No branches or pull requests

2 participants