query getting killed in redshift

0
votes

I'm executing one select statement on Redshift, my table contain around 56 million records. The issue after executing for a minute the query is getting killed by the system. On the command prompt message is showing as Killed and on the AWS console the status is incomplete.

Can anybody tells what can be the reason.

The cluster specification is below:

Current Node Type:  dw1.xlarge
CPU:                4.4 EC2 Compute Units (2 virtual cores) per node
Memory:             15 GiB per node
Storage:Disk        2TB HDD storage per node
I/O Performance:    Moderate
Platform:           64-bit
2
amazon-web-servicesamazon-redshift
Were you able to solve this problem? I am having the exact same problem. – gmemon
No, Im still facing the same problem. – DJo
Hi gmemon, have you got any solution for this ? – DJo
It turns out that the query was returning too many results and different clients (e.g., psql, jdbc clients) were not displaying the proper error message. – gmemon
It could be because of statement timeout configuration or WLM docs.aws.amazon.com/redshift/latest/dg/r_statement_timeout.html – Kishan Pandey

2 Answers

0
votes

You've haven't given us enough info to help much. :( It sounds like your query has a problem that prevents it from completing. Please add more detail about the query and the tables being queried.

0
votes

Is Workload management configured on the cluster? http://docs.aws.amazon.com/redshift/latest/dg/cm-c-defining-query-queues.html

If it's exactly 1 minute every time, it's possible you are running your query in a queue with a timeout