I'm trying to use Amazon Redshift Spectrum to query some data that are on S3. I've created an external table on data stored in Parquet (about 5 GB of data).
Every time I try to run a simple query like the one below I get the error: Out Of Memory
SELECT col1,col2,col3,col4 FROM spectrum.mytable WHERE col1<>'' AND col2<>'' LIMIT 100;
Am I doing something wrong? I'm running a Redshift cluster with 2 nodes of type dc1.large ( 15 GiB of Memory each!)