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

Javascript is disabled or is unavailable in your browser.

To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Identifying tables with missing statistics

Connection fails