skip bad record in redshift data load

I am trying to load data into AWS redshift using following command

copy venue from 's3://mybucket/venue'
credentials 'aws_access_key_id=<access-key-id>;aws_secret_access_key=<secret-access-key>'
delimiter '\t';

but data load is failing, when I checked Query section for that specific load I noticed it failed because of "Bad UTF8 hex sequence: a4 (error 3)"

Is there a way to skip bad records in data load into redshift?

Answers


Yes, you can use the maxerror parameter. This example will allow up to 250 bad records to be skipped (the errors are written to stl_load_errors):

copy venue from 's3://mybucket/venue' credentials 'aws_access_key_id=;aws_secret_access_key=' delimiter '\t' maxerror as 250;

Need Your Help

asp.net mvc4 jquery not working

jquery asp.net-mvc razor

I'm trying to run a jquery code which was put in my _Layout.cshtml as below:

How do I make a universal iPhone / iPad application that programmatically uses UISplitViewController and UINavigationController?

iphone cocoa-touch ipad uisplitviewcontroller

I couldn't find a good answer anywhere to this. I am using a UINavigationController for my iPhone app, with everything is generated programmatically, nothing in Interface Builder. I am trying to ...