Hello experts. During an INSERT from SELECT clause, I encounter issues like Non-NULL meeting NULL, VARCHAR(20) meeting VARCHAR(36), etc., leading to failed insertions. Is there a method to proceed with the INSERT but divert the rejected data into a secondary table, perhaps using COPY? Thanks!
Question
Do you know?
+1we dont have that feature for insert select. if you use copy , then you can specify rejected data table clause.
+1Either export the source table to CSV using the EXPORT TO DELIMITED command, then re-import using COPY, as @SruthiA mentioned.
Or :
Start with INSERT INTO tgt SELECT * FROM src;
For each error you encounter, add a WHERE condition that eliminates the offending rows:WHERE a_column IS NOT NULLWHERE OCTET_LENGTH(another_column) <= 20
etc.
ThenCREATE TABLE tgt_errors AS SELECT * FROM src WHERE... ... and add the reverse of the WHERE condition used before.
Tedious and manual - but remains within the database .
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
