Query troubleshooting

This section provides a quick reference for identifying and addressing some of the most common and most serious issues that you are likely to encounter with Amazon Redshift queries.

Topics

• Connection fails
• Query hangs
• Query takes too long
• Load fails
• Load takes too long
• Load data is incorrect
• Setting the JDBC fetch size parameter

These suggestions give you a starting point for troubleshooting. You can also refer to the following resources for more detailed information.

• Accessing Amazon Redshift clusters and databases

• Automatic table optimization

• Loading data in Amazon Redshift

• Tutorial: Loading data from Amazon S3