CODEWITHSUNDEEP
amazon-web-servicesamazon-redshift
prathik vijaykumar
prathik vijaykumar

Reputation: 385

Redshift Queries Limited to 100 mb

I am new to aws redshift I am using redshift cluster (2 nodes ra3.xplus) and while querying few tables (using the query editor), I am getting the following error:

the query result is 105488469 bytes after compression which exceeds the maximum size limit (100 MB)

And the query stops executing. My Idea of redshift was that it is helpful for querying a large amounts of historical data, so why is there a 100mb query limit.

Upvotes: 2

Views: 5001

Answers (1)

53epo
53epo

Reputation: 909

According to the Amazon Redshift query editor documentation there is indeed a 100Mb limit on the amount of data you can download that way. The query editor is web based and its primary purpose is for interactive, relatively smaller queries.

Redshift certainly can handle larger result sets, and for those you'd be better using an UNLOAD to save the data to S3. UNLOAD is designed for larger datasets and automation.

Upvotes: 3

Related Questions