JDBC connection lost while UNLOADing from Redshift to S3. What should happen? -
reshift newbie here - greetings! trying unload data s3 redshift, using java program running locally issues unload statement on jdbc connection. @ point jdbc connection appears lost on end (exception caught). however, looking @ s3 location, seems unload runs completion. true unloading rather small set of data. question is, in principle, how unload supposed behave in case of lost connection (say, firewall kills or kill -9 on process executes unload)? run completion? stop senses connection lost? have been unable find answer neither rtfm'ing, nor googling... thank you!
the unload
run until completes, cancelled, or encounters error. loss of issuing connection not interpreted cancel.
the statement can cancelled on separate connection using cancel
or pg_cancel_backend
.
http://docs.aws.amazon.com/redshift/latest/dg/r_cancel.html http://docs.aws.amazon.com/redshift/latest/dg/pg_cancel_backend.html
wiki
Comments
Post a Comment